BI Solution Architect

Sigmoid; Bengaluru; On-site; INR 3,500,000 - 6,000,000; Full time

Job summary

Sigmoid is seeking an experienced BI Solution Architect to lead BI transformation initiatives in Bengaluru. The role focuses on governance, migration of dashboards from legacy platforms to Power BI, and accelerating delivery with reusable components.

You will architect enterprise Power BI solutions, optimize performance, and mentor teams while leveraging AI-assisted development and Microsoft Fabric capabilities.

Qualifications

• Experience building BI products & accelerators end-to-end.
• Knowledge of BI tooling including Power BI and Tableau.
• Ability to lead migration and governance initiatives across BI platforms.

Responsibilities

• Lead governance frameworks and best practices for BI deployments.
• Drive end-to-end dashboard migration and modernization at scale.
• Develop reusable accelerators and automation utilities for BI development.
• Optimize performance, security (RLS) and data models in Power BI and Fabric.
• Mentor developers, conduct architecture reviews and lead capability development.
• Provide training and run workshops on DAX, data modeling and BI tooling.

Skills

Power BI

Tableau

Python

React

Node.js

Power BI APIs

Fabric APIs

Power Query

Git

Docker

YAML

JSON

XML

SQL

Tools

Git

Docker

Power BI

Tableau

Snowflake

Databricks

Power BI APIs

Fabric APIs

Job description

We are seeking an experienced and passionate BI Solution Architect to lead our Business Intelligence transformation initiatives.

This role is responsible for:

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.

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.

Accelerator Development

Design and maintain reusable accelerators that improve project delivery, including:

Power Query transformation libraries

Report validation and testing frameworks

Governance toolkits

Performance optimization checklists

Security and Row-Level Security (RLS) templates

Continuously enhance accelerators based on project learnings and evolving best practices.

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.

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

Tableau

Power BI

Programming

Python

React

Node.js

APIs

Power BI APIs

Microsoft Fabric APIs

Data Warehouses

Local: MySQL Server, DuckDB

Cloud: Snowflake, Databricks

Cloud

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

Accelerator Development

Performance Tuning

Technical Leadership

Problem Solving

Stakeholder Management

Coaching & Mentoring

Communication & Presentation

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.

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

Fabric Analytics Engineer Associate (DP-600)