Role Overview

We are seeking a Senior Data Modeller to lead the design and evolution of dimensional data

models for a large-scale enterprise data warehouse built primarily on Amazon Redshift.

This role requires deep expertise in Kimball dimensional modelling, strong hands-on SQL

querying skills, and the ability to confidently engage business stakeholders and data

knowledge workers to translate analytical needs into robust, performant data models.

You will play a key role in shaping the analytical layer of the enterprise platform and ensuring

that data is trusted, well-structured, and fit for decision-making.

Key Responsibilities

Senior Data Modelling & Design

Lead the design and maintenance of enterprise-grade dimensional models using Kimball

standards

Design fact tables, dimensions, conformed dimensions, and surrogate key strategies

Ensure models are optimised for Redshift performance (distribution styles, sort keys, query

patterns)

Review and refactor existing models to improve usability, performance, and scalability

Hands-on SQL & Redshift Expertise

Write and optimise complex SQL queries on Amazon Redshift for analysis, validation, and

performance tuning

Profile source data to validate assumptions and inform modelling decisions

Support downstream analytics and BI teams with query optimisation and model usage

guidance

Partner with data engineers and analysts to align modelling decisions with ELT

implementation

Stakeholder Engagement & Workshops

Facilitate requirements and modelling workshops with business stakeholders and data

knowledge workers

Translate business concepts, KPIs, and metrics into well-defined dimensional structures

Act as a trusted advisor to business and analytics teams on data interpretation and usage

Communicate complex data concepts clearly to non-technical audiences

Data Quality, Governance & Standards

Define and enforce modelling standards, naming conventions, and design patterns

Document data definitions, business rules, and assumptions

Support data lineage, impact analysis, and enterprise data consistency

Contribute to data governance and best-practice frameworks

Leadership & Mentorship

Provide guidance and mentoring to junior modellers and analysts

Review data models and SQL developed by others

Influence architectural and design decisions across the data platform

Required Skills & Experience

Core Expertise

Extensive experience in enterprise data warehousing

Advanced expertise in Kimball dimensional modelling

Proven experience designing models used at scale across multiple business domains

Strong understanding of analytical and reporting use cases

Technical & Querying Skills

Advanced SQL skills, with a strong focus on Amazon Redshift and other data/analytic

platforms

Experience optimising queries for performance in columnar data warehouses

Strong data profiling and validation skills

Solid understanding of ELT/ETL processes and data pipelines

Stakeholder & Communication Skills

Proven ability to run effective modelling and requirements workshops

Experience working closely with data knowledge workers, analysts, and decision-makers

Ability to challenge requirements constructively and propose better modelling approaches

Desirable