Senior Power BI & Data Engineer

Investment Management Corporation of Ontario; Toronto; Hybrid; CAD 105,000 - 138,000; Full time

Benefits offered by this job

Annual incentive plan

Comprehensive benefits

Defined benefit pension plan

Job summary

Investment Management Corporation of Ontario (IMCO) is seeking a Senior Data Engineer focusing on Power BI development and data engineering within the Risk Technology arm of the Data Technology group.

You will design complex Power BI reports, build enterprise semantic models, and manage governance and security for BI solutions in a hybrid work model with regular in-office collaboration at 16 York Street, Toronto.

Qualifications

• Minimum 7 years of progressive experience in Power BI development, including complex report design, semantic modeling, DAX, Power Query, and maintenance of enterprise BI solutions.
• Hands-on experience with Databricks, Snowflake, Azure Data Factory, SQL, Python, and PySpark.
• Strong understanding of governance, security, access control, and rollout of enterprise BI platforms.

Responsibilities

• Design, develop, test, deploy, and support sophisticated Power BI reports and semantic models for Investment Risk and stakeholders.
• Develop data pipelines to hydrate semantic models from Snowflake, Databricks, and data warehouses using Azure Data Factory.
• Implement governance, access management, and CI/CD practices for BI solutions.
• Support data engineering tasks in Azure Databricks and Snowflake and collaborate with business teams and external providers.

Skills

Power BI

DAX

SQL

Python

PySpark

Databricks

Snowflake

Azure Data Factory

Fabric

Data Modeling

BI Governance

CI/CD

Tools

Databricks

Snowflake

Azure Data Factory

Power BI

Microsoft Fabric

Job description

Investment Management Corporation of Ontario (IMCO) is seeking a Senior Data Engineer focusing on Power BI development and data engineering within the Risk Technology arm of the Data Technology group.

You will design complex Power BI reports, build enterprise semantic models, and manage governance and security for BI solutions in a hybrid work model with regular in-office collaboration at 16 York Street, Toronto.