Owns end-to-end Microsoft Fabric and Power BI architecture, from Oracle and JD Edwards ingestion through Lakehouse, Warehouse, semantic models, governance, and certified data products. Designs and builds Fabric pipelines, Spark notebooks, Delta optimizations, enterprise Power BI models, security, CI/CD, capacity management, and monitoring. Establishes architecture standards, reviews code, optimizes performance and costs, and mentors engineering, BI, and analytics teams.
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/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
Similar Jobs
Fintech • Financial Services
Manage complex Mid-Corporate credit portfolios, supporting underwriting, financial modeling, projections, risk analysis, loan structuring, portfolio monitoring, renewals, and annual reviews. Partner with relationship managers and credit approvers to originate and grow client relationships while maintaining compliance with credit policies. Present recommendations, exercise independent judgment, support risk-rating decisions, and help develop less experienced team members.
Top Skills:
ExcelMS OfficeNcino
Artificial Intelligence • Automotive • Greentech • Information Technology • Machine Learning • Software • Cybersecurity
Processes billing transactions, invoices, credits, payments, and account adjustments; maintains customer accounts; audits billing information; researches and resolves discrepancies; handles customer inquiries; monitors billing reports; supports collections and approval workflows; maintains documentation; and partners with internal teams to improve billing accuracy and efficiency.
Top Skills:
ExcelOracleOutlookPowerPointWord
Artificial Intelligence • Automotive • Greentech • Information Technology • Machine Learning • Software • Cybersecurity
Handles customer billing inquiries by phone and email; processes, audits, and adjusts invoices; maintains customer accounts; posts payments; researches discrepancies; monitors billing reports; supports collections; documents resolutions; and collaborates with internal teams to resolve billing concerns.
Top Skills:
ExcelMicrosoft OutlookMicrosoft PowerpointMicrosoft WordOracle
What you need to know about the Los Angeles Tech Scene
Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.
Key Facts About Los Angeles Tech
- Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
- Key Industries: Artificial intelligence, adtech, media, software, game development
- Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
- Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering
