ETL Developer Associate

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

Job summary

A leading financial institution in Canada is seeking an ETL Developer Associate to design and implement data ingestion pipelines. The ideal candidate will work with SQL Server and Google Cloud Platform, building ETL solutions to support data integration. This collaborative role involves engaging in high-impact projects that enhance decision-making through data management and governance.

Benefits

Work on high-impact projects

Collaborate with a forward-thinking team

Gain exposure to modern cloud technologies

Qualifications

• Experience with AI-assisted coding tools and Git/GitHub Enterprise a plus.
• Experience with Power Platform / Power Automate for automating workflows a plus.

Responsibilities

• Design and implement data ingestion pipelines across SQL Server and Google Cloud Platform.
• Build robust ETL solutions using T-SQL, SSIS, and other tools.
• Ensure smooth handoffs to operations teams and maintain high-quality data processes.
• Document data flows and maintain data dictionaries.

Skills

Hands-on experience with Microsoft Data Platform stack

Experience with GCP

Comfort working in Windows and Linux environments

Experience with data warehouse design

Ability to work with REST APIs

Exposure to AI-assisted coding tools

Tools

SQL Server

T-SQL

SSIS

Power BI

Terraform

BigQuery

Job description

Requisition ID: 234295

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

Join a Team That Powers Trust Through Data

At the heart of the Bank’s mission to uphold integrity and transparency, theGlobal Compliance Technologyteam 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.

Your Impact Starts Here

We’re looking for apassionate ETL Developer Associatewho 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.

What You’ll Do

In this role, you’ll be hands-on with data engineering tasks that bring clarity and structure to complex data ecosystems:

• Design and implement data ingestion pipelines acrossSQL ServerandGoogle Cloud Platform (GCP).
• Build robust ETL solutions usingT-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 usingREST 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 applyAI-powered development toolsto boost productivity.
• Support and train users across the organization to maximize data value.

What You Bring

We’re excited to meet candidates who bring a mix of technical expertise, curiosity, and a drive to innovate. You’ll thrive in this role if you have:

• Hands-on experience with theMicrosoft Data Platform stack: SQL Server, T-SQL, SSIS, Power BI.
• Experience withGCP,BigQuery,Terraform,Composer / Airflow, Cloud SQL,Vertex AI,Looker, orAzure a plus.
• Comfort working in bothWindowsandLinuxenvironments.
• Experience with data warehouse design and system integration.
• Ability to consume and work withREST APIs.
• Exposure toAI-assisted coding toolsand Git/GitHub Enterprise a plus
• Experience with Power Platform / Power Automate for automating workflows a plus

Why Join Us?

• Work on high-impact projects that support global compliance and risk management.
• Collaborate with a forward-thinking team that values innovation and continuous learning.
• Gain exposure to modern cloud technologies and AI tools.
• Be part of a culture that supports growth, inclusion, and excellence

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, pleaseclick 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.

Please make sure your Bio is at least 60%.

You are 4 times more likely to be shortlisted
with a completed bio.

Your application for ETL Developer Associate has been submitted!

Continue your search to find other jobs.