You are tasked with designing a data pipeline that ingests daily transaction logs from Cloud Storage, performs transformations to filter and summarize the data, and loads the result into BigQuery. The pipeline needs to be managed and scheduled to run every night at midnight. Which set of Google Cloud products would best meet these requirements?