BI Solution Architect
Posted 4 Aug 2026
BranchFactor Summary
The original posting with the fluff stripped out
- Management level
- People management
No salary listed for this role.
We are seeking an experienced and passionate BI Solution Architect to lead our Business Intelligence transformation initiatives.
This role is responsible for:
BI Practice Innovation
-
Develop reusable accelerators.
-
Optimize Power BI Service and workspaces—not just dashboards.
-
Expedite the end-to-end development process, ensuring we do more with less.
-
Lead programs that transform dashboard migration involving thousands of dashboards within a few months.
-
Establish governance frameworks and best practices.
-
Identify opportunities to automate repetitive BI development tasks.
-
Build utilities using PowerShell, Power Automate, REST APIs, and Microsoft Fabric capabilities.
-
Leverage AI-assisted development where appropriate.
-
Explore Copilot and AI-driven features to improve productivity.
Dashboard Modernization & Migration
-
Lead migration of dashboards from legacy BI platforms such as Tableau, Qlik, Cognos, Business Objects, SSRS, MicroStrategy, and Excel to Power BI.
-
Assess existing reporting environments and define migration strategies.
-
Develop migration frameworks, templates, and automation utilities.
-
Optimize migrated reports for performance, usability, and maintainability.
-
Minimize business disruption during migration initiatives.
Accelerator Development
Design and maintain reusable accelerators that improve project delivery, including:
-
Power Query transformation libraries
-
Deployment automation scripts
-
Report validation and testing frameworks
-
Governance toolkits
-
Metadata documentation generators
-
Performance optimization checklists
-
Migration accelerators
-
Security and Row-Level Security (RLS) templates
-
Continuously enhance accelerators based on project learnings and evolving best practices.
Solution Architecture
-
Design scalable enterprise Power BI solutions.