You are preparing a large dataset for analysis and need to ensure the data is clean, consistent, and ready for processing. Which Google Cloud tool would be most appropriate for cleaning, transforming, and enriching this data before loading it into BigQuery?