Share with friends
Accessibility
Data Engineer
Red Engine
Data Engineer
Red Engine
Full Time
3
Years
Experience
£50000 - £55000 / Year
Data Engineer
Red Engine
Full Time
3
Years
Experience
£50000 - £55000 / Year
Skills
ELT/ETL
Delta
Unity
Databricks
Azure Cloud
Parquet
+4
Description
About Us
Hello, we are Red Engine, the team behind the
award-winning global brands Flight Club and Electric Shuffle. We're obsessed
with disrupting the hospitality industry by creating and delivering the best
possible experience - across all venues, products and brands.
Our central team covers the full spectrum of skills needed to bring each
concept to life – from design to marketing, sales to interior design, people
and training, to finance, gaming and HR and everything in between. We’re
not just a team of people, we are dreamers, artists, rocket scientists, content
curators, forward thinkers and the industry’s finest. We love what we do and
are proud to be included in the Sunday Times Best Places to Work 2024
With a total of 18 incredible venues throughout the UK, and a further 13 around the globe, we have ambitious plans and are passionate about developing new and exciting products, which means we’re always growing and looking for passionate people to join the family.
The Job
As a Data Engineer, you will be working in the Red Engine technology team, helping to build out the existing data and analytics platform. This role is placed within a small team, allowing the successful candidate design freedom in implementing bespoke features and enhancements to our data platform using the latest technology. In this role you will assist the senior engineers in meeting with key business stakeholders to gather technical requirements to drive the design and implementation of data solutions within the Data & Analytics platform.
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 implementing data engineering solutions using T-SQL and Python in the Azure cloud environment
Working with Data Analysts in promoting business logic into the analytics platform, to support business reports and dashboards
Maintaining and leveraging CI/CD deployment pipelines to promote application code into higher tier environments
To be successful in this role, you’ll have:
- Demonstrated experience developing ELT/ETL ingestion pipelines to handle data movement and transformation from structured and unstructured data sources.
- Experience with the Azure cloud platform including:
- Data Ingestion: Azure Data Factory (ADF), Databricks, Logic Apps, Azure Functions
- Data storage: ADLS, SQL Server and Unity Catalog (Medallion Architecture)
- Data Analysis: Databricks notebooks, SQL queries, data visualisations (PowerBi or adjacent tools)
Stong understanding of the Databricks platform including managing, developing, and deploying workflows, jobs, and notebooks
Proven experience in modelling data in a data warehouse using Inmon or Kimball approaches
Experience in database development in SQL Server including developing stored procedures, functions, and views
Experience working in an Agile software development framework
Experience with Data Build Tool (DBT) including building data models, tests, validation, and transformations
Thorough understanding of districted file and table format (i.e., Parquet, Delta, Iceberg, Hudi)
Experience as a Data Engineer in your previous role
Preferred:
- Experience with IaC solutions using Terraform, Pulumi or similar tools
- Experience working with modern CI/CD DevOps frameworks
Experience in developing data visualisations using PowerBi, Tableau or similar tools
What you'll get
- Competitive pay
- Annual bonus
- 33 days annual leave inclusive of Bank Holidays
- Fusion working (our team are regularly in our venues, working collaboratively in our bright offices in Angel, or focusing on individual projects with work from home Thursdays)
- Staff discount in all venues (50% off Sunday, Monday, 25% off Tuesday – Saturday, and free game hire)
- Private healthcare
- Regular team socials and weekly lunch in venue
- Monthly learning and development classes, quarterly teambuilding events
- Summer and Christmas socials
- Help @ hand 24/7 health support
- Free access to therapy, nutritionists, and physiotherapists
- Weekly lunch in venue
Here at Red Engine, we believe our success begins and ends with our people. We are committed to a diverse culture where all our team feel respected and included. We acknowledge the power that a diverse set of beliefs and perspectives can bring, and that a variety of voices strengthens our team, enhances creativity, and drives innovation. We welcome applications from candidates of all identities, including individuals of different races, ethnicities, genders and sexual orientations. If you're passionate about contributing to a culture of inclusion and collaboration, please apply.
About Us
Hello, we are Red Engine, the team behind the
award-winning global brands Flight Club and Electric Shuffle. We're obsessed
with disrupting the hospitality industry by creating and delivering the best
possible experience - across all venues, products and brands.
Our central team covers the full spectrum of skills needed to bring each
concept to life – from design to marketing, sales to interior design, people
and training, to finance, gaming and HR and everything in between. We’re
not just a team of people, we are dreamers, artists, rocket scientists, content
curators, forward thinkers and the industry’s finest. We love what we do and
are proud to be included in the Sunday Times Best Places to Work 2024
With a total of 18 incredible venues throughout the UK, and a further 13 around the globe, we have ambitious plans and are passionate about developing new and exciting products, which means we’re always growing and looking for passionate people to join the family.
The Job
As a Data Engineer, you will be working in the Red Engine technology team, helping to build out the existing data and analytics platform. This role is placed within a small team, allowing the successful candidate design freedom in implementing bespoke features and enhancements to our data platform using the latest technology. In this role you will assist the senior engineers in meeting with key business stakeholders to gather technical requirements to drive the design and implementation of data solutions within the Data & Analytics platform.
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 implementing data engineering solutions using T-SQL and Python in the Azure cloud environment
Working with Data Analysts in promoting business logic into the analytics platform, to support business reports and dashboards
Maintaining and leveraging CI/CD deployment pipelines to promote application code into higher tier environments
To be successful in this role, you’ll have:
- Demonstrated experience developing ELT/ETL ingestion pipelines to handle data movement and transformation from structured and unstructured data sources.
- Experience with the Azure cloud platform including:
- Data Ingestion: Azure Data Factory (ADF), Databricks, Logic Apps, Azure Functions
- Data storage: ADLS, SQL Server and Unity Catalog (Medallion Architecture)
- Data Analysis: Databricks notebooks, SQL queries, data visualisations (PowerBi or adjacent tools)
Stong understanding of the Databricks platform including managing, developing, and deploying workflows, jobs, and notebooks
Proven experience in modelling data in a data warehouse using Inmon or Kimball approaches
Experience in database development in SQL Server including developing stored procedures, functions, and views
Experience working in an Agile software development framework
Experience with Data Build Tool (DBT) including building data models, tests, validation, and transformations
Thorough understanding of districted file and table format (i.e., Parquet, Delta, Iceberg, Hudi)
Experience as a Data Engineer in your previous role
Preferred:
- Experience with IaC solutions using Terraform, Pulumi or similar tools
- Experience working with modern CI/CD DevOps frameworks
Experience in developing data visualisations using PowerBi, Tableau or similar tools
What you'll get
- Competitive pay
- Annual bonus
- 33 days annual leave inclusive of Bank Holidays
- Fusion working (our team are regularly in our venues, working collaboratively in our bright offices in Angel, or focusing on individual projects with work from home Thursdays)
- Staff discount in all venues (50% off Sunday, Monday, 25% off Tuesday – Saturday, and free game hire)
- Private healthcare
- Regular team socials and weekly lunch in venue
- Monthly learning and development classes, quarterly teambuilding events
- Summer and Christmas socials
- Help @ hand 24/7 health support
- Free access to therapy, nutritionists, and physiotherapists
- Weekly lunch in venue
Here at Red Engine, we believe our success begins and ends with our people. We are committed to a diverse culture where all our team feel respected and included. We acknowledge the power that a diverse set of beliefs and perspectives can bring, and that a variety of voices strengthens our team, enhances creativity, and drives innovation. We welcome applications from candidates of all identities, including individuals of different races, ethnicities, genders and sexual orientations. If you're passionate about contributing to a culture of inclusion and collaboration, please apply.
Data Engineer
Full Time
3
Years
Experience
£50000 - £55000 / Year
Skills
ELT/ETL
Delta
Unity
Databricks
Azure Cloud
Parquet
+{{skillsLength}}
338-346 Goswell Rd, The Angel, London EC1V 7LQ, UK