Data & Analytics Architect — MicrosoftFabric & Power BI
Experience: 10+ years (3+ in Fabric orequivalent Azure data platform)
Role Summary
You are the end-to-end technical authorityfor our analytics estate — from Oracle/JD Edwards source systems throughingestion, Lakehouse and semantic layer, to certified Power BI data products.The role spans the full Microsoft Fabric stack and enterprise Power BIarchitecture, with a hands-on build component alongside the design work.
What You'll Do
Own the target-state Fabric architecture: workspace/domain topology, OneLake structure, medallion layering, and Lakehouse vs.Warehouse vs. Eventhouse decisions.
Design and build Fabric Data Factory pipelines and Spark notebooks (PySpark/Spark SQL) metadata-driven ingestion, orchestration,Delta table optimisation, error handling and monitoring.
Architect ingestion from Oracle / JD Edwards: incremental andCDC extraction, gateway connectivity, reconciliation back to ERP source-of-truth.
Architect enterprise semantic models — star schemas, DirectLake vs. Import vs. Direct Query, advanced DAX, performance tuning at scale.
Define Power BI governance: RLS/OLS, Entra ID group strategy, certified datasets, workspace and tenant settings, gateways, licensing.
Establish CI/CD via Fabric Git integration and deployment pipelines, own Fabric capacity sizing, monitoring and cost optimization.
Set standards, review code and architecture, and mentor engineers, BI developers and analysts.
Must Have
Microsoft Fabric, full stack, hands-on: One Lake,Lakehouse/Delta, Warehouse, Data Factory pipelines, Dataflows Gen2,Notebooks, semantic models, Direct Lake.
Power BI at architect level (6+ yrs): dimensional modelling, advanced DAX and optimization, RLS/OLS, enterprise governance and ALM.
Oracle Database: strong SQL and PL/SQL, query tuning, and proven extraction from large normalized ERP schemas.