Job Title - Senior Data Modelling – Enterprise Data Warehouse

Experience - 8+ Years

Role Purpose

We are seeking a Senior Data Modelling Specialist to lead the design and evolution of dimensional data models for a large‑scale enterprise data warehouse built primarily on Amazon Redshift. This role shapes the analytical layer of the enterprise platform, ensuring data is trusted, well‑structured, and fit for decision‑making.

Key Responsibilities

Senior Data Modelling & Design

• Lead design and maintenance of enterprise‑grade dimensional models using Kimball standards .
• Design fact tables, dimensions, conformed dimensions, and surrogate key strategies.
• Optimize models for Redshift performance (distribution styles, sort keys, query patterns).
• Review/refactor existing models for usability, scalability, and performance.

Hands‑on SQL & Redshift Expertise

<...