Back to jobs

Senior Data Engineer, Risk Technology

Reads like an Analytics Engineer role: dbt models and clean tables.

Pay
CAD 105,000–138,000/year · BaseAnnual period assumed — pay source
‎ The base salary range for this position is CAD $105,000.00 - $138,000.00. The placement within the range is determined by the range of market pay for the specific position, as well as the candidate's knowledge, skillset and experience relative to the requirements of the position and to internal peers. In addition to base salary, this position is eligible to participate in IMCO's annual incentive plan. As a candidate, you are encouraged to ask compensation related questions and have an open dialogue with your recruiter who can provide you with the specific details for this position, as well as the total rewards offering at IMCO including our comprehensive benefits package and defined benefit pension plan.‎ We thank all applicants for their interest. Only those selected for an interview will be contacted.
Read the full posting
Work setting
Not stated
Employment
Full-time — employment source
Employment type in the employer’s posting: Full time
From the employer’s posting

What you’ll work on

Full posting
  • Design and build complex Power BI reports, dashboards, and semantic models

  • Manage Fabric capacity, compute use, and report performance

  • Build data pipelines that feed Power BI models from Snowflake and Databricks

  • Develop ETL and transformations in Azure Databricks and Snowflake using SQL, Python, and PySpark

  • Manage Power BI access, security, and periodic access reviews

From the employer’s posting
Design, develop, test, deploy, and support sophisticated Power BI reports, dashboards, and interactive visual experiences
Understand and actively manage Fabric capacity considerations, including compute consumption, memory guardrails
Design and support data pipelines that reliably hydrate Power BI semantic models from Snowflake, Databricks
Develop complex, performant, and maintainable solutions in Azure Databricks and Snowflake using SQL, Python, and PySpark.
Implement governed Power BI access management, including workspaces, apps, audiences, Microsoft Entra security groups
Apply at Imcoinvest

Posting record

Report an error
Status in our records
Live
First seen by us
Sep 27, 202652 days ago
Recorded sightings
31
Last seen by us
Nov 15, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 52

Up longer than most. Similar jobs usually come down between day 7 and day 51.

From 1,691 similar postings that came down. Coming down is not always a hire.

Imcoinvest is hiring

1 open job

Open jobs by the week we first saw them, last 12 weeks.

  • Hiring has slowed
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • Azure
  • Databricks
  • Power BI
  • Power Query
  • Snowflake
  • PySpark
