In a machine learning project using AWS, you need to perform ETL (Extract, Transform, Load) operations on large datasets stored in Amazon S3 buckets. Your goal is to clean, transform, and load the data into an Amazon Redshift cluster for analysis. Which AWS service should you primarily use to manage and automate these ETL jobs efficiently, and how should you handle the transformed data?