Engineer – Hertfordshire, HP2 4YL in Hemel Hempstead

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. But the best models don’t start in dbt – they start with a conversation. The part of this role that matters most is your ability to sit with the business, understand how guests, bookings, parks and revenue actually work, and translate that real-world process into a clear, domain-aligned dimensional model. It’s the rarest and most valuable skill in modelling, and it’s the one we care about most.

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

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

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

And whoever you are, we’d love you to bring:

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

You’ll be part of a forward‑thinking data community where craft matters, curiosity is celebrated, and the models you build will directly shape holidays enjoyed by millions of guests every year.

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.

What’s In It For You?

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

What’s it like to work with us?

Working with us is ultimately defined by our exceptional people and teams. At Haven, we take pride in our Breath of Fresh Air culture, which focuses on valuing and supporting every team member. We prioritise openness and transparency in our interactions, allowing our team members to be their authentic selves.

This is a remote‑first role. You’ll do your best modelling work wherever you focus best, coming together with the team on Park, at Head Office or at events when it adds the most value – typically a few times a month rather than every week.

What can you expect during the 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 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. If you require any assistance or reasonable adjustments while applying, please don’t hesitate to reach out to us at resourcing team@bourne-leisure.co.uk.