BI Solution Architect

Job 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 o