Fabric Architect

Vaco Recruiter Services; Guelph; On-site; CAD 150,000 - 180,000; Full time

Job summary

A Canadian financial services provider is seeking a skilled engineer to optimize their Microsoft Fabric platform for enterprise analytics. The ideal candidate will have experience with Power BI, CI/CD processes, and automation using PowerShell or Python. This role involves defining standards for Fabric usage and ensuring security compliance. A salary range of $150,000 to $180,000 is offered, reflecting the importance of this position within the organization.

Qualifications

• Must have strong experience with Microsoft Fabric and Power BI.
• Experience with CI/CD and tools like Azure DevOps is crucial.
• Proficiency in scripting languages like PowerShell and Python is required.

Responsibilities

• Engineer and optimize Microsoft Fabric platform for analytics.
• Implement CI/CD pipelines for deployments across environments.
• Develop and optimize Power BI semantic models.

Skills

Hands-on experience with Microsoft Fabric

Experience with Power BI

Azure Data Factory

SQL proficiency

CI/CD for analytics

Automation with PowerShell

Python proficiency

Advanced DAX expertise

Data modeling skills

Experience with Lakehouse/Dataflows

Job description

About the Company

Our client is a leading Canadian insurance and financial services provider, recognized as one of Canada’s Top 100 Employers.

About the Opportunity

• Engineer and optimize Microsoft Fabric platform for enterprise-scale analytics.
• Implement CI/CD pipelines for Fabric & Power BI deployments across environments (Dev/Test/Prod).
• Automate workflows for provisioning, dataset refreshes, and governance using PowerShell, Python, or Fabric APIs.
• Define and enforce Center of Excellence (CoE) standards for Fabric usage.
• Collaborate with architects to address platform gaps and fast-track Fabric adoption.
• Monitor and optimize performance, capacity planning, and troubleshoot issues.
• Develop and optimize Power BI semantic models, composite models, and Direct Lake.
• Ensure security and governance (RLS, OLS, Purview compliance).

About You

• Strong hands‑on experience with Microsoft Fabric, Power BI, Azure Data Factory, and SQL.
• Proven experience with CI/CD for analytics workloads using Git and tools like Azure DevOps.
• Proficiency in PowerShell, Python, or Fabric APIs for automation.
• Advanced DAX expertise and performance tuning for large datasets.
• Strong data modeling skills and experience with Lakehouse/Dataflows.

Bonus Items

• Familiarity with Microsoft Purview for governance.
• Experience with capacity planning and performance optimization at enterprise scale.
• Knowledge of scripting for governance checks and workspace automation.
• Exposure to composite models and Direct Lake concepts.

Salary Range

$150-180,000/year

How to Apply

Click the “Apply Now” button and follow the instructions to submit your resume. Please note that we only accept documents in MS Word or Rich Text formats. When referencing this job, quote #466225.

Requirements

You must currently reside within the Greater Toronto Area and be permitted to work in Canada to be considered for this opportunity. A recruiter will be in touch with you if your profile meets our client’s requirements for this role.