Engineer

Haven; Hemel Hempstead; Hybrid; GBP 80,000 - 110,000; Full time

Benefits offered by this job

Annual bonus

Holiday allowance

20% discount on Haven and WarnerHotels

Wellbeing support

Learning and Development opportunities

Job summary

Haven, remote-first with occasional visits to our head office, is seeking a Senior Data Engineer focused on data modelling. You will translate guest, bookings, and revenue processes into clear, domain-aligned dimensional models and build the dbt layer to deliver trusted business truths.

You will design robust data models using Kimball methodology, ensure data quality and documentation, and collaborate across squads to raise modelling standards in a hands-on role.

Qualifications

• Deep dimensional modelling experience with Kimball techniques.
• A real feel for translating business processes into data models.
• Strong SQL and dbt skills for modelling and transformations.
• Experience with conformed dimensions, slowly-changing dimensions and grain.
• Passion for clean design, well-named models and practical reuse.

Responsibilities

• Translate business processes into domain-aligned dimensional models.
• Design, build and evolve Kimball data models for scalable warehouses.
• Develop the dbt layer to transform raw data into trusted business truths.
• Champion data quality, tests and documentation.
• Share modelling patterns with engineers and set quality standards.
• Contribute to product discussions with data modelling perspectives.

Skills

Dimensional modelling

Kimball modelling

SQL

dbt

Data warehouse

Tools

Snowflake

Airflow

Python

CI/CD

Job description

**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.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.This is a hands-on, deeply technical role for a data modeller who cares about data quality, clarity and craft - and who wants their work to make a tangible difference to millions of guest experiences every year.**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.# # 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.# # 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 DegreesEnhanced **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 **resourcin****[e-mail]**.**What We Offer**- Holiday allowance that rises with service, plus a ‘Holiday Buy Scheme’- Annual bonus- 20% discount on both Haven and Warner Hotels holiday for you, family and friends- Comprehensive wellbeing support- Access to the Bourne Leisure corporate box at the O2 Arena ,London- 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)**How to Apply** We’re committed to fostering a diverse, equitable, and inclusive workplace, and we encourage applicants of all backgrounds to apply. To get started, click apply now and answer a few quick questions, which should take 5 minutes. Once submitted, a member of our team will be in touch.