SonicJobs Logo
Left arrow iconBack to search
  1. Home
  2. Singing Springs, CA
  3. Data & Analytics Architect — Microsoft Fabric & Power BI

Data & Analytics Architect — Microsoft Fabric & Power BI

iLink Digital
Posted a month ago, valid for 20 days
Location

Singing Springs, CA, US

Salary

Competitive

Contract type

Full Time

By applying, a Sonicjobs account will be created for you. Sonicjobs's Privacy Policy and Terms & Conditions will apply.

SonicJobs' Terms & Conditions and Privacy Policy also apply.

Sonic Summary

info
  • The position is for a Data & Analytics Architect at Microsoft, requiring over 10 years of experience, with a minimum of 3 years in Microsoft Fabric or an equivalent Azure data platform.
  • The architect will be responsible for the entire analytics architecture, including the design and implementation of data ingestion, Lakehouse structures, and Power BI governance.
  • Key responsibilities include building Fabric Data Factory pipelines, architecting semantic models, and establishing CI/CD processes, while also mentoring engineers and BI developers.
  • Candidates must possess hands-on experience with the full Microsoft Fabric stack, advanced SQL, and Power BI at an architect level, along with strong communication skills.
  • The salary for this role is competitive, reflecting the seniority and expertise required.

Data & Analytics Architect — MicrosoftFabric & Power BI

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




Learn more about this Employer on their Career Site

Apply now in a few quick clicks

By applying, a Sonicjobs account will be created for you. Sonicjobs's Privacy Policy and Terms & Conditions will apply.

SonicJobs' Terms & Conditions and Privacy Policy also apply.

Logo
SonicJobs
Your next career move. Sorted.
Search jobsbackground image

Contact us

© 2017 - 2026 SonicJobs Inc. All rights reserved

Terms & Conditions | Privacy Policy | Browse Jobs