Senior Data Modeller

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

We are seeking an experienced Data Modeller with a strong background in 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.

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 validation
• Model healthcare Encounters data, ensuring accuracy and alignment with business and regulatory requirements
• Collaborate with data engineering teams to implement data models within the data warehouse/lakehouse environment
• Perform data quality checks, gap analysis, and troubleshooting across source and target systems
• Document data models, data dictionaries, and mapping specifications
• Partner with BI and analytics teams to ensure models support downstream reporting needs

Required Qualifications:

• 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

Cavendish (Recruitment) Professionals Ltd are 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.