Bi Solution Architect

Job Summary

We are seeking an experienced and passionate BI Solution Architect to lead our Business Intelligence transformation initiatives. This role is responsible to:

• Innovator BI Practice:

• Developing reusable accelerators

• Optimize PBI Service and workspaces - not just dashboards

• Expedite end-to-end development process ensuring we do more with less

• Lead Programmes that turnround dashboard migration involving thousands of dashboards within few months duration

• Establishing governance 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:

• Building BI products & accelerators end to end
• Visualisation tools: Tableau, PowerBI
• Programming: Python, React, NodeJS
• APIs: PowerBI, Fabric, Tableau
• Warehouses: Local (MySQLServer, DuckDB) , Cloud(Snowflake, Databricks)
• Cloud: Azure, Fabric
• Scripting: PowerShell, YAML, JSON, XML
• Data Ops - GIT, Docker

Good to have skills:

• MSFT MVP Credential
• Contributions to open source projects
• Experience of building accelerators in 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)