Senior Data Engineer

Red Engine; Greater London; On-site; GBP 65,000 - 90,000; Full time

Benefits offered by this job

Annual bonus

33 days annual leave

Fusion working (office + home)

Job summary

Red Engine, a leading hospitality analytics team, is looking for a Data Engineer to build and maintain data pipelines and Azure-based ETL/ELT solutions. You will work with Data Analysts to model data in DBT and support reports and dashboards.

The role requires strong SQL Server, Databricks, and CI/CD experience, plus familiarity with modern data formats and IaC tools. Hybrid work and in-venue collaborations are available in our London-based offices.

Qualifications

• Extensive experience building ETL/ELT pipelines across structured and unstructured sources.
• Proficiency with Azure data services and Databricks for data engineering.
• Proven ability to model data in a warehouse using standard approaches (Inmon/Kimball).

Responsibilities

• Developing and maintaining data pipelines to ingest data from disparate sources into a centralized analytics platform.
• Designing and implementing data engineering solutions using T-SQL, Python, PySpark and DBT in Azure.
• Promoting business logic into DBT data models to support reports and dashboards.
• Maintaining CI/CD deployment pipelines and updating documentation in Azure DevOps.
• Documentation of technical work in accessible language for technical and non-technical audiences.

Skills

ETL/ELT pipelines

Azure Data Factory

Databricks

Logic Apps

Function App

ADLS

SQL Server

DBT

Parquet/Delta/Iceberg/Hudi

REST API data sources

CI/CD

Terraform/Pulumi

MS Fabric

Agile

Data warehousing (Inmon/Kimball)

Python

Tools

DBT

Job description

The Job

Hello, we are Red Engine, the team behind theaward-winning global brands Flight Club and Electric Shuffle. We're obsessedwith disrupting the hospitality industry by creating and delivering the bestpossible experience - across all venues, products and brands.

Our central team covers the full spectrum of skills needed to bring eachconcept to life – from design to marketing, sales to interior design, peopleand training, to finance, gaming and HR and everything in between. We’renot just a team of people, we are dreamers, artists, rocket scientists, contentcurators, forward thinkers and the industry’s finest. We love what we do andare proud to be included in the Sunday Times Best Places to Work 2025.

With a total of 19 incredible venues throughout theUK, and a further 16 around the globe, we have ambitious plans and arepassionate about developing new and exciting products, which means we’re alwaysgrowing and looking for passionate people to join the family.

Key responsibilities will include:

• Developing and maintaining data pipelines to orchestrate the ingestion of data from disparate source systems into a centralised data analytics platform.
• Designing and implementingdata engineering solutions using T-SQL, Python, PySpark and DBT in the Azurecloud environment.
• Working with Data Analystsin promoting business logic into DBT data models, to support business reportsand dashboards.
• Maintaining and leveragingCI/CD deployment pipelines to promote application code into higher tierenvironments.
• Maintaining and updatingthe technical documentation suite in Azure DevOps.

To be successful in this role, you’ll:

• D emonstrate solid experience developing of ETL/ELT ingestion pipelinesto handle data movement, transformation and visualisations from structured andunstructured sources.
• Have experiencewith the Azure Platform including:
• DataIngestion: Azure Data Factory (ADF), Databricks, Logic Apps and Function App
• DataStorage: ADLS, SQL Server and Unity Catalog (Medallion Architecture)
• Strongunderstanding of the Databricks Platform including managing, developing anddeploying workflows, jobs and notebooks.
• Provenexperience in modelling data in a Data warehouse using an Inmon or Kimballapproaches.
• Databasedevelopment experience in SQL Server including the creation of stored proceduresin T-SQL or a similar enterprise database toolset.
• Experienceworking in an Agile software development framework.
• Excellentworking knowledge of Data Build Tool (DBT) with a demonstrated ability indeveloping data models, contracts, tests, validation, and transformations
• Experienceworking with modern data distributed file formats (i.e., Parquet, Delta,Iceberg, Hudi)
• Demonstratedexperience with building data ingestion pipelines from REST API data sources.
• Strongability to produce technical documentation that can be understood by bothtechnical and non-technical audiences
• Strong working understanding in CloudAdministration and/or Database Administration.
• Experience with IaC solutions usingTerraform, Pulumi or similar tools.
• Experience with modern CI/CD DevOpsframeworks.
• Experience working with the MS Fabricplatform.

What you'll get:

• Competitive pay
• Annual bonus
• 33 days annual leave inclusive of BankHolidays
• Fusion working (our team are regularly in ourvenues, working collaboratively in our bright offices in Angel, or focusing onindividual projects with work from home Thursdays)
• Staff discount in all venues (50% off Sunday,Monday, 25% off Tuesday – Saturday, and free game hire)
• Regular team socialsand weekly lunch invenue
• Monthly learning and development classes, quarterlyteambuilding events
• Summer and Christmas socials
• Help @ hand 24/7 health support
• Free access to therapy, nutritionists, andphysiotherapists
• Weekly lunch in venue

Here at Red Engine, we believe our success beginsand ends with ourpeople. We are committed to a diverse culture where all ourteam feel respected and included. We acknowledge the power that a diverse set of beliefs and perspectives can bring, and that a variety of voicesstrengthens our team, enhances creativity, and drives innovation. We welcomeapplications from candidates of all identities, including individuals ofdifferent races, ethnicities, genders and sexual orientations. If you're passionateabout contributing to a culture of inclusion and collaboration.