A logistics company runs a nightly analytics pipeline composed of several dependent steps: extracting data from Cloud SQL, transforming it with a Dataflow job, loading results into BigQuery, and finally triggering a report-generation Cloud Run service. The steps must execute in strict order, with automatic retries on transient failures and clear visibility into which step failed. The team currently chains these steps with brittle cron jobs and shell scripts that offer no dependency management or observability. As the cloud architect, which Google Cloud service should you recommend to orchestrate this multi-step, dependency-aware workflow?