At a Glance
- Tasks: Support and improve our Data Platform while learning core data engineering skills.
- Company: Join interactive investor, the UK's top flat-fee investment platform with a vibrant culture.
- Benefits: Enjoy a competitive salary, pension plan, private medical insurance, and staff discounts.
- Other info: Complete a Level 5 Data Engineer Apprenticeship in 18-20 months with excellent growth opportunities.
- Why this job: Kick-start your career in data engineering with hands-on experience and a recognised qualification.
- Qualifications: Must be 18+, have a level 3 qualification, and some knowledge of SQL and Python.
The predicted salary is between 28300 - 28300 £ per year.
Salary: £28,300
Assessment centre dates: June
Start date: Monday 7th September 2026
Who we are: interactive investor is an award‑winning investment platform that puts its customers in control of their financial future. We’ve been helping investors for nearly 30 years. We’re now the UK’s number one flat‑fee investment platform, with assets under administration approaching £75 billion and over 500,000 customers.
Purpose of the role: As a Trainee Data Engineer, you will support ii to operate, maintain, and continually improve the firm’s Data Platform. Working alongside experienced Data Engineers, you will help ingest, transform, and model datasets such as customer, transaction, marketing, web analytics, and market data into a trusted source for analytics and Data Science/ML/AI.
Key responsibilities/what you’ll do:
- Support the daily Data Platform run under guidance, including checking scheduled jobs, investigating first‑line failures using runbooks, and escalating issues appropriately.
- Contribute to developing and maintaining ELT/ETL pipelines using Dagster, following established patterns for dependency management, retries, and alerting.
- Support the build and maintenance of warehouse structures under guidance.
- Draft, test, and document reusable SQL queries and data extracts for Data Analysts and business users.
- Support triage and delivery of Data Request tickets for ad‑hoc data needs.
- Help maintain data documentation, keeping definitions clear, consistent, and up‑to‑date.
- Support integrations for data pipelines with business systems and APIs.
- Run and extend data quality checks and basic observability.
- Learn performance and cost best practices in Snowflake.
- Work to strong DataOps practices: Git‑based version control, pull requests, code reviews, CI/CD, and environment promotion.
- Follow privacy, security, and governance requirements.
- As required, support simple operational MI or ad‑hoc outputs via Streamlit and, occasionally, Power BI.
- Complete agreed training and/or required learning modules as part of the programme.
About the apprenticeship: As a Trainee Data Engineer, you’ll develop the technical knowledge plus the professional skills and behaviours to work within our exciting and fast‑paced Data and Innovation team, gaining valuable work experience plus achieving a qualification through a structured apprenticeship programme to kick‑start your career.
To apply for this role, you will need:
- To be at least 18 years old as of 1st September 2026.
- Be a UK/EEA citizen or have lived in the UK/EEA continuously for the last 3 years.
- To be eligible to work in the UK and not in full‑time education.
- To have achieved, or predicted to achieve in 2026, a level 3 qualification, such as A‑levels or equivalent.
- Maths and English GCSE (or equivalent) grades A* to C (new grades 9 to 4).
- An understanding of SQL, Python, core database concepts, and data modelling is desirable.
- A level 4 qualification in Data or Computer Science is desirable.
Benefits: Group Personal Pension Plan, Life Assurance and Group Income Protection, Private Medical Insurance – provided by Bupa, Staff discounts on our investment products.
Trainee Data Engineer Apprenticeship employer: Interactive Investor
Contact Detail:
Interactive Investor Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Trainee Data Engineer Apprenticeship
✨Tip Number 1
Network like a pro! Reach out to current employees at interactive investor on LinkedIn. Ask them about their experiences and any tips they might have for the assessment centre. A friendly chat can give you insider info that could set you apart!
✨Tip Number 2
Practice makes perfect! Get familiar with common data engineering tasks, especially in Python and SQL. Try building your own mini-projects or contribute to open-source projects. This hands-on experience will not only boost your skills but also give you great talking points during interviews.
✨Tip Number 3
Show your passion for data! During interviews, share your enthusiasm for data engineering and how it impacts decision-making. Discuss any relevant projects or coursework that sparked your interest. Let them see that you're not just looking for a job, but a chance to grow in a field you love.
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets noticed. Plus, you’ll find all the details you need about the role and the company. Don’t miss out on this opportunity – hit that apply button and let’s get you started on your journey!
We think you need these skills to ace Trainee Data Engineer Apprenticeship
Some tips for your application 🫡
Tailor Your Application: Make sure to customise your CV and cover letter for the Trainee Data Engineer role. Highlight your relevant skills in SQL, Python, and any data engineering concepts you've learned. We want to see how you fit into our team!
Show Your Passion for Data: In your application, let us know why you're excited about data engineering and how it aligns with your career goals. Share any projects or experiences that showcase your enthusiasm for working with data – we love seeing that spark!
Be Clear and Concise: When writing your application, keep it straightforward and to the point. Use clear language and avoid jargon unless it's relevant. We appreciate a well-structured application that’s easy to read and understand.
Apply Through Our Website: Don’t forget to submit your application through our website! It’s the best way to ensure it gets to the right people. Plus, you’ll find all the details you need about the role and our company there.
How to prepare for a job interview at Interactive Investor
✨Know Your Data Engineering Basics
Before the interview, brush up on your understanding of SQL, Python, and core database concepts. Be ready to discuss how you would approach building data pipelines or handling data quality checks, as these are key aspects of the role.
✨Familiarise Yourself with the Company
Research interactive investor thoroughly. Understand their services, values, and recent developments in the investment platform space. This will help you tailor your answers and show genuine interest in the company during the interview.
✨Prepare for Technical Questions
Expect technical questions related to data engineering practices, such as ELT/ETL processes and data modelling. Practise explaining your thought process clearly and concisely, as this will demonstrate your problem-solving skills and technical knowledge.
✨Show Enthusiasm for Learning
As a trainee, your eagerness to learn is crucial. Be prepared to discuss how you plan to develop your skills throughout the apprenticeship. Highlight any relevant projects or experiences that showcase your passion for data engineering and continuous improvement.