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.

Positive 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).

📌 Sigmoid Analytics - BI Solution Architect (India)
🏢 Sigmoid
📍 India