3+ years in a heavily regulated/financial services industry
3+ years in data engineering or BI development
Hands-on experience with Microsoft Fabric/Azure Synapse/Power BI
Proficient in T-SQL, DAX, and Python for Notebooks
Experience with dimensional modeling and self-serve BI
Familiar with Power BI deployment and performance tuning
Strong problem-solving skills in data ingestion, transformation, and visualization
Responsibilities
Design and maintain data pipelines using Microsoft Fabric
Model data for usability in Power BI datasets
Support stakeholders in proof-of-concept dashboards and reports
Monitor and troubleshoot data ingestion jobs and refreshes
Develop documentation and repeatable workflows
Collaborate with external consultants and internal teams
Benefits
Opportunity to work on a foundational data project with Microsoft Fabric
Exposure to a variety of data sources and integrations
Collaborative environment with external consultants
Involvement in real-time data analytics and reporting
Potential for growth within a high-demand field
Full Job Description
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.
Ready to make your mark at BDO? Click "Apply now" to send your up-to-date resume to one of our Talent Acquisition Specialists.
To explore other opportunities at BDO, check out our careers page.
About BDO Canada LLP
BDO Canada LLP is a leading accounting and advisory firm that provides a wide range of services to clients across Canada. The firm offers audit and assurance, tax, advisory, and consulting services to clients in various industries, including manufacturing, retail, real estate, and technology. BDO Canada LLP is part of the global BDO network, which operates in over 160 countries and employs over 80,000 people. The firm is committed to providing exceptional client service and helping clients achieve their business objectives.
