Senior Data Modeler (Data Warehouse)

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