You are tasked with scheduling a series of sequential load and transformation jobs where data files are unpredictably uploaded to a Cloud Storage bucket by an upstream process. A Dataproc job then processes these files, storing the results in BigQuery, followed by various transformation jobs in BigQuery with differing durations. Your objective is to design a workflow that efficiently processes hundreds of tables, ensuring end users always have access to the most current data. How would you achieve this?