inhousefyi
← Back to listings

BI Solution Architect

SigmoidBengaluru, Karnataka, India · Posted 25 days ago
Full-time
Apply now

Description

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.

Similar jobs

Accordion IndiaHyderabad, India

Company Overview Accordion works at the intersection of sponsors and management teams throughout every stage of the investment lifecycle, providing hands-on, execution-focused support to elevate data and analytics capabi…

Full-time
Data Engineer24 days ago

At HSO, we're looking for a proactive and skilled Data Engineer to join our growing team. In this role, you'll design, build, and optimize modern data platforms that enable organizations to unlock the full value of their…

Full-time
Data Engineer2 days ago

At HSO, we're looking for a proactive and skilled Data Engineer to join our growing team. In this role, you'll design, build, and optimize modern data platforms that enable organizations to unlock the full value of their…

Full-time
Particle41Remote

Data Engineer - Power BI Particle41 is looking for a skilled and adaptable Data Engineer (Power BI) to join our growing team. In this role, you will be responsible for building and maintaining scalable ETL/ELT pipelines,…

Full-timeRemote
CapcoBengaluru, India

Job Title: Mid Power BI - Bangalore About Us “Capco, a Wipro company, is a global technology and management consulting firm. Awarded with Consultancy of the year in the British Bank Award and has been ranked Top 100 Best…

Full-time

Est. 120,000 PLN

Xebia is a global AI-first, digital transformation, and engineering partner. With over 25 years of experience and a team of 5,000 professionals across 16 countries, we help organizations design and build scalable product…

Full-timeRemote
Spaulding RidgeChicago, Illinois, United States

Est. 140,000 USD

Spaulding Ridge is an advisory and IT implementation firm. We help global organizations get financial clarity into the complex, daily sales, and operational decisions that impact profitable revenue generations, efficient…

Full-time
Spaulding RidgeToronto, Ontario, Canada

Spaulding Ridge is an advisory and IT implementation firm. We help global organizations get financial clarity into the complex, daily sales, and operational decisions that impact profitable revenue generations, efficient…

Full-time
3CloudRemote

Are you looking for a role that motivates and challenges you? Are you ready for an opportunity for growth? Do you want to work on teams where people roll up their sleeves to take on tough problems together, and regularly…

Full-timeRemote
3CloudRemote

Are you looking for a role that motivates and challenges you? Are you ready for an opportunity for growth? Do you want to work on teams where people roll up their sleeves to take on tough problems together, and regularly…

Full-timeRemote
PicoHyderabad, India

Pico fuels the global capital markets community by providing exceptional market data services and customized managed infrastructure solutions. As financial industry experts at the center of markets and technology, we hel…

Full-time
MAPBarcelona, Catalonia, Spain

Est. 80,000 EUR

Who We Are MAP | WPP Enterprise Solutions designs, builds, and operates the growth systems that competitive businesses rely on. In a world where Al is reshaping how companies drive growth, we lead clients in business tra…

Full-time
MAPMadrid, Community of Madrid, Spain

Est. 65,000 EUR

Who We Are MAP | WPP Enterprise Solutions designs, builds, and operates the growth systems that competitive businesses rely on. In a world where Al is reshaping how companies drive growth, we lead clients in business tra…

Full-time
MAPMálaga, Andalusia, Spain

Est. 65,000 EUR

Who We Are MAP | WPP Enterprise Solutions designs, builds, and operates the growth systems that competitive businesses rely on. In a world where Al is reshaping how companies drive growth, we lead clients in business tra…

Full-time

Est. 120,000 PLN

Company Background Our client is a clinician-founded medical and behavioral health organization providing integrated mental health care across the United States. Founded in 2011, the company combines psychotherapy, psych…

Full-timeRemote
MAPCopenhagen, Capital Region, Denmark

Est. 850,000 DKK

Who We Are MAP | WPP Enterprise Solutions designs, builds, and operates the growth systems that competitive businesses rely on. In a world where Al is reshaping how companies drive growth, we lead clients in business tra…

Full-time
MAPLondon, England, United Kingdom

Est. 80,000 GBP

Who We Are MAP | WPP Enterprise Solutions designs, builds, and operates the growth systems that competitive businesses rely on. In a world where Al is reshaping how companies drive growth, we lead clients in business tra…

Full-time
NortalRemote

Est. 80,000 USD

Join Nortal for your next big adventure. We are seeking Senior Functional Consultant D365 to join our team, grow with us, and teach us a few things along the way. Why join Nortal Say Goodbye to Micromanagement: We champi…

Full-timeRemote

Join Riverside Natural Foods Ltd., a Canadian-based, family-owned, and globally operating business, committed to leaving the world better than we found it. As a B-Corp certified, Triple-Bottom Line company, we proudly ma…

Full-time

Est. 110,000 USD

Hello Wo and GregWe are looking for a BI Developer to join our Technology practice group. This engagement is a remote position and offers the right individual an opportunity to cultivate your skills and expertise across…

Full-timeRemote

Est. 110,000 USD

Hello Wo and GregWe are looking for a BI Developer to join our Technology practice group. This engagement is a remote position and offers the right individual an opportunity to cultivate your skills and expertise across…

Full-timeRemote
3CloudRemote

Est. 137,500 USD

Are you looking for a role that motivates and challenges you? Are you ready for an opportunity for growth? Do you want to work on teams where people roll up their sleeves to take on tough problems together, and regularly…

Full-timeRemote
WorkatoSingapore, Singapore

About Workato Workato delivers enterprise infrastructure for the agentic era, redefining iPaaS and helping enterprises unify data, applications, processes, and AI into a single, governed platform. A leader in Enterprise…

Full-time

Est. 110,000 USD

Hello Wo and GregWe are looking for a BI Developer to join our Technology practice group. This engagement is a remote position and offers the right individual an opportunity to cultivate your skills and expertise across…

Full-timeRemote
EncoraRemote

Job Title: Business Intelligence Key Skills: SQL, Power BI, Tableau, or similar. Experience: 6+ years Location Mexico Mode: Remote We at Coforge are hiring Position (22739) with the following skill set. The Analytics Eng…

Full-timeRemote

Est. 110,000 USD

Hello Wo and GregWe are looking for a BI Developer to join our Technology practice group. This engagement is a remote position and offers the right individual an opportunity to cultivate your skills and expertise across…

Full-timeRemote

Est. 110,000 USD

Hello Wo and GregWe are looking for a BI Developer to join our Technology practice group. This engagement is a remote position and offers the right individual an opportunity to cultivate your skills and expertise across…

Full-timeRemote
FoundryWarsaw, Poland

Est. 80,000 PLN

We are seeking a Dynamics 365 Finance & Operations (D365 F&O) Developer with 3–5 years of experience designing, developing, and supporting solutions within the D365 F&O platform. This role will focus on confi…

Full-time

Est. 84,000 PLN

Xebia is a global AI-first, digital transformation, and engineering partner. With over 25 years of experience and a team of 5,000 professionals across 16 countries, we help organizations design and build scalable product…

Full-timeRemote

Est. 110,000 USD

Hello Wo and GregWe are looking for a BI Developer to join our Technology practice group. This engagement is a remote position and offers the right individual an opportunity to cultivate your skills and expertise across…

Full-timeRemote