Lead enterprise Power BI architecture and governance, design scalable semantic models and high-performance reports, enable self-service analytics, optimize large-dataset performance, and mentor analytics teams while aligning solutions with business requirements and data engineering.
Role Overview
We are looking for a Senior Power BI Architect / Lead to serve as the enterprise technical authority for Power BI and analytics visualization solutions. This role will lead architecture, design governance, and implementation of scalable business intelligence platforms supporting enterprise data strategy, performance, and analytics adoption.
The ideal candidate will drive end-to-end analytics delivery, build optimized semantic models, and enable self-service BI capabilities while collaborating closely with business stakeholders, data engineering teams, and leadership.
Key Responsibilities
- Act as the Power BI Subject Matter Expert (SME) and technical leader for enterprise analytics initiatives.
- Architect, design, and implement enterprise-scale Power BI solutions aligned with data governance and platform standards.
- Lead development of scalable dashboards and reporting solutions handling large transactional datasets (1M+ rows).
- Design and maintain enterprise semantic models and reusable data layers.
- Translate complex business requirements into intuitive, interactive Power BI dashboards.
- Optimize report performance using advanced DAX, data modeling techniques, and query optimization strategies.
- Establish Power BI governance, standards, and best practices across teams.
- Partner with data engineering teams to align data pipelines with reporting requirements.
- Bridge business and technical teams to ensure successful analytics adoption.
- Drive modernization initiatives by transitioning legacy reporting into self-service analytics solutions.
- Provide architectural guidance and mentorship to onshore/offshore analytics teams.
Requirements
- 10+ years of experience in Business Intelligence, Data Analytics, or Data Visualization.
- 5+ years of hands-on experience with Microsoft Power BI in enterprise environments.
- Strong expertise in:
- Power BI Service & Power BI Desktop
- Data Modeling (Star Schema, Semantic Models)
- Advanced DAX development and optimization
- Power Query (M Language)
- Performance tuning and large dataset optimization
- Experience working with enterprise-scale reporting and analytics platforms.
- Strong experience gathering and translating business requirements.
- Excellent stakeholder management and communication skills.
Preferred Qualifications
- Experience with Azure Data Platform (Azure Synapse, Azure SQL, Data Factory, Microsoft Fabric).
- Knowledge of data warehousing, dimensional modeling, and analytics architecture.
- Experience implementing BI governance frameworks and self-service analytics programs.
- Consulting or enterprise delivery experience preferred.
Core Competencies
- Enterprise Architecture Thinking
- Analytics Strategy & Governance
- Performance Optimization
- Cross-functional Leadership
- Data Storytelling & Visualization Design
- Business & Technical Translation
Top Skills
Power Bi,Power Bi Service,Power Bi Desktop,Dax,Power Query (M),Azure Synapse,Azure Sql,Azure Data Factory,Microsoft Fabric,Semantic Models,Star Schema
Similar Jobs
Big Data • Analytics • Business Intelligence • Big Data Analytics
The Power BI Architect will lead BI platform design and governance, ensuring scalable solutions and guiding BI Engineers, while collaborating with Azure teams.
Top Skills:
AzureAzure DatabricksAzure DevopsData LakeDaxGitMicrosoft Power BiPower Bi PremiumPower QuerySQL ServerSynapseTabular Models
Big Data • Cloud • Fintech • Professional Services • Software
The Product Manager, Revenue Systems will manage the billing lifecycle, translate business needs into technical requirements, and optimize financial product integrity. They will collaborate with stakeholders and engineers for effective revenue forecasting and product feature alignment.
Top Skills:
Billing SystemsData AnalysisFinancial AnalysisRevenue Systems
Information Technology
The Senior Solution Architect will design and develop solutions using the Microsoft Azure data stack, collaborating with sales teams, and supporting pre-sales activities while mentoring peers.
Top Skills:
Azure Data StackAzure SqlAzureMicrosoft FabricSynapse
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
