Senior MS Fabric Engineer

BDO Canada; Toronto; On-site; CAD 84,000 - 128,000; Full time

Job summary

BDO Canada is looking for a versatile data professional to support their data platform built on Microsoft Fabric. In this foundational role, the candidate will aid in data ingestion, modeling, and reporting using tools like Power BI.

The position requires strong experience in data engineering with a focus on creating efficient pipelines and models while collaborating with stakeholders to deliver impactful data solutions. Compensation ranges from $84,000 to $128,000.

Qualifications

• 3+ years working in a heavily regulated financial services industry.
• 3+ years of experience in data engineering or BI development.
• Hands-on experience with Microsoft Fabric or Azure Synapse.

Responsibilities

• Design and maintain data pipelines using Microsoft Fabric.
• Model data for usability in Power BI datasets.
• Support proof-of-concept dashboards and reports.

Skills

3+ years in regulated industry

3+ years in data engineering or BI

Hands-on Microsoft Fabric experience

Proficient in T-SQL, DAX, Python

Experience with dimensional modeling

Familiarity with Power BI

Strong problem-solving skills

Tools

Microsoft Fabric

Azure Synapse

Power BI

SQL Server

Oracle databases

Job description

Job Opportunity

We are seeking a versatile data professional to support our data platform built on Microsoft Fabric. This new role will contribute to data ingestion, modeling, and reporting efforts using Fabric's data engineering tools and Power BI.

This is a foundational role as we implement our first data lake and begin integrating sources such as SQL servers, Oracle databases, FTP folders, APIs, and streaming data.

Key Responsibilities

• Design and maintain pipelines using Microsoft Fabric (Dataflows, Pipelines, Notebooks)
• Model data for usability in Power BI datasets and semantic models
• Work with stakeholders to support proof‑of‑concept dashboards and reports
• Monitor and troubleshoot ingestion jobs and data refreshes
• Develop documentation and repeatable workflows
• Collaborate with external consultants and internal teams

Qualifications

• 3+ years working in a heavily regulated industry/financial services industry
• 3+ years of experience in data engineering or BI development
• Hands‑on experience with Microsoft Fabric (or Azure Synapse/Power BI + Lakehouse stack)
• Proficient in T‑SQL, DAX, and Python (for Notebooks)
• Experience with dimensional modeling and self‑serve BI enablement
• Familiarity with Power BI deployment, datasets, and performance tuning
• Strong problem‑solving skills across data ingestion, transformation, and visualization

Nice to Have

• Exposure to systems such as SQL Server, Oracle databases, FTP folders, and API integrations
• Experience integrating REST APIs or structured file sources
• Understanding of RBAC and workspace management in Microsoft Fabric
• Previous experience in real estate, property management, or digital marketing analytics

The expected range of compensation for this role is $84,000 to $128,000.

If you require accommodation to complete the application process, please contact us.