Senior Data Engineer

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.