Power BI Solution Architect

Power BI Solution Architect with Admin & Optimization

Role Overview

Power BI Architect

Key Responsibilities

• Define and implement

  Power BI architecture

  for enterprise analytics.
• Establish

  best practices

  for BI development, governance, and optimization.
• Drive BI roadmap and adoption across business units.
• Manage Power BI Service administration, including:
• Workspace governance and capacity planning
• Premium configuration and licensing strategies
• Security implementation (Row-Level Security, Object-Level Security)
• Monitoring, auditing, and usage analytics
• Implement data compliance and governance frameworks.
• Optimize Power BI reports, datasets, and queries for large-scale environments.
• Implement strategies for query folding, model optimization, and BigQuery performance tuning.
• Architect and optimize Power BI solutions integrated with Google BigQuery.
• Ensure efficient query performance and cost optimization in BigQuery.
• Lead migration strategy for Tableau dashboards to Power BI.
• Ensure feature parity, performance optimization, and improved user experience during migration.
• Design optimized data models and semantic layers for large-scale datasets.
• Develop advanced DAX calculations, Power Query transformations, and custom visuals.
• Partner with stakeholders to gather requirements and deliver actionable insights.
• Mentor BI developers and ensure adherence to architectural standards.

Required Skills & Qualifications

Technical Expertise

• Advanced proficiency in Power BI Desktop, Power BI Service, and Power BI Gateway.
• Strong command of DAX, Power Query (M), and data modeling principles.
• Hands-on experience with Google BigQuery and SQL optimization.
• Deep experience in Power BI administration, including capacity management, governance, and security.
• Familiarity with Power BI Premium, licensing strategies, and monitoring tools.
• Proven ability to optimize Power BI performance for large datasets and complex models.
• Successful track record of Tableau-to-Power BI migration projects.
• Solid understanding of data warehousing concepts, ETL processes, and dimensional modeling.
• Excellent communication and stakeholder management skills.
• Ability to lead and mentor teams in BI development.

Preferred Skills

Experience with Power BI Embedded and DevOps for BI (CI/CD pipelines).

Familiarity with Azure Data Platform and hybrid cloud environments.