Data Engineer, Trainline
£60-70k
40% in office
2+ days a week in office
Train ticketing platform
Be an early applicant
Train ticketing platform
1001+ employees
Be an early applicant
£60-70k
40% in office
2+ days a week in office
1001+ employees
Company mission
We're building the world's no.1 rail platform while empowering greener travel choices, connecting people and places.
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. Their app is intuitive and well designed. and they're even pioneering paperless travel, allowing you to store your tickets in the app.
They're hyper focused on customer experience and have a product culture of fast iteration to deliver great outcomes for customers.
Their customers make 170,000 journeys a day and they sell 200 tickets a minute.
They're continuing to innovate to stay ahead. They're using machine learning to predict price movements and are 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
- Gym memberships
- Private Health and dental Insurance
- 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
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, not founder)Previously Non-exec Director of Moonpig and Photobox Group.
Milena Nikolic
(Chief Technology Officer, not founder)Previously Engineering Director at Google.
Lisa Hillier
(Chief People Officer, not founder)Previously Chief People Officer at Gousto , The Restaurant Group and Just Eat.
Mike Hyde
(Chief Data Officer, not founder)Previously at Meta.
Dave Price
(Chief Product Officer, not founder)Previously at Spotify and GoEuro.
People progressing
Joined as a Product Manager. Promoted to Product Manager after 1 year. Then promoted again to Principal Product Manager after 7 months and is currently Product Director.
Joined as Business Performance Analyst. Promoted to Senior Analyst after 1.5 years. Then promoted again to Commercial Manager after 7 months.
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 💜 Artemis (gender equality) 🏳️🌈 Rainbow Train (LGBTQIA+) 🌻 Sunflower (accessibility) 🌍 Ethnic Diversity Network 🐣 Parent & Carers
Share this job
View 16 more jobs at Trainline