BI 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.9 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, eco friendly 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.

Purpose of the Role

We are recruiting an experienced BI Engineer as we continue to build a modern, scalable data ecosystem and empower the business to be truly data driven. This role sits within the Business Intelligence team, focusing on building high quality data models, trusted dashboards, and next generation self serve capabilities.

You'll work across the full BI stack, shaping data in dbt, building clear and actionable Tableau dashboards, and contributing to our emerging use of AI in data (e.g natural language querying, predictive features).

This is a great role for someone who is strong in SQL/Tableau and wants to grow deeper into data modelling, semantic layers, and applied AI use cases.

Key Responsibilities Data Modelling & Engineering

• Build, maintain and enhance data models in dbt, contributing to our semantic / metrics layers.
• Ensure data definitions are consistent, documented and trusted across business domains.
• Partner with Data Engineering to ensure data pipelines are reliable, scalable and observable.

Dashboarding & Self Serve Enablement

• Design clear, intuitive Tableau dashboards that drive decisions, not just charts.
• Coach analysts and business users on how to self serve responsibly and interpret metrics correctly.
• Contribute to the organisation and governance of certified dashboards in Tableau Cloud.

Insight Delivery & Stakeholder Engagement

• Work with product, marketing, commercial and operational teams to understand analytical needs and translate them into data and dashboard solutions.
• Help ensure insights lead to tangible actions by providing clarity, interpretation, and follow through.
• Support data literacy and a strong data culture across the organisation.

Knowledge & Experience Required

• Strong SQL skills and experience working with relational data.
• Hands on experience with Tableau (effective dashboard layout, storytelling, parameters, LODs).
• Exposure to or desire to deepen skills in dbt (even if not advanced yet).
• Ability to translate business questions into analytical approaches and explain insights simply.

Nice to Have

• Experience with data warehouse technologies (e.g., AWS Athena, Starburst Galaxy).
• Interest in or early experimentation with AI tools (e.g., Python, feature engineering, BI assistants).
• Familiarity with Git based workflow and version controlled analytics.
• Tableau certifications or portfolio work (Tableau Public, GitHub dbt examples).

Behaviour & Skills

• Curious problem solver who enjoys learning new tools and growing craft skills.
• Comfortable working in cross functional teams and adapting to changing priorities.
• Passionate about empowering others to self serve and use data responsibly.Sees BI as a product, not a service, focused on repeatability and sustainable impact.

More information

Enjoy fantastic perks like private healthcare & dental insurance, a generous work from abroad policy, 2 for 1 share purchase plans, an EV Scheme to further reduce carbon emissions, 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!

We're operate a hybrid model to work and ask that Trainliners work from the office a minimum of 40% of their time over a 12 week period. We also have a 28 day Work from Abroad policy.

Our values

Our values represent the things that matter most to us and what we live and breathe everyday, in everything we do:

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