Job Description

:
Role Overview
Are you a seasoned Data Modeler with a passion for clean, scalable architecture? Join a leading financial services client as the go-to expert designing the analytical backbone of a cloud-native enterprise data warehouse built on Amazon Redshift.Join a leading financial services team as the go-to expert designing the analytical backbone of a cloud-native enterprise data warehouse built on Amazon Redshift.
In this high-impact role, you will lead the design and evolution of dimensional data models that power cross-business analytics and decision-making at scale.
Your expertise in Kimball modelling, advanced SQL, and performance tuning will be key in building robust, trusted data structures. You'll engage directly with analysts, data professionals, and business leaders to shape models that are not just performant but fit for real-world decisions.
Requirements
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

Skills Required