Where the posting names them
As a key member of the Risk Technology team, the Senior Data Engineer will be the team’s senior hands-on Power BI developer, responsible for designing complex reports and visuals, scalable semantic models, and governed business intelligence solutions. The successful candidate will be expected to apply a practical understanding of Fabric capacity, compute consumption, memory constraints, performance, and workload management. The role also requires strong data engineering capability. The successful candidate will build and support reliable data pipelines that hydrate Power BI semantic models from enterprise data warehouses and will develop complex ETL and transformation solutions using Azure Databricks, Snowflake, Azure Data Factory, SQL, Python, and PySpark. This position combines deep technical delivery with stakeholder partnership. The incumbent will collaborate with business users, business systems analysts, data engineers, platform teams, and external providers, and will contribute to a constructive, inclusive, and accountable team environment. The role follows the organization’s hybrid working model and requires regular in-office collaboration.
Data Engineering (Secondary Area of Accountability) - Develop complex, performant, and maintainable solutions in Azure Databricks and Snowflake using SQL, Python, and PySpark. - Develop and orchestrate data integration workflows using Azure Data Factory and other approved Azure data services.
- Advanced SQL skills, including complex queries, tables, views, stored procedures, query optimization, and performance tuning. - Proficiency in Python and PySpark for scalable data processing and automation. - Developed data warehouses with change data capture (CDC) and implemented dimensional data warehouses.
- Minimum 3 years of Databricks experience with strong data engineering experience, including complex transformations and performance-aware development. - Advanced SQL skills, including complex queries, tables, views, stored procedures, query optimization, and performance tuning. - Proficiency in Python and PySpark for scalable data processing and automation.
- Develop complex, performant, and maintainable solutions in Azure Databricks and Snowflake using SQL, Python, and PySpark. - Develop and orchestrate data integration workflows using Azure Data Factory and other approved Azure data services. - Create and optimize database objects, data transformations, data quality controls, and reconciliation processes with a strong understanding of dimensional and analytical data modeling.
- Automate manual processes and improve data delivery, observability, scalability, recoverability, and operational efficiency. - Contribute to solution architecture and technical design for the Databricks, Snowflake, Microsoft Fabric, and Azure data ecosystem. Delivery, Operations and Collaboration
- Experience in financial services, pension management, investment management, and capital markets is desirable. - Relevant Microsoft Power BI, Fabric, Azure data engineering, Databricks, Snowflake, or Power Platform certification is an asset. ‎
- Use capacity and performance telemetry to identify bottlenecks, recommend remediation, and balance report responsiveness, refresh schedules, model size, and platform stability. - Design and support data pipelines that reliably hydrate Power BI semantic models from Snowflake, Databricks, enterprise data warehouses, lakehouses, and other approved data sources. - Implement governed Power BI access management, including workspaces, apps, audiences, Microsoft Entra security groups, role-based access, sharing, row-level security, deployment permissions, and periodic access reviews.
- Hands-on experience developing and supporting Power Automate cloud flows, ideally integrated with Power BI, Microsoft 365, approvals, alerts, or other enterprise services. - Minimum 3 years of Databricks experience with strong data engineering experience, including complex transformations and performance-aware development. - Advanced SQL skills, including complex queries, tables, views, stored procedures, query optimization, and performance tuning.
Risk Technology is part of the Data Technology group and partners primarily with Investment Risk to deliver technology, data, analytics, reporting, and production-support capabilities through small and medium-sized initiatives, multi-year programs, and ongoing operational services. As a key member of the Risk Technology team, the Senior Data Engineer will be the team’s senior hands-on Power BI developer, responsible for designing complex reports and visuals, scalable semantic models, and governed business intelligence solutions. The successful candidate will be expected to apply a practical understanding of Fabric capacity, compute consumption, memory constraints, performance, and workload management. The role also requires strong data engineering capability. The successful candidate will build and support reliable data pipelines that hydrate Power BI semantic models from enterprise data warehouses and will develop complex ETL and transformation solutions using Azure Databricks, Snowflake, Azure Data Factory, SQL, Python, and PySpark.
As a Member of Our Team You Will be Responsible For: Power BI development and reporting framework (Primary Area of Accountability) - Design, develop, test, deploy, and support sophisticated Power BI reports, dashboards, and interactive visual experiences for Investment Risk and related stakeholders.
Power BI development and reporting framework (Primary Area of Accountability) - Design, develop, test, deploy, and support sophisticated Power BI reports, dashboards, and interactive visual experiences for Investment Risk and related stakeholders. - Build and optimize enterprise-grade Power BI semantic models, including dimensional design, relationships, measures, calculation groups where appropriate, row-level security, object-level security, incremental refresh, and model performance tuning.
- Design, develop, test, deploy, and support sophisticated Power BI reports, dashboards, and interactive visual experiences for Investment Risk and related stakeholders. - Build and optimize enterprise-grade Power BI semantic models, including dimensional design, relationships, measures, calculation groups where appropriate, row-level security, object-level security, incremental refresh, and model performance tuning. - Write and optimize complex DAX and Power Query (M) logic, applying clear development standards and reusable design patterns.
- Design and support data pipelines that reliably hydrate Power BI semantic models from Snowflake, Databricks, enterprise data warehouses, lakehouses, and other approved data sources. - Implement governed Power BI access management, including workspaces, apps, audiences, Microsoft Entra security groups, role-based access, sharing, row-level security, deployment permissions, and periodic access reviews. - Design, build, test, and support Power Automate cloud flows that extend Power BI solutions through data-driven alerts, notifications, approvals, scheduled actions, and user-triggered workflows.
- Implement governed Power BI access management, including workspaces, apps, audiences, Microsoft Entra security groups, role-based access, sharing, row-level security, deployment permissions, and periodic access reviews. - Design, build, test, and support Power Automate cloud flows that extend Power BI solutions through data-driven alerts, notifications, approvals, scheduled actions, and user-triggered workflows. - Apply appropriate Power Automate governance and support practices, including connection management, environment awareness, secure sharing, run monitoring, exception handling, and operational documentation.
- Apply appropriate Power Automate governance and support practices, including connection management, environment awareness, secure sharing, run monitoring, exception handling, and operational documentation. - Promote effective Power BI lifecycle management through source control, deployment pipelines, environment segregation, release controls, documentation, and CI/CD practices. Data Engineering (Secondary Area of Accountability)
What do you need to succeed? - Minimum 7 years of progressive experience in advanced Power BI development expertise, including complex report design, visual storytelling, semantic modeling, DAX, Power Query, model optimization, refresh design, and troubleshooting. - Experience of delivering data, analytics, data warehousing, or business intelligence solutions, with substantial recent hands-on Power BI development experience.
- Minimum 7 years of progressive experience in advanced Power BI development expertise, including complex report design, visual storytelling, semantic modeling, DAX, Power Query, model optimization, refresh design, and troubleshooting. - Experience of delivering data, analytics, data warehousing, or business intelligence solutions, with substantial recent hands-on Power BI development experience. - Demonstrated experience building governed, enterprise-scale Power BI solutions rather than solely creating ad hoc or departmental reports.
- Experience of delivering data, analytics, data warehousing, or business intelligence solutions, with substantial recent hands-on Power BI development experience. - Demonstrated experience building governed, enterprise-scale Power BI solutions rather than solely creating ad hoc or departmental reports. - Hands-on Microsoft Fabric experience, or directly transferable experience with Power BI Premium capacity, including capacity monitoring, compute and memory constraints, workload management, performance tuning, and migration planning.
- Demonstrated experience building governed, enterprise-scale Power BI solutions rather than solely creating ad hoc or departmental reports. - Hands-on Microsoft Fabric experience, or directly transferable experience with Power BI Premium capacity, including capacity monitoring, compute and memory constraints, workload management, performance tuning, and migration planning. - Experience designing and operating pipelines that load or transform data for Power BI semantic models from cloud data warehouses or Lakehouse platforms.
- Hands-on Microsoft Fabric experience, or directly transferable experience with Power BI Premium capacity, including capacity monitoring, compute and memory constraints, workload management, performance tuning, and migration planning. - Experience designing and operating pipelines that load or transform data for Power BI semantic models from cloud data warehouses or Lakehouse platforms. - Practical experience administering Power BI access through workspaces, apps, audiences, security groups, permissions, and row-level security, with an understanding of least-privilege access and controlled content distribution.
- Experience designing and operating pipelines that load or transform data for Power BI semantic models from cloud data warehouses or Lakehouse platforms. - Practical experience administering Power BI access through workspaces, apps, audiences, security groups, permissions, and row-level security, with an understanding of least-privilege access and controlled content distribution. - Hands-on experience developing and supporting Power Automate cloud flows, ideally integrated with Power BI, Microsoft 365, approvals, alerts, or other enterprise services.
- Practical experience administering Power BI access through workspaces, apps, audiences, security groups, permissions, and row-level security, with an understanding of least-privilege access and controlled content distribution. - Hands-on experience developing and supporting Power Automate cloud flows, ideally integrated with Power BI, Microsoft 365, approvals, alerts, or other enterprise services. - Minimum 3 years of Databricks experience with strong data engineering experience, including complex transformations and performance-aware development.
- Build and optimize enterprise-grade Power BI semantic models, including dimensional design, relationships, measures, calculation groups where appropriate, row-level security, object-level security, incremental refresh, and model performance tuning. - Write and optimize complex DAX and Power Query (M) logic, applying clear development standards and reusable design patterns. - Partner closely with business users to translate analytical requirements into intuitive visual designs, rapidly prototype solutions, validate usability, and incorporate feedback throughout delivery.

