Senior MS Fabric Engineer

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

Benefits offered by this job

Competitive compensation

Flexible benefits from day one

Market-leading personal time off

Wellness reimbursement

Job summary

BDO Canada LLP is seeking a versatile data professional to help build and scale our data platform on Microsoft Fabric. You will contribute to ingestion, modeling, and reporting as we implement our first data lake and integrate sources such as SQL Server, Oracle, FTP, APIs, and streaming data.

You will design pipelines, model data for Power BI, and collaborate with stakeholders to deliver prototype dashboards.

Qualifications

• 3+ years in regulated/financial services industry.
• 3+ years in data engineering or BI development.
• Hands-on with Microsoft Fabric (or Azure Synapse/Power BI + Lakehouse stack).
• Proficient in T-SQL, DAX, and Python (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.

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

Skills

Data engineering

BI development

T-SQL

DAX

Python

Self-serve BI

Tools

Microsoft Fabric

Azure Synapse

Power BI

Lakehouse

Job description

Putting people first, every day BDO is a firm built on a foundation of positive relationships with our people and our clients. Each day, our professionals provide exceptional service, helping clients with advice and insight they can trust. In turn, we offer an award-winning environment that fosters a people-first culture with a high priority on your personal and professional growth.

Your Opportunity

We are seeking a versatile data professional to support our data platform built on Microsoft Fabric. This net new role will contribute to data ingestion, modeling, and reporting efforts using Fabric's data engineering and Power BI capabilities. 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 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 like 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.

This job posting is a pipelining exercise for upcoming engagements.

Why BDO?

Our people-first approach to talent has earned us a spot among Canada’s Top 100 Employers for 2026. This recognition is a milestone we’re thrilled to add to our collection of awards for both experienced and student talent experiences.

Our firm is committed to providing an environment where you can be successful in the following ways:

• We enable you to engage with how we change and evolve, being a key contributor to the success and growth of BDO in Canada.
• We help you become a better professional within our services, industries, and markets with extensive opportunities for learning and development.
• We support your achievement of personal goals outside of the office and making an impact on your community.

Giving back adds up: Where company meets community

BDO is actively involved in our communities by supporting local charity initiatives. We support staff with local and national events where you will be given the opportunity to contribute to your community.

Total rewards that matter

• We pay for performance with competitive total cash compensation that recognizes and rewards your contribution.
• We provide flexible benefits from day one, and a market leading personal time off policy.
• We are committed to supporting your overall wellness beyond working hours and provide reimbursement for wellness initiatives that fit your lifestyle.

Everyone counts

• We believe every employee should have the opportunity to participate and succeed.
• Through leadership by our Diversity, Equity and Inclusion Leader, we are committed to a workplace culture of respect, inclusion, and diversity.
• We recognize and celebrate the valuable differences among each of us, including race, religious beliefs, physical or mental disabilities, age, place of origin, marital status, family status, gender or gender identity and sexual orientation.
• If you require accommodation to complete the application process, please contact us.

Flexibility

All BDO personnel are expected to spend some of their time working in the office, at the client site, and virtually unless accommodations or alternative work arrangements are in place. Our model is a blended approach designed to support the flexible needs of our people, the firm and our clients. It’s about creating work experiences that meet everyone’s needs and providing flexibility to adjust when, where and how we work to meet the expectations of our role.

Code of Conduct

Our Code of Conduct sets clear standards for how we conduct business. It reflects our shared values and commitments and includes guiding principles to help us make ethical decisions and maintain trust with each other, our clients, and the public. BDO may use artificial intelligence enabled tools to support certain aspects of the recruitment process. While these tools assist our teams, our use of AI does not replace human decision making, and all employment-related outcomes are made by BDO personnel. More information on BDO Canada’s Privacy Policy can be found here: Privacy Policy | BDO Canada

When it comes to our people, we believe in helping you unlock possibilities, build your passions, and grow your competitive edge. From our expansive client base to growing talent pool, our people are the core of BDO. Our multi-award winning talent experience continues to make us proud. Our culture is open and collaborative. We foster inclusive ways to thinking and celebrate diversity among all contributors. We respect each other, do all things with integrity, and support our people to be their most authentic selves.