Senior Data Modeller; Microsoft Fabric

Position: Senior Data Modeller (Microsoft Fabric)
Key Responsibilities

● Design conceptual, logical and physical data models for enterprise data onboarding
and analytics use cases.

● Define modelling patterns for Fabric Lakehouse, Fabric Warehouse and Power BI
semantic consumption.

● Support the implementation of bronze, silver and gold data layers using Medallion
Architecture principles.

● Design conformed dimensions, fact tables, reference data structures, master data
views and analytics-ready datasets.

● Define model grain, business keys, surrogate keys, relationships, hierarchies and
history handling.

● Create source-to-target mappings and work with engineers to turn modelling
designs into working data assets.

● Help define reusable Silver-layer datasets that are more than cleansed copies of
source systems.

● Design Gold-layer models around reporting, KPIs, business questions and decision
- making needs.

● Work with domain teams to understand business processes, data ownership, key
metrics and analytical requirements.

● Support Power BI semantic model design by ensuring data structures are clear,
performant and business-friendly.

● Document business definitions, model assumptions, lineage, data quality rules and
known limitations.

● Work with governance teams to align models with naming standards, glossary
terms, metadata and access requirements.

● Participate in architecture reviews, data model reviews and discussions around
shared enterprise definitions.

● Help reduce duplicated reporting datasets and inconsistent KPI logic across the
organization.

Ideal Candidate
Strong Senior Data Modeller profile (Microsoft Fabric / Medallion Architecture)
Mandatory (Experience
1) – Must have 6+ years of experience in Data Modeling or Enterprise Data Architecture, with strong hands-on expertise in designing conceptual, logical, and physical data models for enterprise data platforms.
Mandatory (Experience
2) – Must have hands-on experience designing data models on Microsoft Fabric, specifically Fabric Lakehouse, Fabric Warehouse and One Lake, within a modern Lakehouse architecture.
Mandatory (Experience
3) – Must have strong hands-on dimensional modeling expertise, including star schemas, fact tables, conformed dimensions, slowly changing dimensions (SCDs), grain definition, business keys and surrogate keys
Mandatory (Experience
4) – Must have proven experience designing data models across Bronze, Silver and Gold layers using Medallion Architecture principles, including reusable business-aligned Silver datasets and consumption-ready Gold analytical models
Mandatory (Experience
5) – Must have strong SQL expertise, with the ability to read transformation logic, understand joins and aggregations, define source-to-target mappings, and validate that implemented logic matches the intended business model.
Mandatory (Experience
6) – Must have experience designing analytics-ready datasets for BI/reporting consumption and supporting semantic model design (e.g. Power BI), ensuring data structures are clear, performant and business-friendly.
Mandatory (Experience
7) – Must have experience documenting business definitions, source-to-target mappings, lineage, data quality rules and model assumptions, and collaborating across architects, data engineers, analysts and business stakeholders.
Preferred (Experience) – Familiarity with broader Azure data services and data product-oriented delivery.
Preferred (Domain) – Experience in regulated or enterprise-scale data environments, and Agile delivery.