Your next step

Complete your application on imcoinvest.wd3.myworkdayjobs.com. The employer’s form will show what is required.

Applying through Workday

  • You create an account with each employer before you can upload anything. Every Workday employer has its own account, so one sign-up doesn’t carry over.
  • “Autofill with Resume” comes right after sign-in, before the My Information and My Experience steps. Check every field it fills in those steps, since that’s what recruiters see.
  • Your application status lives in that employer’s Candidate Home, under the same sign-in.

Already applied? Track this application

Job description

View original posting ↗

At IMCO, our talent is among the best! IMCO offers a uniquely stimulating and rewarding environment where you can help build and drive organizational transformation, all while seeking to challenge yourself, learn, and grow your career.

Our culture is built on collaboration and passion, with a shared commitment to delivering lasting value to the clients we serve. Located in downtown Toronto, our vision is to be the partner of choice for Ontario’s public sector funds and to build a high-performing, value-driven asset management firm.

This job posting is for an existing vacancy. If you are ready to deliver best-in-class service and join a collaborative, motivated and fun team of professionals, IMCO offers the opportunity to do impactful work and broaden your expertise.

If you’re looking to use your expertise to drive strategic outcomes, we’d love to hear from you.

‎

Risk Technology is part of the Data Technology group and partners primarily with Investment Risk to deliver technology, data, analytics, reporting, and production-support capabilities through small and medium-sized initiatives, multi-year programs, and ongoing operational services.


