Senior Data Engineer - Toronto
at
Trisura Guarantee Insurance Company
Ontario, Ontario, Canada
-
Full Time
Start Date
Immediate
Expiry Date
29 Dec, 26
Salary
45000.0
Posted On
30 Sep, 26
Experience
2 year(s) or above
Remote Job
Yes
Telecommute
Yes
Sponsor Visa
Yes
Skills
Industry
Consumer Services
Description
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.
Responsibilities
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.