Senior Data Engineer, Risk Technology
Role Overview
The Senior Data Engineer is the team’s senior hands-on Power BI developer, creating complex reports, scalable semantic models, and governed business intelligence solutions.
The role also builds reliable data pipelines and complex ETL and transformation solutions, combining technical delivery with stakeholder partnership.
The organization identifies this as an existing vacancy.
Key Skills for This Role
Full Job Posting
Organization and team
IMCO is an asset management firm serving Ontario’s public-sector funds.
Risk Technology partners with Investment Risk to provide technology, data, analytics, reporting, and production support through initiatives, programs, and ongoing services.
The position reports to the Senior Manager, Data Technology.
Role overview
The Senior Data Engineer is the team’s senior hands-on Power BI developer, creating complex reports, scalable semantic models, and governed business intelligence solutions.
The role also builds reliable data pipelines and complex ETL and transformation solutions, combining technical delivery with stakeholder partnership.
The organization identifies this as an existing vacancy.
Power BI and reporting
- Design, develop, test, deploy, and support Power BI reports, dashboards, and interactive visual experiences for Investment Risk and related stakeholders.
- Build and optimize semantic models, including dimensional design, relationships, measures, calculation groups where appropriate, row- and object-level security, incremental refresh, and performance tuning.
- Write and optimize DAX and Power Query (M) using clear standards and reusable patterns.
- Partner with business users to translate analytical requirements into visual designs, prototype, validate usability, and incorporate feedback.
- Manage Fabric capacity, compute, memory, concurrency, refresh demand, workloads, and optimization; use telemetry to identify bottlenecks and recommend remediation.
- Design and support pipelines that hydrate semantic models from Snowflake, Databricks, enterprise warehouses, lakehouses, and approved sources.
- Govern Power BI access through workspaces, apps, audiences, Entra groups, role-based access, sharing, permissions, and periodic reviews.
- Build and support Power Automate flows for alerts, notifications, approvals, scheduled actions, and user-triggered workflows.
- Apply Power Automate governance, secure connection and sharing practices, monitoring, exception handling, and operational documentation.
- Promote source control, deployment pipelines, environment segregation, release controls, documentation, and CI/CD for Power BI lifecycle management.
Data engineering
- Develop complex, performant, and maintainable data engineering solutions using Azure Databricks and the listed data technologies.
Work arrangement
- The role follows a hybrid working model and requires regular in-office collaboration.
Requirements
- Strong hands-on experience developing Power BI reports, visuals, semantic models, and governed business intelligence solutions.
- Practical understanding of Fabric capacity, compute consumption, memory constraints, performance, and workload management.
- Strong data engineering capability, including reliable data pipelines and complex ETL and transformation solutions.
- Experience with Azure Databricks, Snowflake, Azure Data Factory, SQL, Python, and PySpark.
- Ability to partner with business users and technical teams to translate analytical requirements into delivered solutions.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Investment Management Corporation of Ontario
Intern, Fundamental Equities (Summer 2027)
Toronto, CAN
IMCO seeks a student intern to support its Fundamental Equities team in evaluating public-company investment opportunities. The work includes investment research, financial modeling, valuation, and investment reporting.
Associate, Performance and Analytics, Reporting
Toronto, CAN
IMCO is hiring an Associate for its Performance Measurement and Analytics team on a 12-month contract. The role produces investment performance reporting and analysis; candidates need a relevant undergraduate degree, two
Analyst, Real Estate (Fixed-term contract)
Toronto, CAN
IMCO is seeking a Real Estate Analyst to support portfolio management, asset monitoring, reporting, and investment research. The role also contributes to due diligence, financial modeling, application improvements, and i
Intern, Corporate Finance
Toronto, CAN
IMCO is seeking a Corporate Finance Intern for a four-month placement supporting financial reporting and corporate accounting. The role includes financial statements, external audit coordination, month-end close, reconci
Associate Investment Risk Research and Analytics
Toronto, CAN
Intern, Fundamental Equities (Summer 2027)
Toronto, CAN
Associate, Performance and Analytics, Reporting
Toronto, CAN
Analyst, Real Estate (Fixed-term contract)
Toronto, CAN
Intern, Corporate Finance
Toronto, CAN
Associate Investment Risk Research and Analytics
Toronto, CAN