Sr BI Architect
$121,000–$121,000 year
On-siteOakbrook Terrace, Illinois, United States
Job Summary
Design and govern core BI solutions by developing multi-year platform roadmaps, translating business requirements into physical data environments using Kimball methodology, and leading Tabular semantic model design in Power BI Premium and Microsoft Fabric. Enforce development standards, manage capacity and gateway administration, and ensure platform compliance through regular audits against HIPAA and enterprise security standards. Author deployment plans with rollback procedures, lead postmortems, and drive root cause analysis to closure. Direct technical work for two offshore consultants by assigning tasks, reviewing code, and ensuring deliverables meet platform standards. Partner with stakeholders to gather requirements, estimate effort, build business cases, and communicate tradeoffs to non-technical audiences. Enable self-service analytics through documented standards, reusable assets, and stakeholder enablement.
Required Qualifications
- Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent professional experience
- 8+ years building relational dimensional data models using Kimball methodology
- 5+ years of hands-on Power BI development, including semantic model design, advanced DAX, and performance tuning with DAX Studio or Tabular Editor
- 5+ years with Power BI Datasets and SSAS Tabular, including Row Level Security and Object Level Security
- 5+ years working with an Enterprise Data Warehouse and writing ETL
- Expert level Microsoft SQL Server T SQL, including complex queries, stored procedures, and performance optimization
- Hands on experience with Microsoft Fabric (Lakehouse, Warehouse, Direct Lake, OneLake) and judgment on when to apply Import, Direct Query, or Direct Lake modes
- Experience with Power BI deployment pipelines, Git source control, and workspace lifecycle management across Dev, Test, and Production
- Experience with Azure data pipelines moving data from Data Lake to Synapse. SSIS experience for data extraction
- Excellent written and verbal communication, with the ability to produce technical and business documentation others can act on independently
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.