21 Oct
|
Trisura
|
Toronto
Senior Data Engineer – Toronto
This Full time on site position offers great opportunities for career growth. Posted Wednesday, September 23, 2026 at 11:00 PM At Trisura, we expect more because we believe it can be done better. We are a young, growth oriented team with a commitment to exceptional talent and have been named one of Canada’s Top Small and Medium Employers since 2017. Our growth and our entrepreneurial style, niche market position and development opportunities ensure that our people see the results of their commitment reflected in the company’s success. We are currently seeking a driven and collaborative Senior Data Engineer to join our forward-thinking Data and Analytics team.
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 team-oriented 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 com
📌 Senior Data Engineer (Toronto)
🏢 Trisura
📍 Toronto