Business Intelligence Architect

This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a Business Intelligence Architect based in Canada.

• Design, develop, and deliver end-to-end Business Intelligence solutions using Power BI and Microsoft Fabric.
• Build, maintain, and continuously improve enterprise semantic models that support scalable business reporting and analytics.
• Manage, monitor, and optimize Power BI and Fabric environments, including Premium/Fabric capacities.
• Partner with business stakeholders to understand data and reporting requirements and translate them into effective technical solutions.
• Collaborate with data, analytics, and global data governance teams to support current and future enterprise data needs.
• Establish and maintain appropriate Power BI security models, including row-level and object-level security, workspaces, and identity-based access.
• Support report creators and business users by providing guidance, troubleshooting, and clear explanations of technical concepts.
• Automate reporting and BI workflows using Power Platform tools, particularly Power Automate.
• Work with large and complex datasets to develop reliable, performant, and maintainable analytical solutions.
• Contribute to the continuous improvement of BI infrastructure, processes, standards, and user experience.
• Communicate insights, technical decisions, and recommendations clearly to both technical and non-technical stakeholders.

• 6–8 years of professional experience working with Power BI, Microsoft Fabric, and Premium/Fabric capacities.
• Expert-level knowledge of DAX and Power Query, combined with strong data modeling and semantic modeling capabilities.
• Advanced SQL skills and proven experience working with large, complex datasets.
• Strong understanding of Power BI security, including Row-Level Security (RLS), Object-Level Security (OLS), workspaces, and Entra groups.
• Demonstrated experience designing and supporting enterprise-scale semantic models and enabling report development across business teams.
• Good working knowledge of Python for analytics, automation, or data-related use cases.
• Hands-on experience with Power Automate and working knowledge of Azure.
• Strong understanding of BI architecture, reporting infrastructure, data governance, and scalable analytics practices.
• Excellent communication and stakeholder-management skills, with the ability to translate technical concepts into clear business insights.
• Ability to work independently, manage priorities effectively, and collaborate successfully across distributed teams.
• A bachelor’s degree or equivalent professional background in computer science, information systems, data analytics, engineering, or a related discipline is advantageous.

• Remote-first working arrangement within Canada.
• Professional onboarding and training opportunities.
• Supportive and collaborative team environment.
• Career coaching and professional development opportunities.
• Opportunity to work on enterprise-scale Business Intelligence and advanced analytics initiatives.
• Exposure to Microsoft Power BI, Fabric, Power Platform, Azure, and modern data architecture.
• Meaningful opportunity to contribute to data-driven decision-making and continuously improve BI capabilities.
• Final in-person interview availability is required.
• If selected, participation in a 30-day onsite immersion program is required.
• Compensation and additional benefits were not specified in the source job description.