BI Solution Architect | Sigmoid | Bengaluru

Vskills; Bengaluru; On-site; INR 1,800,000 - 2,600,000; Full time

Job summary

Vskills is seeking a BI Solution Architect to lead our BI practice, focusing on dashboard modernization and migration to Power BI. The role encompasses building reusable accelerators, governance, and automation utilities, with emphasis on performance, security, and scalable architecture.

You will guide migration from Tableau, Qlik, Cognos, and other tools to Power BI, design enterprise-grade BI solutions, and mentor the BI team.

Qualifications

• Builds reusable BI accelerators and dashboards across platforms.
• Experience migrating dashboards from legacy BI tools to Power BI.
• Knowledge of governance, security (RLS) and data modeling best practices.
• Strong scripting and automation capabilities (PowerShell, REST APIs).
• Able to lead design reviews, mentor developers, and drive technical decisions.

Responsibilities

• Lead BI practice initiatives and accelerators development.
• Oversee migration of dashboards from Tableau, Qlik, Cognos, SSRS, MicroStrategy to Power BI.
• Develop templates, automation utilities, and validation frameworks.
• Architect scalable Power BI solutions with DirectQuery, Import, and Hybrid models.
• Improve performance, optimize data models and dataset refresh.
• Mentor developers and conduct code reviews.
• Provide training and capability development for the team.

Skills

BI Visualization

Tableau

Power BI

Python

React

Node.js

Tools

Power BI APIs

Microsoft Fabric APIs

Tableau APIs

Git

Docker

YAML

JSON

XML

MySQL

Snowflake

Databricks

Azure

Job description

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)