A company wants to build a real-time machine learning model that predicts user engagement based on streaming data from web and mobile platforms. They plan to use Amazon Kinesis for data ingestion. Which additional AWS service should they incorporate to transform and load the streaming data into Amazon Redshift for analysis, while ensuring the process is serverless and scales automatically?