Data & Analytics Architect — Microsoft Fabric & Power BI

iLink Digital; Los Angeles (CA); Hybrid; USD 170,000 - 210,000; Full time

Job summary

iLink Digital in Los Angeles, CA seeks a Data & Analytics Architect to own the end-to-end analytics stack across Microsoft Fabric and Power BI. You will lead ingestion, lakehouse design, semantic modeling, and governance with hands-on build work and strategic oversight.

The role requires 10+ years of experience (3+ in Fabric or equivalent Azure data platform) and strong collaboration with engineering and business stakeholders. On-site in Los Angeles with potential for enterprise-scale projects.

Qualifications

• Must have hands-on expertise across Microsoft Fabric stack: One Lake, Lakehouse, Data Factory, Notebooks, semantic models and Direct Lake.
• Power BI at architect level with enterprise governance and ALM experience.
• Strong SQL/PLSQL and Python, Spark tuning, and Git-based CI/CD.
• Azure fundamentals including Entra ID, ADLS Gen2 and Key Vault.

Responsibilities

• Own the target-state Fabric architecture including workspace topology and Lakehouse decisions.
• Design and build Fabric pipelines, Spark notebooks, and metadata-driven ingestion.
• Architect data ingestion from Oracle/JD Edwards and reconcile ERP sources.
• Define enterprise semantic models and governance (RLS/OLS, datasets, gateways).
• Set CI/CD via Fabric Git integration and monitor cost optimization.
• Mentor BI engineers and analysts; review code and architecture.

Skills

Fabric full stack

Power BI architect

Oracle SQL/PLSQL

Python

Spark

Git CI/CD

Azure fundamentals

Entra ID / security

Data Governance

Communication & docs

Tools

Fabric Data Factory pipelines

Delta tables

Notebooks (PySpark)

OneLake / Lakehouse

Power BI datasets governance

Job description

Data & Analytics Architect — Microsoft Fabric & Power BI

Los Angeles, United States | Posted on 08/13/2026

Data & Analytics Architect — MicrosoftFabric & Power BI

Experience: 10+ years (3+ in Fabric equivalent 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/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 to Fabric