Job Description
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 domai...