Power BI Architect

Required Qualifications

• Design scalable BI solutions with a focus on infrastructure, capacity, and licensing needs.
• Conduct capability assessments to align Power BI adoption with enterprise goals.
• Define and enforce Power BI governance frameworks, including security, data access, and workspace strategy.
• Provide effort estimations and delivery planning for BI initiatives.
• Design and optimize semantic/OLAP models (star schema, composite models, aggregations, dataflows) for enterprise-scale reporting.
• Establish and manage a central metric store for standardized KPIs and calculations.
• Architect and oversee dashboard/report design, ensuring scalability, usability, and consistency across business units.
• Partner with Azure Databricks, Synapse, and Data Lake teams to enable efficient BI consumption of large data.
• Collaborate with Microsoft partner teams to evaluate new capabilities and align with best practices.
• Define and enforce CI/CD strategies using Git, Azure DevOps, and deployment pipelines.
• Oversee data refresh automation, monitoring, and troubleshooting at scale.
• Guide and mentor BI Engineers on best practices in DAX, modeling, performance optimization, and visualization standards.
• Stay current on Microsoft Fabric, Power BI Premium, and emerging BI trends to future-proof the BI strategy.
• 10+ years of experience in Business Intelligence and Data Analytics, with 5+ years in Power BI architecture.
• Proven experience in designing scalable BI/analytics infrastructure solutions.
• Expertise in Power BI Premium/Fabric, DAX, Power Query (M), Tabular Models, and large semantic/OLAP models.
• Strong knowledge of Azure Databricks, Synapse, Data Lake, SQL Server.
• Hands-on with CI/CD pipelines (Git, Azure DevOps, deployment pipelines).
• Skilled in refresh automation, monitoring, and troubleshooting large models.
• Strong understanding of data governance, compliance, and enterprise security frameworks.
• Excellent communication, stakeholder management, and leadership skills.
• Experience working with Microsoft partner teams on solution alignment and best practices.