You are responsible for designing a data pipeline that ingests data from various sources, performs complex transformations, and loads it into a data warehouse. The pipeline should be scalable, fault-tolerant, and support data governance. Which AWS service would you use to build this pipeline, and why?