ETL Data Engineer Associate

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

Select how often (in days) to receive an alert:

Requisition ID: 247885

Join a purpose driven winning team, committed to results, in an inclusive and high‑performing culture.

At the heart of the Bank’s mission to uphold integrity and transparency, the Global Compliance Technology team builds and supports cutting‑edge data and reporting solutions that drive compliance, risk management, and procurement excellence. We’re a collaborative group of developers and architects working across on‑prem and cloud platforms to deliver secure, scalable, and insightful data products.

We’re looking for a passionate ETL Developer Associate who thrives on solving data challenges and building reliable pipelines that fuel decision‑making. If you’re excited by the idea of working with modern data platforms and contributing to meaningful initiatives, this is your opportunity to grow and make a difference.

In this role you will:

• Design and implement data ingestion pipelines across SQL Server, Databricks on Azure or Google Cloud Platform (GCP).
• Build robust ETL solutions using T‑SQL, SSIS, and other modern tools to integrate data into our central warehouse.
• Collaborate on end‑to‑end data initiatives—from development and testing to deployment and support.
• Ensure smooth handoffs to operations teams and maintain high‑quality, production‑ready data processes.
• Create SQL views and data interfaces that empower users to access and analyze data seamlessly.
• Integrate systems using REST APIs, SharePoint, sFTP scripting with python, and more.
• Document data flows, maintain data dictionaries, and support data governance efforts.
• Troubleshoot and resolve issues quickly, working with internal and external stakeholders.
• Coordinate code deployments and production rollouts.
• Explore and apply AI‑powered development tools to boost productivity.
• Support and train users across the organization to maximize data value.

Do you have the skills that will enable you to succeed in this role?

• Hands‑on experience with the Microsoft Data Platform stack: SQL Server, T‑SQL, SSIS, Power BI.
• Development experience in .NET (C#), Python, DevOps, Jira, Bitbucket
• Experience with Databricks on Azure or GCP, GCP BigQuery, Terraform, Composer / Airflow, Cloud SQL, Vertex AI, Looker, or Azure a plus.
• Comfort working in both Windows and Linux environments.
• Experience with data warehouse design and system integration.
• Ability to consume and work with REST APIs.
• Exposure to AI‑assisted coding tools and Git/GitHub Enterprise a plus
• Experience with Power Platform / Power Automate for automating workflows a plus

What’s in it for you?

• Diversity, Equity, Inclusion & Allyship – We strive to create an inclusive culture where every employee is empowered to reach their fullest potential, respected for who they are, and are embraced through bias‑free practices and inclusive values across Scotiabank. We embrace diversity and provide opportunities for all employees to learn, grow & participate through our various Employee Resource Groups (ERGs) that span across diverse gender identities, ethnicity, race, age, ability & veterans.
• Accessibility and Workplace Accommodations – We value the unique skills and experiences each individual brings to the Bank and are committed to creating and maintaining an inclusive and accessible environment for everyone. Scotiabank continues to locate, remove, and prevent barriers so that we can build a diverse and inclusive environment while meeting accessibility requirements.
• Upskilling through online courses, cross‑functional development opportunities, and tuition assistance.
• Competitive Rewards program including bonus, flexible vacation, personal, sick days, and benefits will start on day one.
• Community Engagement – no matter where you choose to work from; we offer opportunities for community engagement & belonging with our various programs such as hackathons, contests, cooking with friends, Humans of Digital and much more!

Location(s): Canada : Ontario : Toronto

Scotiabank is a leading bank in the Americas. Guided by our purpose: "for every future", we help our customers, their families and their communities achieve success through a broad range of advice, products and services, including personal and commercial banking, wealth management and private banking, corporate and investment banking, and capital markets.

At Scotiabank, we value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. If you require accommodation (including, but not limited to, an accessible interview site, alternate format documents, ASL Interpreter, or Assistive Technology) during the recruitment and selection process, please let our Recruitment team know. If you require technical assistance, please click here. Candidates must apply directly online to be considered for this role. We thank all applicants for their interest in a career at Scotiabank; however, only those candidates who are selected for an interview will be contacted.