Senior Data Modeler

About the role

Design and maintain dimensional data models using Kimball methods that support reporting and analytics at scale for a healthcare client. Translate business needs into logical and physical models alongside data engineers and BI teams.

What you will do

• Design and maintain star and snowflake schemas, fact and dimension tables and slowly changing dimensions
• Model healthcare encounters data so it meets business and regulatory needs
• Write and tune complex SQL for extraction, transformation and validation
• Work with data engineering to implement models in the warehouse or lakehouse
• Profile data, run quality checks, analyse gaps and troubleshoot across systems
• Maintain data dictionaries and mapping specifications and support BI reporting needs

What they look for

• Healthcare industry experience with hands-on knowledge of encounters data
• Experience with claims, member or provider data in a payer or provider setting
• Strong Kimball dimensional modelling background
• Advanced SQL for complex queries, performance tuning, debugging and profiling large datasets
• Proven ability to design logical and physical models for warehouses or lakehouses
• Strong problem solving, attention to detail and ability to lead technical discussions across teams