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

Valuable 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)

📌 Bi Solution Architect (Bengaluru)
🏢 Astar Data
📍 Bengaluru