As a key member of the Risk Technology team, the Senior Data Engineer will be the team’s senior hands-on Power BI developer, responsible for designing complex reports and visuals, scalable semantic models, and governed business intelligence solutions. The successful candidate will be expected to apply a practical understanding of Fabric capacity, compute consumption, memory constraints, performance, and workload management.


The role also requires strong data engineering capability. The successful candidate will build and support reliable data pipelines that hydrate Power BI semantic models from enterprise data warehouses and will develop complex ETL and transformation solutions using Azure Databricks, Snowflake, Azure Data Factory, SQL, Python, and PySpark.


This position combines deep technical delivery with stakeholder partnership. The incumbent will collaborate with business users, business systems analysts, data engineers, platform teams, and external providers, and will contribute to a constructive, inclusive, and accountable team environment. The role follows the organization’s hybrid working model and requires regular in-office collaboration.


The incumbent will report to the Senior Manager, Data Technology.


As a Member of Our Team You Will be Responsible For:


Power BI development and reporting framework (Primary Area of Accountability)

  • Design, develop, test, deploy, and support sophisticated Power BI reports, dashboards, and interactive visual experiences for Investment Risk and related stakeholders.
  • Build and optimize enterprise-grade Power BI semantic models, including dimensional design, relationships, measures, calculation groups where appropriate, row-level security, object-level security, incremental refresh, and model performance tuning.
  • Write and optimize complex DAX and Power Query (M) logic, applying clear development standards and reusable design patterns.
  • Partner closely with business users to translate analytical requirements into intuitive visual designs, rapidly prototype solutions, validate usability, and incorporate feedback throughout delivery.
  • Understand and actively manage Fabric capacity considerations, including compute consumption, memory guardrails, concurrency, refresh demand, background versus interactive workloads, throttling risk, and workload optimization.
  • Use capacity and performance telemetry to identify bottlenecks, recommend remediation, and balance report responsiveness, refresh schedules, model size, and platform stability.
  • Design and support data pipelines that reliably hydrate Power BI semantic models from Snowflake, Databricks, enterprise data warehouses, lakehouses, and other approved data sources.
  • Implement governed Power BI access management, including workspaces, apps, audiences, Microsoft Entra security groups, role-based access, sharing, row-level security, deployment permissions, and periodic access reviews.
  • Design, build, test, and support Power Automate cloud flows that extend Power BI solutions through data-driven alerts, notifications, approvals, scheduled actions, and user-triggered workflows.
  • Apply appropriate Power Automate governance and support practices, including connection management, environment awareness, secure sharing, run monitoring, exception handling, and operational documentation.
  • Promote effective Power BI lifecycle management through source control, deployment pipelines, environment segregation, release controls, documentation, and CI/CD practices.

