Data & Analytics Architect - Microsoft Fabric & Power BI

iLink Digital

$145K — $175K *
Information Technology
8 - 10 years of experience
Job Overview by Ladders

Qualifications

  • 10+ years of experience in data architecture and analytics, with at least 3 years in Microsoft Fabric or equivalent Azure data platforms.
  • Hands-on expertise with the full Microsoft Fabric stack, including Data Factory and Power BI architecture.
  • Proficiency in Power BI at an architect level with 6+ years of experience in dimensional modeling and advanced DAX.
  • Strong SQL and PL/SQL skills with experience in query optimization from large Oracle/JD Edwards databases.
  • Familiarity with Azure fundamentals including Entra ID, ADLS Gen2, and security model management.

Responsibilities

  • Own and design the target-state architecture for Microsoft Fabric and Power BI.
  • Build and optimize data pipelines using Fabric Data Factory and Spark notebooks.
  • Architect and manage ingestion from Oracle/JD Edwards, ensuring data accuracy and integrity.
  • Design enterprise-grade semantic models optimizing performance across various data access methods.
  • Define and implement Power BI governance standards including RLS, licensing, and dataset management.
  • Establish CI/CD processes through Git integration for deployment and cost optimization.
  • Mentor and review work of engineers, BI developers, and analysts to ensure standards compliance.

Benefits

  • Comprehensive health and wellness packages.
  • Opportunities for continuous learning and professional development.
  • Flexible work arrangements to support work-life balance.
  • Access to cutting-edge tools and technology in data analytics.
  • Supportive and collaborative corporate culture.
Full Job Description
Job Description
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/domaintopology, OneLake structure, medallion layering, and Lakehouse vs.Warehouse vs. Eventhouse decisions.
  • Design and build Fabric Data Factory pipelines and Sparknotebooks (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 ERPsource-of-truth.
  • Architect enterprise semantic models - star schemas, DirectLake vs. Import vs. Direct Query, advanced DAX, performance tuning atscale.
  • 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 deploymentpipelines, own Fabric capacity sizing, monitoring and cost optimization.
  • Set standards, review code and architecture, and mentorengineers, 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, andproven 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 Fabricadmin/security model.
  • Clear communication with both engineering and businessstakeholders; 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 toFabric

Similar Jobs

More Jobs at iLink Digital

More Information Technology Jobs

Find similar Data & Analytics Architect - Microsoft Fabric & Power BI jobs: