Senior Data Modeller - Kimball Dimensional Modeling Expert

Cavendish Professionals; España; On-site; EUR 50,000 - 70,000; Full time

Job summary

Cavendish Professionals in Spain is seeking an experienced Data Modeller with a strong background in Kimball dimensional modeling to design scalable analytics-ready data architectures.

You will work on star and snowflake schemas, fact and dimension tables, slowly changing dimensions, and collaborate with data engineers, BI teams and business stakeholders to translate requirements into robust, well-documented data models for reporting and analytics, including healthcare Encounters data.

Qualifications

• Experience with Kimball dimensional modeling techniques and star/snowflake schemas.
• Strong SQL abilities including complex query writing and optimization.
• Experience with healthcare Encounters data (claims, member/provider data).
• Ability to translate business requirements into data models.
• Collaborate with data engineering and BI teams.

Responsibilities

• Design and maintain dimensional data models using Kimball.
• Develop and optimize SQL queries for data extraction and validation.
• Model healthcare Encounters data in warehouse/lakehouse.
• Collaborate with data engineering and BI teams.
• Document data models and mappings.
• Support downstream reporting needs.

Skills

Kimball modeling

Advanced SQL

Healthcare data

Job description

Cavendish Professionals in Spain is seeking an experienced Data Modeller with a strong background in Kimball dimensional modeling to design scalable analytics-ready data architectures.

You will work on star and snowflake schemas, fact and dimension tables, slowly changing dimensions, and collaborate with data engineers, BI teams and business stakeholders to translate requirements into robust, well-documented data models for reporting and analytics, including healthcare Encounters data.