Your OpportunityWe 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.
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
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.
