Senior Microsoft Fabric Solution Architect

We are seeking a highly accomplished Senior Microsoft Fabric Solution Architect for an enterprise-level contract opportunity based in Toronto. In this role, you will take on a premier engineering and architectural capacity within business intelligence, analytics enablement, and enterprise data platform streams, specializing in designing, developing, and optimizing modern reporting, semantic modeling, and cloud architecture solutions.

As a principal solution architect, you will bridge the gap between complex enterprise data platforms and interactive self-serve analytics solutions. Operating within a hybrid work model, you will lead the design and modeling of semantic layers, configure deployment pipelines, manage data schemas using Microsoft Fabric and Azure services, and execute report migrations from legacy analytics platforms. This position demands a certified analytics authority who can transform complex financial, HR, and operational datasets into actionable, high-impact business insights while adhering to established project management standards.

Location: Toronto, ON

Assignment Type: Hybrid (2 to 3 days per week onsite)

Contract Duration: 12 months (with potential for 12-month extension)

Advantages

• Modern Microsoft Stack: Lead enterprise analytics solutions leveraging Microsoft Fabric, Power BI, Azure Synapse, and SQL Server.
• Large-Scale Platform Modernization: Direct high-visibility reporting migrations from legacy MicroStrategy systems over to modern Power BI architectures.
• End-to-End Analytics Ownership: Architect semantic models, interactive dashboards, and self-serve analytics environments from inception to deployment.
• Flexible Hybrid Environment: Work within a collaborative hybrid model combining onsite teamwork in Toronto with remote flexibility.

Responsibilities

• Work alongside data and analytics teams to design, build, maintain, and document enterprise business intelligence platforms and cloud solutions.
• Design, model, and document Microsoft Power BI semantic layers, enterprise data structures, interactive dashboards, and executive reports.
• Architect and build datasets utilizing Microsoft Fabric tools, Power BI, Azure Synapse, and SQL Server database services.
• Configure, administer, and optimize environment deployments, managing security roles and implementing automated deployment pipelines in Azure DevOps.
• Lead report and dashboard migration initiatives transitioning legacy MicroStrategy environments to modern analytics architectures.
• Drive self-serve analytics, dashboards, and reporting streams across enterprise functional domains, including Finance, Payroll, HR, and Work Management platforms.
• Partner with Business Analysts and cross-functional teams to translate complex business requirements into clear technical specifications and architecture blueprints.
• Support end users through technical assistance, tool training, semantic layer optimization, and query performance tuning.
• Author comprehensive technical documentation according to established PMO standards, provide accurate work effort estimates, and perform analytical problem solving.

Qualifications

Core Requirements & Mandatory Criteria

• Education: University degree in Computer Science, or equivalent, combined with directly related professional experience in a business or technical discipline.
• BI Development Tenure: Minimum of 5 years of progressive experience working as a Business Intelligence Developer/Architect.
• Mandatory Certification: Active Microsoft Fabric Certification (PL-600, PL-700, or equivalent).
• Power BI & Cloud Data Depth: Extensive hands-on experience developing enterprise BI solutions, semantic layers, schemas, and dashboards using Power BI coupled with Azure Synapse and database services.
• Platform Administration & DevOps: Direct experience configuring and administering analytics environments, managing deployment pipelines, and working with Azure DevOps.
• Relational Database & Data Modeling: Solid experience working with SQL Server (2019 or later) and a strong understanding of data modeling techniques for interfacing BI platforms with data warehouse solutions.

Preferred Assets & Technical Capabilities

• MicroStrategy Experience: Active MicroStrategy Professional Certification and hands-on experience developing schemas, data cubes, and reports in MicroStrategy (2020 or later) is considered a strong asset.
• Accessibility & Regulatory Knowledge: Understanding of human rights codes, accessibility standards, and disability accommodation requirements pertaining to digital solutions.

Soft Skills & Collaboration

• Analytical Problem Solving: Superior diagnostic and troubleshooting capabilities to resolve complex data integration, modeling, and performance issues.
• Communication & Stakeholder Engagement: Well-developed oral, written, and interpersonal communication skills to collaborate effectively with technical squads and business leaders.

Only qualified candidates will be contacted for the next steps. We look forward to hearing from you!

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada’s workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to View email address on publisher.sourcingsquare.com to ensure their ability to fully participate in the interview process.

This posting is for existing and upcoming vacancies.