Senior Data Modeller

We are seeking an experiencedData Modellerwith a strong background inKimball dimensional modeling methodologyto support the design and development of scalable, analytics-ready data architectures.The ideal candidate will have a solid understanding ofstar schema and snowflake schemadesign principles, fact and dimension table modeling, slowly changing dimensions (SCDs), and best practices for building data warehouses optimized for reporting and analytics.This role requiresadvanced SQL proficiency,including the ability to write and optimizecomplex queries, perform data profiling, and troubleshoot data quality issues across large datasets.Candidates should be comfortable collaborating with data engineers, BI teams, and business stakeholders to translate business requirements into well-structured logical and physical data models.Astrong background in healthcare data is required, with specific hands-on experience working with Encounters data (e.g., medical claims, member encounters, provider interactions, or related healthcare transactional data). Familiarity with healthcare data standards, claims processing workflows, and payer/provider data structures is highly valued.Key Responsibilities:Design and maintain dimensional data models using Kimball methodology (star schema, snowflake schema)Develop and optimize complex SQL queries for data extraction, transformation, and validationModel healthcare Encounters data, ensuring accuracy and alignment with business and regulatory requirementsCollaborate with data engineering teams to implement data models within the data warehouse/lakehouse environmentPerform data quality checks, gap analysis, and troubleshooting across source and target systemsDocument data models, data dictionaries, and mapping specificationsPartner with BI and analytics teams to ensure models support downstream reporting needsRequired Qualifications:Strong hands-on experience with Kimball dimensional modeling techniquesAdvanced SQL skills (query writing, performance tuning, debugging)Healthcare industry experience, with specific knowledge of Encounters dataExperience working with claims, member, or provider data in a healthcare payer or provider settingStrong analytical and problem-solving skills with high attention to detailAbility to collaborate effectively with cross-functional technical and business teamsCavendish (Recruitment) Professionals Ltdare proud to be an equal opportunity employer and we believe that inclusivity begins with the candidate experience. All qualified applicants will receive consideration for employment regardless of gender, race, age, sexual orientation, religion, or belief.#J-*****-Ljbffr

Kimball dimensional modeling methodology to support the design and development of scalable, analytics-ready data architectures. The ideal candidate will have a solid understanding of star schema and snowflake schema design principles, fact and dimension table modeling, slowly changing dimensions (SCDs), and best practices for building data warehouses optimized for reporting and analytics. This role requires advanced SQL proficiency, including the ability to write and optimize complex queries, perform data profiling, and troubleshoot data quality issues across large datasets. Candidates should be comfortable collaborating with data engineers, BI teams, and business stakeholders to translate business requirements into well-structured logical and physical data models. A strong background in healthcare data is required , with specific hands-on experience working with Encounters data (e.g., medical claims, member encounters, provider interactions, or related healthcare transactional data). Familiarity with healthcare data standards, claims processing workflows, and payer/provider data structures is highly valued., Strong hands-on experience with Kimball dimensional modeling techniques Advanced SQL skills (query writing, performance tuning, debugging) Healthcare industry experience, with specific knowledge of Encounters data Experience working with claims, member, or provider data in a healthcare payer or provider setting Strong analytical and problem-solving skills with high attention to detail Ability to collaborate effectively with cross-functional technical and business teams