Engineer

Leisure Employment Services; Hemel Hempstead; Teletrabalho; GBP 70 000 - 110 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Annual Bonus

25 Days Holiday + Bank Holidays + Buy‑

20% discount on Haven holidays

Wellbeing support

Corporate partner discounts

Career pathways & learning

Resumo da oferta

Haven is seeking a Senior Data Engineer (Data Modelling) for a remote-first UK role with occasional travel to head office and parks. You will design Kimball-style dimensional models, craft robust transformations in dbt, and drive the semantic layer that delivers trusted guest insights for dashboards and forecasts.

We value deep modelling expertise, strong SQL/dbt skills, and a collaborative, detail-oriented mindset.

Qualificações

• Deep dimensional modelling experience with Kimball in production warehouses.
• Ability to translate business processes into clean data models understood by stakeholders.
• Strong SQL and dbt skills for building transformations and semantic layers.
• Experience deriving conformed dimensions, slowly changing dimensions and grain declaration.

Responsabilidades

• Translate business processes into intuitive, domain-aligned dimensional models.
• Model with Kimball methodology and design scalable data models.
• Design, build and evolve dimensional data models with correct grain.
• Build the dbt layer and semantic layer turning raw data into trusted business truth.
• Champion data quality, testing and documentation as part of modelling craft.
• Share modelling patterns and techniques with engineers to raise standards.
• Shape trade-offs and communicate design decisions to technical and non-technical audiences.

Conhecimentos

Dimensional modelling

Business-to-model translation

SQL

dbt

Modelling patterns

Time management

Collaboration

Ferramentas

Snowflake

Airflow

Python

CI/CD

Descrição da oferta de emprego

Senior Data Engineer (Data Modelling)

UK Remote-First (occasional travel to parks, head office and team events). Permanent | Full Time. Competitive salary + bonus and benefits.

About the role

Do you think in facts and dimensions? Are you the kind of engineer who gets a genuine kick out of designing a clean, well-structured data model — one that turns messy source data into something the whole business can trust and use? If that sounds like you, we want to hear from you! At Haven, great holidays are powered by great data — and behind every dashboard, forecast and guest insight sits a data model that someone thought carefully about. That someone could be you. As a Senior Data Engineer (Data Modelling), you'll be a specialist at the heart of our data engineering community, focused squarely on the craft of dimensional modelling and the semantic layer that turns raw data into a source of truth our teams rely on every day. From there, you'll spend your time designing and evolving Kimball-style models, building elegant transformations in dbt, and shaping the way our business understands its guests and operations. Working within a supportive squad, you'll set the standard for modelling quality through your own work, share what you know with fellow engineers, and continue to grow your craft in a collaborative, remote-first environment where curiosity is celebrated.

Your Opportunity

• Translate business process into models. Sit with the business to understand how guests, bookings, revenue and operations really work — then translate that process into intuitive, domain-aligned dimensional models that stand the test of time.
• Model with Kimball methodology.
• Design, build and evolve dimensional data models, getting the grain right first and building for the way the business will grow.
• Build the dbt layer. Craft the transformation and semantic layer in dbt that turns raw source data into trusted, well-documented business truth.
• Champion quality. Make data quality, testing and documentation first-class parts of the modelling craft.
• Set the standard. Share your modelling patterns, techniques and thinking with fellow engineers, setting the standard through the quality of your own work.
• Shape the trade-offs. Bring a strong, well-reasoned point of view on modelling trade-offs into product and engineering conversations.
• Communicate clearly. Explain your design decisions to both technical and nontechnical audiences, so the whole business understands the model it relies on.

What we’d like you to bring

• Essential Deep dimensional modelling experience. Several years of hands‑on Kimball modelling on production warehouses that a business genuinely relies on — this is the heart of the role.
• Business‑to‑model translation. A real feel for turning business process into a data model: talking to stakeholders, uncovering the true grain, and shaping a domain that makes sense to the people who use it.
• Strong SQL and dbt. Deep, practical experience with dbt as your modelling toolkit.
• The instincts of an experienced modeller. You know when to reach for a conformed dimension, how to handle slowly‑changing dimensions and late‑arriving facts, why grain declaration comes first, and how a bus matrix keeps a warehouse coherent as it grows.
• A genuine passion for the craft. Clean design, sensible grain, thoughtful naming, and models that stand up to real‑world use.
• Excellent personal time management and self‑direction — essential for thriving in a remote‑first setup.
• A curious, collaborative, detail-oriented mindset with a strong desire to share and contribute across squads and cross‑functional teams.

Nice to have

• Working knowledge of Snowflake (our cloud data platform), and comfort with scheduling and orchestration tools such as Airflow.
• Familiarity with testing (TDD), DevOps and CI/CD as applied to analytics engineering workflows.
• Confident use of Python where it supports the modelling work, and comfort managing your own local development environment.
• An eye for using AI coding tools thoughtfully — to accelerate delivery without ever compromising quality.

Why Haven?

At Haven, we’re one great team, united by our passion for creating amazing experiences for our guests and our people. You'll have access to training, mentoring, and opportunities to grow your career in a supportive, forward-thinking environment.

Benefits

• 25 Days Holiday + Bank Holidays + Holiday Buy Scheme
• Annual bonus
• 20% discount on both Haven and Warner Hotels holidays for you, family and friends
• Comprehensive wellbeing support
• Exclusive discounts with corporate partners
• Exciting career pathways, including Learning and Development opportunities such as Apprenticeships and Degrees
• Enhanced family friendly policies and pay (eligibility criteria applied)

Who are we?

We’re part of an award-winning Bourne Leisure family, which includes Haven & Warner Hotels. We have 9,000 fantastic team members and 39 beautiful seaside locations, and our head office is based in Hemel Hempstead.

Recruitment Process

The interview process will be up to 3 stages and may contain a presentation or skills test, depending on the role. If you require any support or reasonable adjustments to help you perform at your best during this process, please let us know.

Diversity, equity and inclusion

Diversity, equity, and inclusion are at the heart of who we are and what we do. Our commitment to these values is unwavering and they are central to our mission. We encourage applications from all backgrounds, communities and industries and we are happy to discuss any reasonable adjustments or flexibility that you may require, including whether a role can be part‑time or a job‑share. We genuinely care about every candidate's experience during the recruitment process and are here to provide support where we can.