Back to jobs

Senior Data Engineer

Pay
$125,000/year · BaseAnnual period assumed — pay source
Salary: The maximum potential base salary for this position is $125,000 This salary range reflects the expected base compensation for the role across Canada. Actual compensation will be determined based on factors such as experience, qualifications, and scope of responsibilities. Trisura provides this range in good faith in accordance with applicable legislation. This position is for an existing, currently vacant position. #LI-HYBRID
Read the full posting
Work setting
Not stated
Employment
Not stated

What you’ll work on

Full posting
  • Build batch and near-real-time data pipelines using Microsoft Fabric and Azure Data Factory

  • Write ETL/ELT transformations in T-SQL, Python, PySpark and Spark SQL

  • Design dimensional, relational and Lakehouse data models for analytics and reporting

  • Add monitoring, alerting, data quality controls and reconciliation to pipelines

  • Migrate legacy SSIS, SSRS and ADF workloads to Microsoft Fabric and cloud platforms

From the employer’s posting
Design, build, test, deploy, and support scalable batch and near-real-time data pipelines
Develop robust, reusable ETL/ELT and data transformation solutions using T-SQL, Python, PySpark, and Spark SQL
Design dimensional, relational, and Lakehouse data models that support analytics
Ensure production reliability by implementing monitoring, alerting, logging, data quality controls, reconciliation
Support the modernization and migration of legacy SSIS, SSRS, Azure Data Factory, SQL-based, and other data integration workloads

What you’ll bring

All qualifications

Core experience

  • Bachelor's degree, college diploma, or equivalent practical experience in Computer Science, Information Systems, Data Engineering, Software Engineering, or a related field.
  • Demonstrated experience designing and delivering end-to-end data solutions rather than only developing individual ETL components or reports.
  • Demonstrated experience troubleshooting complex production data issues and improving platform reliability, performance, and maintainability.

Preferred experience

  • Experience providing technical leadership, mentoring, code review, solution design, or engineering standards is strongly preferred.
  • Experience in Insurance or another regulated financial-services environment is strongly preferred.
Qualification wording
Bachelor's degree, college diploma, or equivalent practical experience in Computer Science, Information Systems, Data Engineering, Software Engineering, or a related field. Minimum 5 years of progressive experience in data engineering, data integration, data warehousing, analytics engineering, or related roles, including ownership of production data solutions. Demonstrated experience designing and delivering end-to-end data solutions rather than only developing individual ETL components or reports. Demonstrated experience troubleshooting complex production data issues and improving platform reliability, performance, and maintainability. Experience providing technical leadership, mentoring, code review, solution design, or engineering standards is strongly preferred. Experience in Insurance or another regulated financial-services environment is strongly preferred. Microsoft Fabric, Azure Data Engineer, Azure, Power BI, or related Microsoft certifications are considered an asset.
Education & alternatives
Qualifications Bachelor's degree, college diploma, or equivalent practical experience in Computer Science, Information Systems, Data Engineering, Software Engineering, or a related field. Minimum 5 years of progressive experience in data engineering, data integration, data warehousing, analytics engineering, or related roles, including ownership of production data solutions. Demonstrated experience designing and delivering end-to-end data solutions rather than only developing individual ETL components or reports. Demonstrated experience troubleshooting complex production data issues and improving platform reliability, performance, and maintainability. Experience providing technical leadership, mentoring, code review, solution design, or engineering standards is strongly preferred. Experience in Insurance or another regulated financial-services environment is strongly preferred. Microsoft Fabric, Azure Data Engineer, Azure, Power BI, or related Microsoft certifications are considered an asset. Location:

Posting record

Report an error
Status in our records
Live
First seen by us
Sep 26, 202656 days ago
Recorded sightings
49
Last seen by us
Nov 22, 2026
Employer says posted
Sep 24, 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 56

Similar jobs usually come down between day 6 and day 56.

From 14,766 similar postings that came down. Coming down is not always a hire.

Trisura Guarantee Insurance Company is hiring

1 open job

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

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
  • T-SQL
  • Azure
  • Delta Lake
  • PostgreSQL
  • Power BI
  • Spark
  • SQL Server
  • SSIS
  • SSRS
  • PySpark
