Senior Data Engineer - Dimensional Modelling (Remote-First)

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

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.