Job Role: BI Solution Architect

• Location: Bengaluru

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

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)