Opportunity brief
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. - Optimize DirectQuery, Import, Composite Models, and Hybrid Tables. - Ensure solutions meet enterprise scalability, performance, and security requirements.
Performance Optimization
- Diagnose slow reports and datasets. - Optimize DAX calculations and Power Query transformations. - Improve dataset refresh performance. - Optimize semantic models for large datasets. - Reduce report rendering times through efficient visual design. - Recommend capacity optimization strategies for Power BI Service and Microsoft Fabric.
Technical Leadership
- Mentor Power BI developers and conduct technical reviews. - Lead design discussions and architecture reviews. - Conduct code reviews and ensure adherence to standards. - Support complex development efforts and production issue resolution. - Facilitate knowledge-sharing sessions and internal technical communities.
Training & Capability Development
- Develop onboarding programs for Power BI developers. - Create internal learning paths and technical documentation. - Conduct workshops on DAX.
Must-Have Skills
BI & Visualization
- Building BI products & accelerators end-to-end -
Tableau
-
Power BI
Programming
-
Python
-
React
-
Node.js
APIs
-
Power BI APIs
-
Microsoft Fabric APIs
-
Tableau APIs
Data Warehouses
-
Local: MySQL Server, DuckDB
-
Cloud: Snowflake, Databricks
Cloud
-
Microsoft Azure
-
Microsoft Fabric
Scripting
-
PowerShell
-
YAML
-
JSON
-
XML
DevOps & DataOps
-
Git
-
Docker
Good-to-Have Skills
-
MSFT MVP Credential
- Contributions to open source projects - Experience of building accelerators in the past - End-to-End product thinking from ideation to GTM
Key Competencies
-
Enterprise BI Architecture
-
Dashboard Modernization
-
Accelerator Development
-
Performance Tuning
-
Technical Leadership
-
Innovation Mindset
-
Problem Solving
-
Stakeholder Management
-
Coaching & Mentoring
-
Communication & Presentation
Success Metrics (KPIs)
- Reduction in dashboard migration effort through reusable accelerators. - Improvement in report performance and refresh times. - Increase in Power BI adoption across business teams. - Percentage of reusable components adopted across projects. - Reduction in development cycle time. - Governance compliance across workspaces. - Developer productivity improvements. - User satisfaction with Power BI solutions. - Successful delivery of migration and modernization initiatives. - Growth of organizational Power BI capability through mentoring and training.
Nice-to-Have Certifications
-
Power BI Data Analyst Associate (PL-300)
-
Fabric Analytics Engineer Associate (DP-600)
-
Azure Data Engineer Associate (DP-203)
-
Azure Fundamentals (AZ-900)
Note:
By submitting your application, you consent to being contacted by our Talent Acquisition team via phone call, email, SMS, WhatsApp, or other communication channels regarding your application and relevant career opportunities.