MS Fabric Analytics Architect

BCTG’s direct client is in need of an Offshore MS Fabric Analytics Architect

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.
• Align models with enterprise naming standards, glossary terms, metadata and access requirements.
• Help reduce duplicated reporting datasets and inconsistent KPI logic across the organization