Data Engineering (Secondary Area of Accountability)

  • Develop complex, performant, and maintainable solutions in Azure Databricks and Snowflake using SQL, Python, and PySpark.
  • Develop and orchestrate data integration workflows using Azure Data Factory and other approved Azure data services.
  • Create and optimize database objects, data transformations, data quality controls, and reconciliation processes with a strong understanding of dimensional and analytical data modeling.
  • Build custom services and workflows when needed to complement platform capabilities, including file-format conversion, third-party API integration, and external web-service calls.
  • Automate manual processes and improve data delivery, observability, scalability, recoverability, and operational efficiency.
  • Contribute to solution architecture and technical design for the Databricks, Snowflake, Microsoft Fabric, and Azure data ecosystem.

Delivery, Operations and Collaboration

  • Work closely with business systems analysts, subject-matter experts, platform teams, and vendors to deliver solutions, investigate root causes, recommend changes, and maintain accurate technical and operational documentation.
  • Monitor production solutions, investigate incidents, perform performance tuning, and enhance service reliability through effective incident, problem, change, configuration, and release-management practices.
  • Prepare functional and technical specifications, data-flow documentation, support procedures, test evidence, deployment plans, and knowledge-transfer materials.
  • Facilitate testing and production implementation while acting as a trusted liaison between Technology, Investment Risk stakeholders, and external solution providers.
  • Share design, coding, troubleshooting, and analytical practices with colleagues through reviews, pairing, documentation, and knowledge sessions.
  • Demonstrate a constructive and collaborative working style, openness to feedback, accountability for outcomes, and willingness to support colleagues across disciplines.
  • Participate effectively in the organization’s hybrid working model, including regular in-office collaboration with the team and stakeholders.

What do you need to succeed?


  • Minimum 7 years of progressive experience in advanced Power BI development expertise, including complex report design, visual storytelling, semantic modeling, DAX, Power Query, model optimization, refresh design, and troubleshooting.
  • Experience of delivering data, analytics, data warehousing, or business intelligence solutions, with substantial recent hands-on Power BI development experience.
  • Demonstrated experience building governed, enterprise-scale Power BI solutions rather than solely creating ad hoc or departmental reports.
  • Hands-on Microsoft Fabric experience, or directly transferable experience with Power BI Premium capacity, including capacity monitoring, compute and memory constraints, workload management, performance tuning, and migration planning.
  • Experience designing and operating pipelines that load or transform data for Power BI semantic models from cloud data warehouses or Lakehouse platforms.
  • Practical experience administering Power BI access through workspaces, apps, audiences, security groups, permissions, and row-level security, with an understanding of least-privilege access and controlled content distribution.
  • Hands-on experience developing and supporting Power Automate cloud flows, ideally integrated with Power BI, Microsoft 365, approvals, alerts, or other enterprise services.
  • Minimum 3 years of Databricks experience with strong data engineering experience, including complex transformations and performance-aware development.
  • Advanced SQL skills, including complex queries, tables, views, stored procedures, query optimization, and performance tuning.
  • Proficiency in Python and PySpark for scalable data processing and automation.
  • Developed data warehouses with change data capture (CDC) and implemented dimensional data warehouses.
  • Understanding data quality, GitHub source control, CI/CD, and production support practices for enterprise BI and data solutions.
  • Strong communication, problem-solving, prioritization, and collaboration skills, with the ability to work effectively with technical and business stakeholders in a hybrid environment.
  • Experience in financial services, pension management, investment management, and capital markets is desirable.
  • Relevant Microsoft Power BI, Fabric, Azure data engineering, Databricks, Snowflake, or Power Platform certification is an asset.

