A retail company is using Amazon Redshift as their data warehouse for analytical queries. They have large volumes of transactional data being generated by their online store and stored in Amazon S3. They want to efficiently load this data into Amazon Redshift for daily batch processing. The company requires a solution that automates data transformation, improves query performance, and reduces operational overhead. Which of the following solutions will best meet the company's requirements?