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
Events • Food • Travel • Hospitality • Hotels & Resorts
Supervise daily food and beverage outlet operations, including Starbucks and other outlets as needed. Lead shifts, maintain guest service and product quality standards, mentor team members, assist with scheduling, manage inventory and ordering, support revenue growth through upselling and marketing initiatives, and ensure compliance with health, safety, sanitation, and alcohol regulations.
Events • Food • Travel • Hospitality • Hotels & Resorts
Provides friendly beverage and food service to hotel guests, takes and enters orders through the point-of-sale system, delivers orders, maintains a clean and stocked service station, learns menu details, and follows health, safety, sanitation, and alcohol regulations.
Top Skills:
Point-Of-Sale System
Events • Food • Travel • Hospitality • Hotels & Resorts
Supports hotel bar operations by retrieving and verifying supplies, preparing garnishes and juices, replenishing ice and service items, maintaining kegs and bar equipment, and keeping bar and storage areas clean. The role requires beverage-service knowledge, physical stamina, basic math and English skills, flexibility for nights, weekends, and holidays, and the ability to lift up to 75 pounds. Required certifications include obtaining Responsible Beverage Service and California Food Handler cards within 30 days if applicable.
What you need to know about the San Francisco Tech Scene
San Francisco and the surrounding Bay Area attracts more startup funding than any other region in the world. Home to Stanford University and UC Berkeley, leading VC firms and several of the world’s most valuable companies, the Bay Area is the place to go for anyone looking to make it big in the tech industry. That said, San Francisco has a lot to offer beyond technology thanks to a thriving art and music scene, excellent food and a short drive to several of the country’s most beautiful recreational areas.
Key Facts About San Francisco Tech
- Number of Tech Workers: 365,500; 13.9% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Google, Apple, Salesforce, Meta
- Key Industries: Artificial intelligence, cloud computing, fintech, consumer technology, software
- Funding Landscape: $50.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Sequoia Capital, Andreessen Horowitz, Bessemer Venture Partners, Greylock Partners, Khosla Ventures, Kleiner Perkins
- Research Centers and Universities: Stanford University; University of California, Berkeley; University of San Francisco; Santa Clara University; Ames Research Center; Center for AI Safety; California Institute for Regenerative Medicine
