Senior Data Modeler

Introduction

Our client is looking for a Senior Data Modelling Specialist for a 6-month remote contract to lead the design and evolution of dimensional data models for a large-scale enterprise data warehouse built primarily on Amazon Redshift.

You will play a critical role in shaping the analytical layer of the enterprise data platform, ensuring data is trusted, well-structured, performant, and fit for strategic decision-making across the business.

Duties & Responsibilities

• Lead the design and maintenance of enterprise-grade dimensional data models using Kimball methodologies
• Design and manage fact tables, dimensions, conformed dimensions, and surrogate key strategies
• Optimise data models and queries for Amazon Redshift performance (distribution styles, sort keys, query patterns)
• Review and refactor existing models to improve usability, performance, and scalability
• Write and optimise complex SQL for data...