BI Solution Architect at Sigmoid

<p>We are seeking an experienced and passionate&nbsp;<strong>BI Solution Architect</strong> to lead our Business Intelligence transformation initiatives.</p> <p>This role is responsible for:</p> <h3>BI Practice Innovation</h3> <ul> <li> <p>Develop reusable accelerators.</p> </li> <li> <p>Optimize Power BI Service and workspaces—not just dashboards.</p> </li> <li> <p>Expedite the end-to-end development process, ensuring we do more with less.</p> </li> <li> <p>Lead programs that transform dashboard migration involving thousands of dashboards within a few months.</p> </li> <li> <p>Establish governance frameworks and best practices.</p> </li> <li> <p>Identify opportunities to automate repetitive BI development tasks.</p> </li> <li> <p>Build utilities using PowerShell, Power Automate, REST APIs, and Microsoft Fabric capabilities.</p> </li> <li> <p>Leverage AI-assisted development where appropriate.</p> </li> <li> <p>Explore Copilot and AI-driven features to improve productivity.</p> </li> </ul> <h3>Dashboard Modernization &amp; Migration</h3> <ul> <li> <p>Lead migration of dashboards from legacy BI platforms such as Tableau, Qlik, Cognos, Business Objects, SSRS, MicroStrategy, and Excel to Power BI.</p> </li> <li> <p>Assess existing reporting environments and define migration strategies.</p> </li> <li> <p>Develop migration frameworks, templates, and automation utilities.</p> </li> <li> <p>Optimize migrated reports for performance, usability, and maintainability.</p> </li> <li> <p>Minimize business disruption during migration initiatives.</p> </li> </ul> <h3>Accelerator Development</h3> <p>Design and maintain reusable accelerators that improve project delivery, including:</p> <ul> <li> <p>Power Query transformation libraries</p> </li> <li> <p>Deployment automation scripts</p> </li> <li> <p>Report validation and testing frameworks</p> </li> <li> <p>Governance toolkits</p> </li> <li> <p>Metadata documentation generators</p> </li> <li> <p>Performance optimization checklists</p> </li> <li> <p>Migration accelerators</p> </li> <li> <p>Security and Row-Level Security (RLS) templates</p> </li> <li> <p>Continuously enhance accelerators based on project learnings and evolving best practices.</p> </li> </ul> <h3>Solution Architecture</h3> <ul> <li> <p>Design scalable enterprise Power BI solutions.</p> </li> <li> <p>Optimize DirectQuery, Import, Composite Models, and Hybrid Tables.</p> </li> <li> <p>Ensure solutions meet enterprise scalability, performance, and security requirements.</p> </li> </ul> <h3>Performance Optimization</h3> <ul> <li> <p>Diagnose slow reports and datasets.</p> </li> <li> <p>Optimize DAX calculations and Power Query transformations.</p> </li> <li> <p>Improve dataset refresh performance.</p> </li> <li> <p>Optimize semantic models for large datasets.</p> </li> <li> <p>Reduce report rendering times through efficient visual design.</p> </li> <li> <p>Recommend capacity optimization strategies for Power BI Service and Microsoft Fabric.</p> </li> </ul> <h3>Technical Leadership</h3> <ul> <li> <p>Mentor Power BI developers and conduct technical reviews.</p> </li> <li> <p>Lead design discussions and architecture reviews.</p> </li> <li> <p>Conduct code reviews and ensure adherence to standards.</p> </li> <li> <p>Support complex development efforts and production issue resolution.</p> </li> <li> <p>Facilitate knowledge-sharing sessions and internal technical communities.</p> </li> </ul> <h3>Training &amp; Capability Development</h3> <ul> <li> <p>Develop onboarding programs for Power BI developers.</p> </li> <li> <p>Create internal learning paths and technical documentation.</p> </li> <li> <p>Conduct workshops on DAX.</p> </li> </ul> <hr> <h1>Must-Have Skills</h1> <h3>BI &amp; Visualization</h3> <ul> <li> <p>Building BI products &amp; accelerators end-to-end</p> </li> <li> <p>Tableau</p> </li> <li> <p>Power BI</p> </li> </ul> <h3>Programming</h3> <ul> <li> <p>Python</p> </li> <li> <p>React</p> </li> <li> <p>Node.js</p> </li> </ul> <h3>APIs</h3> <ul> <li> <p>Power BI APIs</p> </li> <li> <p>Microsoft Fabric APIs</p> </li> <li> <p>Tableau APIs</p> </li> </ul> <h3>Data Warehouses</h3> <ul> <li> <p><strong>Local:</strong> MySQL Server, DuckDB</p> </li> <li> <p><strong>Cloud:</strong> Snowflake, Databricks</p> </li> </ul> <h3>Cloud</h3> <ul> <li> <p>Microsoft Azure</p> </li> <li> <p>Microsoft Fabric</p> </li> </ul> <h3>Scripting</h3> <ul> <li> <p>PowerShell</p> </li> <li> <p>YAML</p> </li> <li> <p>JSON</p> </li> <li> <p>XML</p> </li> </ul> <h3>DevOps &amp; DataOps</h3> <ul> <li> <p>Git</p> </li> <li> <p>Docker</p> </li> </ul> <hr> <h1>Good-to-Have Skills</h1> <ul> <li> <p>MSFT MVP Credential</p> </li> <li> <p>Contributions to open source projects</p> </li> <li> <p>Experience of building accelerators in the past</p> </li> <li> <p>End-to-End product thinking from ideation to GTM</p> </li> </ul> <hr> <h1>Key Competencies</h1> <ul> <li> <p>Enterprise BI Architecture</p> </li> <li> <p>Dashboard Modernization</p> </li> <li> <p>Accelerator Development</p> </li> <li> <p>Performance Tuning</p> </li> <li> <p>Technical Leadership</p> </li> <li> <p>Innovation Mindset</p> </li> <li> <p>Problem Solving</p> </li> <li> <p>Stakeholder Management</p> </li> <li> <p>Coaching &amp; Mentoring</p> </li> <li> <p>Communication &amp; Presentation</p> </li> </ul> <hr> <h1>Success Metrics (KPIs)</h1> <ul> <li> <p>Reduction in dashboard migration effort through reusable accelerators.</p> </li> <li> <p>Improvement in report performance and refresh times.</p> </li> <li> <p>Increase in Power BI adoption across business teams.</p> </li> <li> <p>Percentage of reusable components adopted across projects.</p> </li> <li> <p>Reduction in development cycle time.</p> </li> <li> <p>Governance compliance across workspaces.</p> </li> <li> <p>Developer productivity improvements.</p> </li> <li> <p>User satisfaction with Power BI solutions.</p> </li> <li> <p>Successful delivery of migration and modernization initiatives.</p> </li> <li> <p>Growth of organizational Power BI capability through mentoring and training.</p> </li> </ul> <hr> <h1>Nice-to-Have Certifications</h1> <ul> <li> <p>Power BI Data Analyst Associate (PL-300)</p> </li> <li> <p>Fabric Analytics Engineer Associate (DP-600)</p> </li> <li> <p>Azure Data Engineer Associate (DP-203)</p> </li> <li> <p>Azure Fundamentals (AZ-900)</p> </li> </ul><div class="content-conclusion"><p><strong>Note:</strong></p> <blockquote class="gmail_quote"><em>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.</em></blockquote> <p></p></div>