ETL Data Engineer Associate — Modern Pipelines & AI Tools

Scotiabank; Toronto; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading financial institution in Toronto is seeking a passionate ETL Developer Associate to design and implement data pipelines. You'll build robust ETL solutions and troubleshoot issues while collaborating with teams across cloud platforms. The ideal candidate should have hands-on experience with SQL Server, .NET (C#), and Python, alongside a solid understanding of data warehouse design. This role offers a comprehensive rewards program including flexible vacation and personal benefits.

Benefits

Diversity, Equity, Inclusion & Allyship initiatives

Accessibility and Workplace Accommodations

Upskilling opportunities

Competitive Rewards program

Qualifications

• Hands-on experience with the Microsoft Data Platform stack.
• Development experience in .NET (C#) and Python.
• Comfortable in both Windows and Linux environments.

Responsibilities

• Design and implement data ingestion pipelines.
• Build robust ETL solutions using T-SQL and SSIS.
• Document data flows and maintain data dictionaries.

Skills

Hands-on experience with SQL Server

Experience in .NET (C#)

Proficiency in Python

Familiarity with Power BI

Comfort with REST APIs

Tools

Databricks on Azure

GCP BigQuery

Terraform

Power Platform

Job description

A leading financial institution in Toronto is seeking a passionate ETL Developer Associate to design and implement data pipelines. You'll build robust ETL solutions and troubleshoot issues while collaborating with teams across cloud platforms. The ideal candidate should have hands-on experience with SQL Server, .NET (C#), and Python, alongside a solid understanding of data warehouse design. This role offers a comprehensive rewards program including flexible vacation and personal benefits.