Data & Analytics Architect — Microsoft Fabric & Power BI
Job in
Los Angeles, Los Angeles County, California, 90079, USA
Listing for:
iLink Digital
Full Time
position
Listed on 2026-11-16
Job specializations:
-
IT/Tech
Job Description & How to Apply Below
Data & Analytics Architect — Microsoft Fabric & Power BI
Los Angeles, United States | Posted on 08/13/2026
Data & Analytics Architect — Microsoft Fabric & Power BI
Experience:
10+ years (3+ in Fabric 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, One Lake 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 ERPsource-of-truth.
- Architect enterprise semantic models — star schemas, Direct Lake vs. Import vs. Direct Query, advanced DAX, performance tuning atscale.
- Define Power BI governance: RLS/OLS, Entra 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, andproven extraction from large normalized ERP schemas.
- Advanced SQL, solid Python, Spark tuning, Git-based CI/CD.
- Azure fundamentals (Entra , 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 Enterprise One 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
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
View / Apply for Jobs
Matching My Jurisdiction
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
View / Apply for Jobs
Matching My Jurisdiction