Data & Analytics Architect

Job Information

• Date Opened: 08/13/2026
• Job Type: Full time
• Industry: IT Services
• State/Province: California
• City: Los Angeles
• Zip/Postal Code: 90001
• Country: United States

Job Description

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