Data Engineer, Trainline
£60-70k
40% in office
2+ days a week in office
Europe's leading rail ticketing platform
Open for applications
Europe's leading rail ticketing platform
1001+ employees
Open for applications
£60-70k
40% in office
2+ days a week in office
1001+ employees
Company mission
Trainline is proud to be Europe's leading rail and coach platform - a tech company with a mission to make train travel as smooth as possible to allow travellers to make greener travel choices.
Role
Who you are
- Proven experience as a Data Engineering using SQL and Python
- Previous experience with data lakes in AWS, Glue Catalog and Athena (or equivalent)
- Good understanding of Spark, optimisation and performance tuning
- Capable of using popular data modelling tools to create a diagram of proposed tables to enable discussion
- Good communicator and comfortable with presenting ideas and outputs to technical and non-technical users
- Worked on Apache Airflow before to create DAGS
- Ability to work within Agile, considering minimum viable products, story pointing and sprints
What the job involves
- At the heart of our Data Team, Data Engineers play a pivotal role by creating pipelines and tables that power impactful dashboards, enable self-service via SQL, and support innovative machine learning models and real-time data products
- As a Data Engineer, you will be involved in engineering pipelines that will drive key decisions and give data science powerful datasets to enable and drive new business insights
- Data Engineers work alongside Machine learning engineers, BI Developers and Data Scientists in cross-functional teams with key impacts and visions
- Using your skills with SQL, data modelling and Spark to ingest and transform high volume complex raw event data into user-friendly high impact tables
- As a department we strive to give our Data Engineers have high levels of autonomy and freedom to innovate and continually refine their technical and soft skills with clear progression plans and training opportunities with Data Camp!
- Be key to making our data lake more accessible and insightful breaking down the barriers to access by working on data marts and designing data models that even the most basic SQL users can use
- Connect with team at standup to catchup on the latest
- Build data pipelines with Spark or DBT on Starburst
- Use SQL to transform data into meaningful insights
- Build and deploy infrastructure with Terraform
- Implement DDL, DML with Iceberg
- Do a code review for your peers
- Orchestrate your pipelines with DAGs on Airflow
- Participate in SCRUM ceremonies (standups, backlogs, demos, retros, planning)
- Secure data with IAM and AWS Lake formation
- Deploy your changes with Jenkins and GitHub actions
Salary benchmarks
Our take
Trainline make it super easy to book transport tickets. Its app is intuitive and well designed and its even pioneering paperless travel, allowing users to store their tickets in the app.
Its hyper focused on customer experience and has a product culture of fast iteration to deliver great outcomes for customers.
Its customers make 170,000 journeys a day and it sell 200 tickets a minute.
Its continuing to innovate to stay ahead, using machine learning to predict price movements and integrating with Siri and Google Assistant so people can buy tickets just by speaking to their phone.
Steph
Company Specialist at Welcome to the Jungle
Insights
Company
Employee endorsements
Challenging work
"The complex nature of the market as we work with different suppliers is an amazing opportunity to create fluid solutions. A very well segmented..."
Company benefits
- Flexible working (40% min office attendance)
- Cycle to work scheme
- Discounted gym memberships through Wellhub
- Private Health and Dental Insurance
- Enhanced Pension (matched contributions)
- Income Protection
- Share Incentive Plan (buy one get one free)
- Learning budget
- Primary & Secondary Caregiver Leave
- Shared Parental Leave
- Enhanced sick pay
- Free Perkbox subscription
- Electric Vehicle Salary Sacrifice Scheme
- YellowNest - Subsidised Childcare Fees
- Work from Abroad
Company values
- Own It - We care about every customer, partner and journey
- Do Good - We make a positive impact
- Travel Together - We're one team
- Think Big - We are building the future of rail
Company HQ
Farringdon, London, UK
Articles
Leadership
Jody Ford
(CEO)Joined Trainline in 2020 as COO before becoming the CEO in 2021. Previously the Group CEO at Moonpig and Photobox and also spent over 10 years at eBay in various VP roles.
Lisa Hillier
(CPO)Previously the CPO at Gousto, The Restaurant Group, and Just Eat. They also spent over 6 years at Betfair as the Head of HR and Chief Human Resource Officer.
Mike Hyde
(Chief Data Officer)Previously a Director of Data Science at Facebook and as a Director of Business Insights at Skype and Microsoft.
Sakshi Anand
(CGO)Joined Trainline in 2023 as the VP of Growth and President of UK before becoming the CGO in 2025. They are also the Founder of NeuStar Consulting.
People progressing
Gary joined in 2022 from Comparethemarket as Director of Engineering and was recently promoted to VP Engineering, reporting directly to CTO.
Joe joined in 2022 from Meta as Director of Data Science and was recently promoted to VP Data, reporting directly to CTO.
Ali joined in 2023 from Meta and was recently promoted to VP Product, reporting directly to CPO.
Diversity, Equity & Inclusion at Trainline
- 💚 Diversity drives us forward We know that having a diverse team is crucial to Trainline’s ongoing success. A team that is diverse in all forms – gender, ethnicity, sexuality, disability, nationality and diversity of thought are key to Trainline being an inclusive environment where every Trainliner can be their true self. We're committed to creating workplaces where everyone belongs, is celebrated and their differences are valued, creating an awesome employee and customer experience. 💚 Meet our Networks Our diversity networks are inclusive communities developed and led by Trainliners, with sponsorship and support from senior leaders. They're all about empowering and supporting underrepresented groups, by providing a safe space to talk, a place to come up with new ideas and a channel for voices to be heard. 🚀 Women in Leadership 💜 Gender Equality Network 🏳️🌈 Rainbow Train (LGBTQIA+) 🌻 Sunflower (accessibility) 🌍 Ethnic Diversity Network 🐣 Parent & Carers
Share this job
View 11 more jobs at Trainline