Data Modeler

About the Role

Join our innovative analytics team as a Data Modeler and be instrumental in designing and building robust data models that empower data-driven decision-making across multiple domains—including Commercial Operations, Membership/Education, Product/Clinical, and Compliance/Quality. You will craft scalable, performant data models in a modern cloud environment, supporting reporting, analytics, and governance initiatives.

• Design and develop dimensional models in the Gold layer for key business domains such as orders, inventory, shipment, membership lifecycle, product catalog, and compliance data.
• Define model architecture, establishing grains, surrogate keys, conformed dimensions (Customer, Product, Practitioner, Date, Geography) and role‑playing dimensions to ensure consistency and reusability.
• Implement Slowly Changing Dimensions (SCD) handling Type 1/2 strategies within Delta Lake/Hyperscale Lakehouse architectures for critical dimensions.
• Manage complex data scenarios: late‑arriving facts, inferred members, and bridge tables for many‑to‑many relationships.
• Build and maintain Power BI models, including hierarchies, relationship management, display folders and DAX measures for KPIs such as revenue, margin, inventory days, membership retention and compliance metrics.
• Advance data quality & governance by defining checks, managing lineage, documenting data dictionaries and applying sensitivity labels for PII.
• Optimize performance & cost through partitioning, clustering, indexing, materialized views, and Power BI optimization.
• Collaborate across teams—Data Engineers, BI Analysts, Business Stakeholders—to translate requirements into scalable data models and review pipeline outputs.
• Maintain comprehensive documentation of data dictionaries, lineage diagrams, SCD behaviours and certified metric definitions.
• Define Silver and Gold data contracts, specify quality checks, and ensure pipeline consistency and accuracy.
• Leverage advanced analytics and testing patterns, monitor data freshness and drift, and use version control workflows including Git integration for reliable deployment.

• 3–5 years of experience in data modeling or analytics engineering, with strong SQL expertise.
• Hands‑on experience with Microsoft Fabric, including Lakehouse/Warehouse, One Lake, Delta tables, Dataflows Gen2, or Pipelines; familiarity with SQL endpoints.
• Deep knowledge of dimensional modeling: star schemas, fact types, bridge tables, and complex SCD scenarios.
• Proficiency in Power BI semantic models, DAX and best practices for model optimization, incremental refresh, RLS, and semi‑additive measures.
• Experience in data governance, lineage and quality management.
• Strong communication skills, capable of translating stakeholder needs into clear, dimensioned data models.

• Domain expertise in healthcare, life sciences or pharmacy, including product master data, formulations API catalogs and regulatory artifacts.
• Performance tuning skills in Fabric (warehouse indexing, Delta optimisation, direct‑query or hybrid models).
• Experience with calculation groups, metric governance, Git workflows and deployment pipelines.

• Be at the forefront of analytics innovation, working with cutting‑edge cloud technologies.
• Collaborate with a passionate, multi‑disciplinary team committed to data excellence.
• Benefit from a supportive environment that values continuous learning, professional development and work‑life balance.

$50.00 – $66.00 per hour

Seniority level:
Mid‑Senior level

Employment type:

Full‑time
Job function:
Information Technology
Industries: IT Services and IT Consulting