Data Engineer

Data Engineer

City of London Full-Time 36000 - 60000 £ / year (est.) No home office possible
R

At a Glance

  • Tasks: Join our tech team as a Data Engineer, building and enhancing our data analytics platform.
  • Company: Red Engine is a dynamic company disrupting the hospitality industry with innovative brands like Flight Club.
  • Benefits: Enjoy competitive pay, 33 days leave, staff discounts, and flexible working options.
  • Why this job: Be part of a creative team in a fun environment, contributing to exciting projects and social impact.
  • Qualifications: Experience with data pipelines, Azure, SQL, and a passion for data engineering is essential.
  • Other info: We celebrate diversity and welcome applicants from all backgrounds to join our inclusive culture.

The predicted salary is between 36000 - 60000 £ per year.

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 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.

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)
  • Strong 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 district 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 employer: Red Engine

    At Red Engine, we pride ourselves on being an exceptional employer, offering a vibrant work culture that fosters creativity and collaboration. As a Data Engineer, you'll enjoy competitive pay, generous annual leave, and the flexibility of fusion working, all while contributing to innovative projects within a supportive team. With ample opportunities for professional growth through regular learning sessions and team-building events, plus unique perks like staff discounts and private healthcare, Red Engine is dedicated to ensuring our employees thrive both personally and professionally.
    R

    Contact Detail:

    Red Engine Recruiting Team

    StudySmarter Expert Advice 🤫

    We think this is how you could land Data Engineer

    ✨Tip Number 1

    Familiarise yourself with the specific technologies mentioned in the job description, such as Azure Data Factory and Databricks. Having hands-on experience or projects showcasing these tools can set you apart from other candidates.

    ✨Tip Number 2

    Network with current employees or alumni who work at Red Engine. Engaging with them on platforms like LinkedIn can provide insights into the company culture and the team dynamics, which can be beneficial during interviews.

    ✨Tip Number 3

    Prepare to discuss your experience with data modelling and ELT/ETL processes in detail. Be ready to share specific examples of how you've implemented these in previous roles, as this will demonstrate your practical knowledge.

    ✨Tip Number 4

    Showcase your understanding of Agile methodologies and CI/CD frameworks. Being able to articulate how you've applied these practices in your past work will highlight your adaptability and readiness for the role.

    We think you need these skills to ace Data Engineer

    Data Pipeline Development
    ELT/ETL Processes
    T-SQL
    Python
    Azure Data Factory (ADF)
    Databricks
    Logic Apps
    Azure Functions
    ADLS
    SQL Server
    Unity Catalog
    Data Modelling (Inmon or Kimball)
    Agile Software Development
    Data Build Tool (DBT)
    Data Visualisation (PowerBi, Tableau)
    CI/CD Deployment Pipelines
    IaC Solutions (Terraform, Pulumi)
    Understanding of File Formats (Parquet, Delta, Iceberg, Hudi)

    Some tips for your application 🫡

    Tailor Your CV: Make sure your CV highlights relevant experience in data engineering, particularly with Azure and the technologies mentioned in the job description. Use specific examples of projects where you've developed ELT/ETL pipelines or worked with data visualisation tools.

    Craft a Compelling Cover Letter: In your cover letter, express your passion for the hospitality industry and how your skills align with Red Engine's mission. Mention your experience with data platforms and how you can contribute to their ambitious plans.

    Showcase Technical Skills: Clearly outline your technical skills related to T-SQL, Python, and Azure services. Provide examples of how you've used these skills in previous roles, especially in developing data solutions and maintaining CI/CD pipelines.

    Highlight Team Collaboration: Since the role involves working closely with Data Analysts and business stakeholders, emphasise your experience in collaborative environments. Share examples of how you've successfully gathered requirements and implemented data solutions in a team setting.

    How to prepare for a job interview at Red Engine

    ✨Showcase Your Technical Skills

    Be prepared to discuss your experience with T-SQL, Python, and Azure cloud services. Highlight specific projects where you've developed ELT/ETL pipelines or worked with data ingestion tools like Azure Data Factory.

    ✨Understand the Company Culture

    Research Red Engine's values and their approach to disrupting the hospitality industry. Be ready to explain how your personal values align with theirs and how you can contribute to their innovative environment.

    ✨Prepare for Scenario-Based Questions

    Expect questions that assess your problem-solving skills in real-world scenarios. Think of examples where you've successfully implemented data solutions or collaborated with stakeholders to meet business needs.

    ✨Demonstrate Your Agile Experience

    Since the role involves working within an Agile framework, be ready to discuss your previous experiences in Agile environments. Share how you've adapted to changes and contributed to team success in fast-paced settings.

    Data Engineer
    Red Engine
    R
    • Data Engineer

      City of London
      Full-Time
      36000 - 60000 £ / year (est.)

      Application deadline: 2027-04-10

    • R

      Red Engine

    Similar positions in other companies
    Europas größte Jobbörse für Gen-Z
    discover-jobs-cta
    Discover now
    >