Where the posting names them
We are currently seeking a driven and collaborative Senior Data Engineer to join our forward-thinking Data and Analytics team. SENIOR DATA ENGINEER TORONTO Position Overview: As a Senior Data Engineer on our Data & Analytics Team, you will be a hands-on technical leader responsible for designing, building, operating, and continuously improving scalable, secure, and reliable data solutions. The role will help modernize Trisura’ s data platform, enable trusted analytics and reporting, and establish engineering standards across ingestion, transformation, orchestration, deployment, monitoring, data quality, and documentation. Working closely with Data & Analytics, application teams, architects, analysts, governance, and business stakeholders, the Senior Data Engineer will translate business requirements into reusable data products and production-grade solutions across Microsoft Fabric, Azure, SQL Server, Power BI, and related technologies. What you will do: Design, build, test, deploy, and support scalable batch and near-real-time data pipelines for structured, semi-structured, and unstructured data using Microsoft Fabric, Azure Data Factory, SSIS, SQL Server, Azure SQL, cloud storage, and other enterprise data sources. Develop modern data engineering solutions using Microsoft Fabric capabilities such as Lakehouse, Warehouse, OneLake, Copy Jobs, Notebooks, Dataflow Gen2, and related services, applying layered bronze/silver/gold architecture patterns where appropriate. Develop robust, reusable ETL/ELT and data transformation solutions using T-SQL, Python, PySpark, and Spark SQL, including incremental loading, Change Data Capture (CDC), schema evolution, reconciliation, restart/recovery, idempotency, and error-handling patterns. Design dimensional, relational, and Lakehouse data models that support analytics, operational and regulatory reporting, self-service analytics, and downstream system integrations. Ensure production reliability by implementing monitoring, alerting, logging, data quality controls, reconciliation, metadata, lineage, auditability, and operational support procedures. Optimize SQL, Spark, pipeline, and storage workloads for performance, scalability, reliability, and cost efficiency while applying security and privacy best practices, including least-privilege access, managed identities, service principals, secrets management, secure connectivity, and environment separation. Implement source control, automated deployment, and CI/CD practices using Git, Azure DevOps, and Microsoft Fabric deployment capabilities, and participate in code reviews, testing, release planning, incident resolution, root-cause analysis, and post-implementation reviews. Develop reusable engineering standards, frameworks, templates, patterns, and technical documentation to improve consistency, maintainability, and operational support across the data platform. Partner with Power BI developers, analysts, business stakeholders, Data Governance, and other technology teams to translate business requirements into trusted, well-structured data solutions and clearly communicate dependencies, risks, and technical trade-offs. Support the modernization and migration of legacy SSIS, SSRS, Azure Data Factory, SQL-based, and other data integration workloads to strategic cloud and Microsoft Fabric platforms. What You Bring: Core Skills:
Technical Expertise: Advanced SQL and T-SQL skills, including complex querying, stored procedures, views, indexing, execution-plan analysis, performance tuning, and query optimization. Strong Python skills for data engineering, automation, testing, API integration, and file processing, with hands-on experience in PySpark and Spark SQL preferred. Hands-on experience with Microsoft Fabric and Azure data services, including Lakehouse, Warehouse, OneLake, Delta tables, pipelines, notebooks, Azure Data Factory, Azure SQL Database/Managed Instance, Azure Data Lake Storage, and Key Vault. Strong understanding of modern data architecture and engineering patterns, including data warehousing, Lakehouse architecture, dimensional modeling, medallion architecture, ETL/ELT, incremental processing, and enterprise data integration. Experience with Git-based source control, branching and pull-request practices, automated testing, CI/CD, and environment-specific configuration and deployment. Experience designing secure data solutions using Microsoft Entra ID, managed identities, service principals, role-based access control, secrets management, and least-privilege principles. Knowledge of data observability and governance practices, including logging, monitoring, alerting, pipeline metrics, reconciliation, metadata, lineage, data quality, retention, reference/master data, and audit requirements. Working knowledge of Power BI and semantic model consumption patterns; experience with DAX is considered an asset. Experience integrating enterprise databases, REST APIs, JSON, CSV, Parquet, Delta, SFTP, and other file-based or application data sources. Experience with PostgreSQL and legacy Microsoft technologies such as SSIS and SSRS is an asset, particularly in modernization and migration initiatives. Ability to develop clean, modular, testable, maintainable, and well-documented production-quality code. Qualifications
We are currently seeking a driven and collaborative Senior Data Engineer to join our forward-thinking Data and Analytics team. SENIOR DATA ENGINEER TORONTO Position Overview: As a Senior Data Engineer on our Data & Analytics Team, you will be a hands-on technical leader responsible for designing, building, operating, and continuously improving scalable, secure, and reliable data solutions. The role will help modernize Trisura’ s data platform, enable trusted analytics and reporting, and establish engineering standards across ingestion, transformation, orchestration, deployment, monitoring, data quality, and documentation. Working closely with Data & Analytics, application teams, architects, analysts, governance, and business stakeholders, the Senior Data Engineer will translate business requirements into reusable data products and production-grade solutions across Microsoft Fabric, Azure, SQL Server, Power BI, and related technologies. What you will do: Design, build, test, deploy, and support scalable batch and near-real-time data pipelines for structured, semi-structured, and unstructured data using Microsoft Fabric, Azure Data Factory, SSIS, SQL Server, Azure SQL, cloud storage, and other enterprise data sources. Develop modern data engineering solutions using Microsoft Fabric capabilities such as Lakehouse, Warehouse, OneLake, Copy Jobs, Notebooks, Dataflow Gen2, and related services, applying layered bronze/silver/gold architecture patterns where appropriate. Develop robust, reusable ETL/ELT and data transformation solutions using T-SQL, Python, PySpark, and Spark SQL, including incremental loading, Change Data Capture (CDC), schema evolution, reconciliation, restart/recovery, idempotency, and error-handling patterns. Design dimensional, relational, and Lakehouse data models that support analytics, operational and regulatory reporting, self-service analytics, and downstream system integrations. Ensure production reliability by implementing monitoring, alerting, logging, data quality controls, reconciliation, metadata, lineage, auditability, and operational support procedures. Optimize SQL, Spark, pipeline, and storage workloads for performance, scalability, reliability, and cost efficiency while applying security and privacy best practices, including least-privilege access, managed identities, service principals, secrets management, secure connectivity, and environment separation. Implement source control, automated deployment, and CI/CD practices using Git, Azure DevOps, and Microsoft Fabric deployment capabilities, and participate in code reviews, testing, release planning, incident resolution, root-cause analysis, and post-implementation reviews. Develop reusable engineering standards, frameworks, templates, patterns, and technical documentation to improve consistency, maintainability, and operational support across the data platform. Partner with Power BI developers, analysts, business stakeholders, Data Governance, and other technology teams to translate business requirements into trusted, well-structured data solutions and clearly communicate dependencies, risks, and technical trade-offs. Support the modernization and migration of legacy SSIS, SSRS, Azure Data Factory, SQL-based, and other data integration workloads to strategic cloud and Microsoft Fabric platforms.
Qualifications Bachelor's degree, college diploma, or equivalent practical experience in Computer Science, Information Systems, Data Engineering, Software Engineering, or a related field. Minimum 5 years of progressive experience in data engineering, data integration, data warehousing, analytics engineering, or related roles, including ownership of production data solutions. Demonstrated experience designing and delivering end-to-end data solutions rather than only developing individual ETL components or reports. Demonstrated experience troubleshooting complex production data issues and improving platform reliability, performance, and maintainability. Experience providing technical leadership, mentoring, code review, solution design, or engineering standards is strongly preferred. Experience in Insurance or another regulated financial-services environment is strongly preferred. Microsoft Fabric, Azure Data Engineer, Azure, Power BI, or related Microsoft certifications are considered an asset. Location:

