Data & Analytics Architect - Microsoft Fabric & Power BI

Data & Analytics Architect - Microsoft Fabric & Power BI Experience: 10+ years (3+ in Fabric or equivalent Azure data platform) Role Summary You are the end-to-end technical authority for our analytics estate - from Oracle/JD Edwards source systems through ingestion, Lakehouse and semantic layer, to certified Power BI data products. The role spans the full Microsoft Fabric stack and enterprise Power BI architecture, 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 and CDC extraction, gateway connectivity, reconciliation back to ERP source-of-truth. Architect enterprise semantic models - star schemas, Direct Lake 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. Advanced SQL, solid Python, Spark tuning, Git-based CI/CD. Azure fundamentals (Entra ID, ADLS Gen2, Key Vault) and Fabric admin/security model. Clear communication with both engineering and business stakeholders; strong documentation discipline. Good to Have JD Edwards EnterpriseOne functional knowledge - Finance, Distribution and/or Manufacturing; familiarity with F-tables (F0911, F4211, F0411), UDCs, Julian dates and JDE data conventions. Microsoft certifications : DP-600 / DP-700, PL-300. Experience migrating legacy data and analytics platforms to Fabric