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 nee...