‎

The base salary range for this position is CAD $105,000.00 - $138,000.00. The placement within the range is determined by the range of market pay for the specific position, as well as the candidate's knowledge, skillset and experience relative to the requirements of the position and to internal peers. In addition to base salary, this position is eligible to participate in IMCO's annual incentive plan. As a candidate, you are encouraged to ask compensation related questions and have an open dialogue with your recruiter who can provide you with the specific details for this position, as well as the total rewards offering at IMCO including our comprehensive benefits package and defined benefit pension plan.

‎

We thank all applicants for their interest. Only those selected for an interview will be contacted.

Our hybrid work model prioritizes an office-first approach, encouraging employees to make the most of our collaborative workspace at 16 York Street, Suite 2400, Toronto, ON M5J 0E6. This welcoming environment fosters teamwork, connection, and professional growth. While flexibility remains a key component of our model, we believe that regular in-office engagement enhances productivity and strengthens our culture. Our approach supports a fulfilling lifestyle that balances professional ambition with personal wellbeing.

IMCO is committed to providing accommodation for people with disabilities throughout the recruitment process. If you require support, please let us know and we will work with you to meet your needs. Artificial intelligence (AI) tools may be used to support parts of our recruitment process, such as screening and assessments. However, all hiring decisions are made by our recruitment team. Candidates being considered for this position will be required to undergo background screening.

Demand for Analytics Engineer roles

New Analytics Engineer postings at the employers we follow are down 20% over the last 6 weeks compared with the 6 before.

Weekly new Analytics Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 82, the most 171, and the latest week had 93.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analytics Engineer, by the work the posting describes.

Analytics engineers turn raw warehouse data into clean, tested and documented tables that analysts and dashboards can rely on, often with dbt.

Expect strong SQL, data modeling, Git, and a warehouse such as Snowflake, BigQuery or Redshift.

A data engineer gets data into the warehouse; an analytics engineer shapes it once it is there and works closer to the analysts who use it.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for analytics engineers, so these figures are for the closest group, database architects, the same group we use for data engineers.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
‎ The base salary range for this position is CAD $105,000.00 - $138,000.00. The placement within the range is determined by the range of market pay for the specific position, as well as the candidate's knowledge, skillset and experience relative to the requirements of the position and to internal peers. In addition to base salary, this position is eligible to participate in IMCO's annual incentive plan. As a candidate, you are encouraged to ask compensation related questions and have an open dialogue with your recruiter who can provide you with the specific details for this position, as well as the total rewards offering at IMCO including our comprehensive benefits package and defined benefit pension plan.‎ We thank all applicants for their interest. Only those selected for an interview will be contacted.
Location & working pattern

Toronto - 16 York St

The role also requires strong data engineering capability. The successful candidate will build and support reliable data pipelines that hydrate Power BI semantic models from enterprise data warehouses and will develop complex ETL and transformation solutions using Azure Databricks, Snowflake, Azure Data Factory, SQL, Python, and PySpark. This position combines deep technical delivery with stakeholder partnership. The incumbent will collaborate with business users, business systems analysts, data engineers, platform teams, and external providers, and will contribute to a constructive, inclusive, and accountable team environment. The role follows the organization’s hybrid working model and requires regular in-office collaboration. The incumbent will report to the Senior Manager, Data Technology.
More source context
- Demonstrate a constructive and collaborative working style, openness to feedback, accountability for outcomes, and willingness to support colleagues across disciplines. - Participate effectively in the organization’s hybrid working model, including regular in-office collaboration with the team and stakeholders. What do you need to succeed?

More relevant text appears in the full description.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.