Business Intelligence Engineer (Power BI Developer)

OMERS / Oxford Properties Group; Toronto; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A leading pension plan provider in Toronto is seeking a skilled BI Engineer to join their team. The role involves data analysis using Power BI and collaborating with teams to develop insights and reports. Applicants should have at least 5 years of experience and a Bachelor's degree in a related field. This opportunity also offers a flexible hybrid work model.

Qualifications

• 5 years of hands-on experience in data analysis and Power BI development.
• Strong proficiency in Power BI including Power Query and Desktop.
• Experience with relational databases and data warehousing concepts.

Responsibilities

• Ingest data from databases and APIs into Microsoft Fabric Lakehouse.
• Design and maintain data models in the Lakehouse.
• Create reports and dashboards using Power BI.

Skills

Power BI

Data Analysis

SQL

Python

DAX

Education

Bachelor’s degree in computer engineering or related field

Tools

Microsoft Fabric

GitHub CI / CD

Job description

Overview

We are seeking a highly skilled and motivated BI Engineer (Power BI Developer) to join our BI Platform team in Toronto. The ideal candidate will have at least 5 years of hands-on experience in data analysis, leveraging tools such as Power BI, Microsoft Fabric Notebooks (Python), Lakehouse architecture, Data Warehousing concepts, and Gen2 Data Flows to deliver advanced analytics, develop insightful dashboards, and create impactful reports that drive data-informed decisions. Along with having expertise with these tools, the ideal candidate will have experience in using GitHub CI / CD Pipelines to promote Power BI reports, ALM Toolkit, and Tabular Editor.

This is a fantastic opportunity for a BI Engineer to work with cutting-edge data analytical tools while being part of a dynamic BI Platform team that fosters collaboration, encourages innovation, and supports professional growth.

We are a purpose-driven, dynamic and sustainable pension plan with global teams and a shared commitment to our members. Our flexible hybrid work guideline requires teams to come in to the office 4 days per week.

Know someone at OMERS or Oxford Properties? If you’re referred, have them submit your name through Workday first, then watch for a unique link in your email to apply.

Responsibilities

• Data Collection & Integration

  Ingest data from databases, APIs, and external systems into the Microsoft Fabric Lakehouse using Gen2 Dataflows (Power Query) for standard connectors and Fabric Notebooks (Python) for API orchestration and complex logic.

• Data Modeling & Warehousing

  Design and maintain medallion (bronze / silver / gold) layers in the Lakehouse with Delta / Parquet storage; model conformed dimensions and facts per data warehousing best practices.

• Data Refresh & Semantics

  Implement incremental refresh / CDC where applicable and wire up Power BI semantic models (Import / Direct Lake) to curated Lakehouse / DWH tables for high-performance analytics.

• Data Lineage & Documentation

  Ensure lineage and discoverability by publishing certified datasets and documenting data contracts and dependencies across dataflows, notebooks, and models.

• Data Cleaning & Preprocessing

  Clean and preprocess raw data to remove errors, inconsistencies, or duplicate entries and transform data into a structured format suitable for analysis.

• Data Analysis & Interpretation

  Analyze data to identify trends, patterns, and relationships that can provide insights; use statistical methods and predictive models to address business problems.

• Reporting & Visualization

  Create reports, dashboards, and visualizations to communicate data insights clearly and effectively using Power BI; automate recurring reports for timely delivery.

• Collaboration & Communication

  Partner with business, product, and engineering teams to translate requirements into Power BI semantic models, curated datasets, and KPIs; use GitHub CI / CD pipelines and tooling to keep environments consistent; present insights to stakeholders and maintain runbooks.

• Continuous Learning & Improvement

  Identify opportunities to improve existing data processes and analytical techniques; stay current with trends in data analysis and tools.

• Data Governance & Quality Assurance

  Ensure data security, privacy, and regulatory compliance; implement quality control processes and monitor data sources for consistency.

• Ad-Hoc SQL Query Development & Analysis

  Develop SQL queries and perform ad-hoc analysis to fulfill immediate data requests and provide urgent insights.

• Documentation & Knowledge Sharing

  Document analysis methods, assumptions, and results for transparency and reproducibility; share insights with the broader team.

• To succeed in this role, you have

  Bachelor’s degree in computer engineering, Computer Science, Information Technology, or a related field (or equivalent experience).

• 2-5 years of hands-on experience in data analysis, Power BI development and BI Engineering.

• Strong proficiency in Power BI, including Power Query, Power BI Service, Power BI Desktop, Power Platform, Tabular Editor, and Lakehouse / Notebook experience.

• Expertise in DAX for creating measures, calculated columns and complex DAX expressions; experience building semantic data models in Power BI and using GitHub CI / CD pipelines to promote and version control Power BI reports.

• Experience working with relational databases and data warehousing concepts; proficiency in SQL and Python for querying and transforming data.

• Experience or knowledge of Microsoft Fabric preferred.

• A team player and motivated self-starter; strong problem-solving and communication skills; attention to detail.

• Experience with Azure Data Services (Azure SQL Database, Azure Synapse).

• Ability to manage multiple projects and meet deadlines.

Qualifications

• We are an equal opportunity employer committed to an inclusive, barrier-free recruitment and selection process that extends through your employee experience.

Similar Jobs

BI & Data Analyst — Toronto, Ontario