Data Engineer

About us:

We are champions of rail, inspired to build a greener, more sustainable future of travel. Trainline enables millions of travellers to find and book the best value tickets across carriers, fares, and journey options through our highly rated mobile app, website, and B2B partner channels.

Great journeys start with Trainline

Now Europe’s number 1 downloaded rail app, with over 125 million monthly visits and £5.3 billion in annual ticket sales, we collaborate with 270+ rail and coach companies in over 40 countries. We want to create a world where travel is as simple, seamless, and affordable as it should be.

Today, we’re a FTSE 250 company driven by our incredible team of over 1,000 Trainliners from 50+ nationalities, based across London, Paris, Barcelona, Milan, Edinburgh and Madrid. With our focus on growth in the UK and Europe, now is the perfect time to join us on this high-speed journey.

Position: Data Engineer

Location: London (Hybrid, 40% in office)

Salary: £60,000 – £70,000 + Benefits

Introducing Data Engineering at Trainline

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 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!

As a Data Engineer at Trainline, you will:

Be key to making our data lake more accessible and insightful by working on data marts and designing data models that even the most basic SQL users can use.

Your typical day will look like this:

• Connect with the team at standup to catch up 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.

We’d love to hear from you if you have:

• Proven experience as a Data Engineer 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.

More information:

Enjoy fantastic perks like private healthcare & dental insurance, a generous work from abroad policy, 2-for-1 share purchase plans, extra festive time off, and excellent family-friendly benefits.

We prioritise career growth with clear career paths, transparent pay bands, personal learning budgets, and regular learning days. Jump on board and supercharge your career from day one!

Our values:

• Think Big – We’re building the future of rail.
• Own It – We focus on every customer, partner, and journey.
• Travel Together – We’re one team.
• Do Good – We make a positive impact.

We know that having a diverse team makes us better and helps us succeed. And we mean all forms of diversity – gender, ethnicity, sexuality, disability, nationality, and diversity of thought. That’s why we’re committed to creating inclusive places to work, where everyone belongs and differences are valued and celebrated.

Interested in finding out more about what it’s like to work at Trainline? Why not check us out on LinkedIn , Instagram , and Glassdoor !

#J-18808-Ljbffr