Senior Data Modeler

• Design and maintain dimensional data models using Kimball methodology, including star and snowflake schemas, fact and dimension tables, and SCDs
• Model healthcare Encounters data accurately and align it with business and regulatory requirements
• Develop and optimize complex SQL queries for data extraction, transformation, and validation
• Collaborate with data engineering teams to implement models in data warehouse/lakehouse environments
• Perform data profiling, quality checks, gap analysis, and troubleshooting across source and target systems
• Maintain data models, data dictionaries, and mapping specifications
• Partner with BI and analytics teams to support downstream reporting needs

• Healthcare industry experience, including hands-on knowledge of Encounters data (must-have)
• Experience working with claims, member, or provider data in a healthcare payer or provider setting (must-have)
• Strong Kimball dimensional modeling background, including star/snowflake schemas, fact and dimension tables, and slowly changing dimensions (SCDs)
• Advanced SQL skills, including complex query writing, performance tuning, debugging, and data profiling across large datasets
• Proven ability to design logical and physical data models for data warehouses/lakehouses optimized for reporting and analytics
• Familiarity with healthcare data standards, claims processing workflows, and payer/provider data structures is a strong plus
• Excellent problem-solving skills and keen attention to detail
• Ability to collaborate with cross-functional teams and lead technical discussions with data engineers, BI teams, and business stakeholders
• Consultancy mindset and solution-oriented approach

• Long-term contract position
• Remote-first work arrangement
• Required US working hours overlap (2–6 PM CET, ideally until 7 PM CET)