Power BI Solution Architect

Role Overview: Solution Architect / Technical Lead to support a large-scale Migration and Transformation. This role will lead the migration of thousands of dashboards from Tableau to Power BI, define the technical architecture, and design a scalable onboarding and report bursting strategy for thousands of users across the enterprise.

Key Responsibilities: Architecture & Infrastructure (must have)

• Design and implement a modern Power BI architecture with key focus on enterprise data gateways, workspace domain structures, streamlining workspaces organization and governance frameworks.
• Define and lead the enterprise-wide strategy for Microsoft Fabric.
• Establish best practices for Fabric capacity planning, workspace configuration, and data governance.
• Collaborate with data engineering and analytics teams to ensure seamless integration of Fabric components into existing data ecosystems.
• Ensure secure, scalable, and high-performance deployment of Power BI across the organization.
• Collaborate with infrastructure and security teams to align gateway configurations and data access protocols.

Migration Strategy (must have)

• Help the team lead the strategic planning of the migration from Tableau to Power BI.
• Ensure data fidelity, performance optimization, and stakeholder alignment throughout the migration lifecycle.

Deployment Pipelines & CI/CD (must have)

• Design and implement Power BI deployment pipelines to support version control, environment promotion (dev/test/prod), and automated validation.
• Integrate CI/CD practices for Power BI and Fabric assets to ensure consistent and reliable delivery of updates.

Report Bursting & Distribution (nice to have)

• Architect a report bursting strategy to deliver personalized reports based on user roles, regions, or business units.
• Leverage Power BI capabilities (e.g., paginated reports, subscriptions, Power Automate) to automate report distribution.
• Ensure compliance with data security and privacy policies during report delivery.
• Monitor and optimize report delivery performance and user experience.

User Onboarding & Enablement (nice to have)

• Develop and execute a robust onboarding strategy for thousands of users across business units.
• Create training materials, user guides, and support models to facilitate adoption.
• Establish role-based access controls, workspace provisioning, and usage monitoring.

Governance & Collaboration (must have)

• Define and enforce governance policies for data refresh schedules, sharing permissions, and lifecycle management.
• Partner with data engineering, analytics, and business teams to ensure alignment on data sources and reporting needs.
• Serve as a technical advisor and evangelist for Power BI best practices.

Required Qualifications:

• 10+ years of experience in BI and analytics, with at least 3+ years in Power BI architecture and development.
• Proven experience in large-scale dashboard migration projects, especially from Tableau to Power BI.
• Strong expertise in Power BI service, DAX, Power Query, data gateways, and workspace management.
• Experience with report bursting using Power BI paginated reports, Power Automate, or third-party tools.
• Familiarity with Azure services (e.g., Synapse, Data Factory, ADLS) is a plus.

Excellent communication and stakeholder engagement skills.