Your next step

Complete your application on jobs.dayforcehcm.com. The employer’s form will show what is required.

Applying through Dayforce

  • The application asks you to sign in to the employer’s Dayforce candidate portal, or create an account there.

Already applied? Track this application

Job description

View original posting ↗

  We are currently seeking a driven and collaborative Senior Data Engineer to join our forward-thinking Data and Analytics team.   SENIOR DATA ENGINEER   TORONTO   Position Overview: As a Senior Data Engineer on our Data & Analytics Team, you will be a hands-on technical leader responsible for designing, building, operating, and continuously improving scalable, secure, and reliable data solutions. The role will help modernize Trisura’ s data platform, enable trusted analytics and reporting, and establish engineering standards across ingestion, transformation, orchestration, deployment, monitoring, data quality, and documentation.   Working closely with Data & Analytics, application teams, architects, analysts, governance, and business stakeholders, the Senior Data Engineer will translate business requirements into reusable data products and production-grade solutions across Microsoft Fabric, Azure, SQL Server, Power BI, and related technologies.   What you will do: Design, build, test, deploy, and support scalable batch and near-real-time data pipelines for structured, semi-structured, and unstructured data using Microsoft Fabric, Azure Data Factory, SSIS, SQL Server, Azure SQL, cloud storage, and other enterprise data sources. Develop modern data engineering solutions using Microsoft Fabric capabilities such as Lakehouse, Warehouse, OneLake, Copy Jobs, Notebooks, Dataflow Gen2, and related services, applying layered bronze/silver/gold architecture patterns where appropriate. Develop robust, reusable ETL/ELT and data transformation solutions using T-SQL, Python, PySpark, and Spark SQL, including incremental loading, Change Data Capture (CDC), schema evolution, reconciliation, restart/recovery, idempotency, and error-handling patterns. Design dimensional, relational, and Lakehouse data models that support analytics, operational and regulatory reporting, self-service analytics, and downstream system integrations. Ensure production reliability by implementing monitoring, alerting, logging, data quality controls, reconciliation, metadata, lineage, auditability, and operational support procedures. Optimize SQL, Spark, pipeline, and storage workloads for performance, scalability, reliability, and cost efficiency while applying security and privacy best practices, including least-privilege access, managed identities, service principals, secrets management, secure connectivity, and environment separation. Implement source control, automated deployment, and CI/CD practices using Git, Azure DevOps, and Microsoft Fabric deployment capabilities, and participate in code reviews, testing, release planning, incident resolution, root-cause analysis, and post-implementation reviews. Develop reusable engineering standards, frameworks, templates, patterns, and technical documentation to improve consistency, maintainability, and operational support across the data platform. Partner with Power BI developers, analysts, business stakeholders, Data Governance, and other technology teams to translate business requirements into trusted, well-structured data solutions and clearly communicate dependencies, risks, and technical trade-offs. Support the modernization and migration of legacy SSIS, SSRS, Azure Data Factory, SQL-based, and other data integration workloads to strategic cloud and Microsoft Fabric platforms.   What You Bring: Core Skills: Strong ownership, accountability, and a focus on delivering reliable, maintainable data solutions. Ability to lead technical design discussions, mentor other engineers, and promote engineering best practices. Excellent written and verbal communication skills, including the ability to explain complex technical concepts to technical and non-technical audiences. Ability to thrive in a fast-paced environment, manage competing priorities, and independently drive work from requirements through production support. A collaborative and customer-focused mindset when working with business stakeholders, analysts, developers, architects, vendors, and operational teams. Strong analytical and troubleshooting skills with a focus on root-cause analysis, automation, and continuous improvement.       Technical Expertise: Advanced SQL and T-SQL skills, including complex querying, stored procedures, views, indexing, execution-plan analysis, performance tuning, and query optimization. Strong Python skills for data engineering, automation, testing, API integration, and file processing, with hands-on experience in PySpark and Spark SQL preferred. Hands-on experience with Microsoft Fabric and Azure data services, including Lakehouse, Warehouse, OneLake, Delta tables, pipelines, notebooks, Azure Data Factory, Azure SQL Database/Managed Instance, Azure Data Lake Storage, and Key Vault. Strong understanding of modern data architecture and engineering patterns, including data warehousing, Lakehouse architecture, dimensional modeling, medallion architecture, ETL/ELT, incremental processing, and enterprise data integration. Experience with Git-based source control, branching and pull-request practices, automated testing, CI/CD, and environment-specific configuration and deployment. Experience designing secure data solutions using Microsoft Entra ID, managed identities, service principals, role-based access control, secrets management, and least-privilege principles. Knowledge of data observability and governance practices, including logging, monitoring, alerting, pipeline metrics, reconciliation, metadata, lineage, data quality, retention, reference/master data, and audit requirements. Working knowledge of Power BI and semantic model consumption patterns; experience with DAX is considered an asset. Experience integrating enterprise databases, REST APIs, JSON, CSV, Parquet, Delta, SFTP, and other file-based or application data sources. Experience with PostgreSQL and legacy Microsoft technologies such as SSIS and SSRS is an asset, particularly in modernization and migration initiatives. Ability to develop clean, modular, testable, maintainable, and well-documented production-quality code.   Qualifications Bachelor's degree, college diploma, or equivalent practical experience in Computer Science, Information Systems, Data Engineering, Software Engineering, or a related field. Minimum 5 years of progressive experience in data engineering, data integration, data warehousing, analytics engineering, or related roles, including ownership of production data solutions. Demonstrated experience designing and delivering end-to-end data solutions rather than only developing individual ETL components or reports. Demonstrated experience troubleshooting complex production data issues and improving platform reliability, performance, and maintainability. Experience providing technical leadership, mentoring, code review, solution design, or engineering standards is strongly preferred. Experience in Insurance or another regulated financial-services environment is strongly preferred. Microsoft Fabric, Azure Data Engineer, Azure, Power BI, or related Microsoft certifications are considered an asset.   Location: Downtown Toronto – Hybrid   Salary: The maximum potential base salary for this position is $125,000   This salary range reflects the expected base compensation for the role across Canada. Actual compensation will be determined based on factors such as experience, qualifications, and scope of responsibilities. Trisura provides this range in good faith in accordance with applicable legislation.   This position is for an existing, currently vacant position.   #LI-HYBRID    

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 845, the most 1,344, and the latest week had 1,007.
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 Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

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 data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

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
Salary: The maximum potential base salary for this position is $125,000 This salary range reflects the expected base compensation for the role across Canada. Actual compensation will be determined based on factors such as experience, qualifications, and scope of responsibilities. Trisura provides this range in good faith in accordance with applicable legislation. This position is for an existing, currently vacant position. #LI-HYBRID
Location & working pattern

Toronto, ON, Canada

Location: Downtown Toronto – Hybrid Salary:
More source context
The maximum potential base salary for this position is $125,000 This salary range reflects the expected base compensation for the role across Canada. Actual compensation will be determined based on factors such as experience, qualifications, and scope of responsibilities. Trisura provides this range in good faith in accordance with applicable legislation. This position is for an existing, currently vacant position. #LI-HYBRID
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.