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
Digital Media • Fintech • Information Technology • Machine Learning • Financial Services • Cybersecurity • Automation
The Private Client Financial Advisor develops tailored wealth management strategies, enhances client relationships, and promotes financial services to meet client goals.
Top Skills:
Insurance Health LicenseInsurance Life LicenseInsurance Variable LicenseSeries 63Series 65Series 66Series 7
Digital Media • Fintech • Information Technology • Machine Learning • Financial Services • Cybersecurity • Automation
The Private Client Financial Advisor develops personalized wealth management strategies for clients, enhances partnerships, and drives client engagement.
Top Skills:
Insurance HealthInsurance LifeInsurance VariableSeries 63Series 65Series 66Series 7
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
