Skip to content

Open nowPosted 9 days ago

Senior Data Engineer - Toronto

trisura19 open roles

Where
Toronto, ON, Canada
Get the CV for this job

From $25 per CV, paid once. No subscription.

Your applicationOpen nowSenior Data Engineer - Torontotrisura · Toronto, ON, Canada
  1. YouYes, apply to this one.

  2. CV RocketCV written for this posting.

  3. 25 readersRecruiter, hiring manager, skeptic. Round after round.

  4. CV RocketApplied on trisura's own form.

The reply lands in your private mailbox

3×more interviews than doing it yourself with ChatGPT.

The clock on this job

Early applications get read.

7.8% of postings close within 7 days. Measured by our own scanner across the market.

Share of postings closed within
  1. 1.7%1 day
  2. 3.5%3 days
  3. 7.8%7 days
  4. 14.6%14 days
  5. 34.1%30 days
This job: posted 9 days ago

The 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    

From $25, paid onceGet the CV for this job

What happens when you press

One press. We do the rest.

  1. A CV for this posting

    Written against trisura's own wording, from every piece of relevant proof in your profile.

  2. 25 readers review it

    Recruiter, hiring manager, skeptic and more read every draft, round after round. You get the best round.

    The review screen in CV Rocket: how each CV was read, round by round.
  3. We apply on trisura's form

    Our application engine gets through the hardest forms there are. Where a question needs you, AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

    An application in CV Rocket: every answer filled in on the employer's form.
  4. Every reply, sorted

    trisura's answer lands in your private mailbox, and we classify it on arrival: interview, question, rejection.

    The CV Rocket inbox: each employer reply classified as an interview, an action or a rejection.
  5. Reply with AI

    AI helps you write the email, checks it and sends it. We show you whether the recruiter read it.

  6. The interview in your calendar

    Full integration with your calendar. The invitation goes straight in.

    An interview invitation in the CV Rocket inbox, added to the candidate's calendar.
Get the CV for this job

From $25 per CV, paid once. No subscription.

Why it works

3×

more interviews than doing it yourself with ChatGPT.

ChatGPT writes a CV and never learns what happened to it. We see every reply. For each CV we know:

  • How it was written, and how the review scored it
  • When we applied, and how long after the posting went up
  • Which posting, which company, which city
  • Who got the interview, and who heard nothing

That is how we know which CVs get called.

Get the CV for this job

From $25 per CV, paid once. No subscription.

The numbers game

More applications. More interviews.

Every application goes out with its own CV, written for that posting and paid once. Send enough of them and the law of large numbers finds you the job.

By hand5–10
With CV Rocket100
applications a day

Nearby

Live postings like this one

Same employer first, then the same role elsewhere.

Before you press

Straight answers

Get the CV for this job

From $25 per CV, paid once. No subscription.

What if my background isn't good enough?

We make the most of the background you have. The CV uses every piece of relevant proof your profile holds, and one of the 25 readers reads your whole profile and flags what the CV left out.

Do you really apply for me?

Yes, on the employer's own form, the hardest ones included. Where a question needs you, you answer it right there and AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

Is it a subscription?

No. You pay once per CV, from $25. Every application goes out with its own CV, written for that posting.

One job. One CV.
Paid once.

Pick the posting you want. We write for it, apply for you and catch the reply.

Get the CV for this job

From $25 per CV, paid once. No subscription.