Data Engineer at Trainline

About us We are champions of rail, inspired to build a greener, more sustainable [Upgrade to PRO to see link] 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.  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 analytics, 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 BI Developers and Data Scientists in cross-functional teams with key impacts and visions. 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! As a Data Engineer at Trainline, you will... 🚄    - Be key to making our data lake more accessible and insightful breaking down the barriers to access by working on new data marts and designing data models that even the most basic SQL users can use - Build data pipelines with Spark or DBT - Use SQL to transform data into meaningful insights - Build and deploy infrastructure with Terraform - Implement DDL, DML with Iceberg - Do code reviews 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 Engineering using SQL and Python - Previous experience with data lakes in AWS, Glue Catalog and Athena (or equivalent) - Good experience with DBT - 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, 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 60% of their time over a 12-week period. We also have a 28-day Work from Abroad policy. 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 [Upgrade to PRO to see link] Instagram [Upgrade to PRO to see link] and Glassdoor [Upgrade to PRO to see link]