About the job
Salary: £28,300
Assessment Centre Dates: June
Start Date: Monday 7th September 2026
Role overview
This Trainee Data Engineer Apprenticeship is based in Manchester and centers on supporting the operations, maintenance, and improvement of interactive investor's Data Platform. Apprentices work alongside experienced Data Engineers, gaining practical experience with data ingestion, transformation, and structuring from sources such as customer activity, transactions, marketing, web analytics, and market feeds. These efforts help drive analytics, Data Science, and machine learning projects across the business.
The role offers hands-on development in Python and SQL, and involves working with data pipelines managed by Dagster. Apprentices deliver data to the Snowflake Data Warehouse and follow established standards for data quality, observability, security, and governance. There are opportunities to present data using Streamlit and Power BI, and to support Intelligent Automation projects that bring AI-assisted steps into business workflows.
Key responsibilities
- Support daily Data Platform operations under supervision, including monitoring scheduled jobs, troubleshooting failures using runbooks, and escalating issues when necessary.
- Contribute to the development and maintenance of ELT/ETL pipelines with Dagster, manage dependencies and alerts, and suggest improvements during code reviews.
- Help build and maintain data warehouse structures such as star schemas, snapshot tables, and slowly changing dimensions with guidance from the team.
- Prepare, test, and document reusable SQL queries and data extracts for Data Analysts and business users, ensuring peer review where required.
- Assist with Data Request tickets by gathering requirements, drafting queries, validating results with reviewers, and documenting outcomes.

