Find work in Canada.

520,840 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 2 mins ago
T
Senior IT Developer
TD
Toronto, ON
- Full-time
Skilled in PL/SQL, T-SQL, Unix, and batch scripting.
Added 2 mins ago
T
Software Engineer II (Java/Spring)
TD
Toronto, ON
- Full-time
5+ years' experience with databases such as SQL (PostgreSQL, MySQL) and/or NoSQL (MongoDB, Cosmos DB)
Added 2 mins ago
T
Data Engineer Intern/Co-op (Winter 2027)
TD
Toronto, ON
- Full-time
Familiarity with at least one of the following technologies: Java, Scala, Python, Pyspark, or SQL
Added 17 mins ago
PS
Advisor, Data Analytics Enablement
Public Sector Pension Investment Board
Montreal, QC
- Full-time
Technical fluency, with programming skills in Python, SQL, and/or Databricks, with hands-on experience in cloud data platforms such as Snowflake
Added 17 mins ago
Manager, Analytics
Scotiabank
Toronto, ON
Added 32 mins ago
S
Systems Analyst, Clinical Solutions, IMITS
Sanya’k̓ula
Vancouver, BC
- Full-time
…standards and using tools such as Visual Studio, Powerhouse, Oracle Developer, PowerBuilder, and Crystal Reports and other query tools as well as MS office applications (Word, Excel, Visio,…
Added 32 mins ago
IE
Analyst, Business
IMAX Enhanced | Streaming & Consumer Technology
Mississauga, ON
- Full-time
Added 32 mins ago
I
Software Developer - Senior
isgSearch
Toronto, ON · Greater Toronto Area, Canada
- Contract
We are seeking an experienced Software Developer to design, develop, test, and maintain enterprise applications using Microsoft .NET technologies, SQL Server, and Microsoft Azure.
Added 32 mins ago
FG
Software Developer | Banking & Capital Markets
FDM Group
Toronto, ON
- Contract
FDM is seeking a Experienced Software Developer located in Toronto to support a project in the Banking & Capital Markets sector. Involvement in this project is anticipated to last initially…
Added 47 mins ago
B
Senior Analyst, Data Analytics & Automation Solutions
BMO
Toronto, ON · FCP
- Full-time
Added 47 mins ago
RU
Senior Data Engineer
RSM US LLP
Calgary, AB · Toronto, ON
- Full-time
Added 47 mins ago
AI
Java Developer
Apptoza Inc.
Mississauga, ON
- Full-time
Develop and optimize SQL queries (E2 level) for transactional and reporting use cases
Added 47 mins ago
B
Software Developer - Senior-.NET
Bevertec
Toronto, ON
- Contract
Hands-on experience with Microsoft Azure services (e.g., App Services, Azure SQL, Azure Storage, Azure DevOps).
Added 47 mins ago
AC
Software Engineer
Amaris Consulting | Part of Mantu
Markham, ON
- Full-time
Amaris Consulting is looking for a Software Engineer with strong SQL and C# expertise to join a product engineering team working on data-intensive .NET web applications.
Added 47 mins ago
SI
Senior AI Engineer
Siri InfoSolutions, Inc.
Mississauga, ON
- $110,000 to $120,000 CAD / year
- Full-time
Solid SQL, data modeling, and data engineering fundamentals.
Added 47 mins ago
XE
Senior Technical Support Specialist
XR Extreme Reach
Toronto, ON
- Full-time
Build and maintain scripts, utilities, or lightweight tools using JavaScript, Bash, SQL, or similar technologies.
Added 1 hour ago
TB
Baseball Research Specialist
Toronto Blue Jays
Toronto, ON
- Full-time
Proficiency with SQL and relational databases
Added 1 hour ago
TB
Data Scientist, Baseball Research
Toronto Blue Jays
Toronto, ON
- Full-time
Proficiency with SQL, R, Python, relational database and/or similar statistical language
Added 1 hour ago
T
Senior Analyst, Reporting - Model Management and Analytics (5600)
TD
Toronto, ON
- Full-time
Strong working knowledge with preferably three or more years of hands-on experience using SAS, SQL or Python.
Added 1 hour ago
C
Business Intelligence Architect/Data Modeler
Cencora
Oakville, ON · ON · CAN > ON > Oakville > Superior Crt
- Full-time
Build, enhance, and support modern data transformation and reporting solutions using Databricks, SQL, and enterprise BI tools.
Added 1 hour ago
SL
Senior Data Scientist
Sun Life
Toronto, ON · Waterloo, ON · Sun Life Toronto One York
- Full-time
Experience with writing complex SQL and PySpark queries to extract and integrate data from multiple database sources
Added 1 hour ago
SL
Senior Data Engineer
Sun Life
Toronto, ON · Waterloo, ON · Sun Life Toronto One York
- Full-time
Support the initial development of analytical data models, including SQL/HQL/Python/Spark/Scala code and data processes.
Added 1 hour ago
C
Consultant, Digital Operations & Privacy
CIBC
Toronto, ON
- Full-time
…information in an impactful way. Must have experience using SQL, Azure Dev Ops, Quality Assurance, and advanced Microsoft Excel…
Added 1 hour ago
GS
PL/SQL Developer
Gala Solutions
Montreal, QC
- Contract
We are seeking an experienced PL/SQL developer with strong Unix/Linux and DB2 database skills to join our team. The ideal candidate will be responsible for designing, developing,…
Added 1 hour ago
TC
Full Stack Engineer
Triton Canada
Toronto, ON · Greater Toronto Area, Canada
- Full-time
We are seeking a highly capable Full Stack Application Developer (Mid–Senior Level) to join our technology team and contribute to the delivery of high-quality, secure, scalable, and…

AceStack

ETL Lead Developer : Toronto, ON : FTE

Toronto, ON, Canada

Full-time

Apply About employer

Applications open in a new tab.

Job details

Job type: Full-time
Apply by: Nov 27, 2026
Experience: Experience: 10+ Years
Posting language: English
Posted: Oct 28, 2026

Original job description

Job Description – ETL Lead Developer

Location: Toronto, ON

Work Mode: Onsite

Experience: 10+ Years

Role Overview

We are seeking an experienced ETL Lead Developer with 10+ years of IT experience and strong expertise in data warehousing, ETL development, and database technologies. The ideal candidate will have hands-on experience developing and maintaining Microsoft SSIS packages, managing end-to-end data warehouse solutions, and working within the banking and financial services domain.

The candidate will be responsible for leading ETL development activities, translating business requirements into technical solutions, ensuring data quality and performance, and mentoring development teams.

Key Responsibilities

•

Design, develop, enhance, and maintain ETL processes and data warehouse solutions.

•

Develop and manage ETL packages using Microsoft SQL Server Integration Services (SSIS).

•

Work with Microsoft SQL Server, Sybase, IBM Netezza, and AWS Redshift databases for data extraction, transformation, loading, and reporting.

•

Analyze business and technical requirements and translate them into scalable data integration solutions.

•

Lead and coordinate ETL development activities, review code, troubleshoot issues, and mentor team members.

•

Manage end-to-end data warehouse processes, including data ingestion, transformation, reconciliation, and data quality validation.

•

Optimize ETL workflows, SQL queries, and database performance to ensure reliable and efficient processing.

•

Collaborate with business analysts, architects, QA teams, and other stakeholders to deliver data solutions aligned with business needs.

•

Support data integration and processing requirements across banking and financial services applications.

Must-Have Skills and Experience

ETL and Data Warehousing: 10+ years of overall IT experience, with strong hands-on expertise in ETL development, enterprise data warehousing, and end-to-end data integration processes.

Microsoft SSIS/SSRS: Strong experience developing, maintaining, and troubleshooting SSIS packages, with knowledge of SSRS for reporting and data delivery.

Database Technologies: Hands-on experience with Microsoft SQL Server and exposure to IBM Netezza and/or Sybase databases, including SQL development, query optimization, and performance tuning.

Banking and Financial Services Domain: Strong understanding of banking data, financial services processes, and data warehouse requirements in a banking environment.

Technical Leadership and Delivery: Proven ability to lead ETL development teams, mentor developers, understand business requirements, resolve technical issues, and manage end-to-end data warehouse delivery.

Nice-to-Have Skills

•

AWS Data Services: Experience with AWS Glue, Amazon Redshift, EMR, Spark, and other AWS cloud data services.

•

Lending Systems: Functional knowledge of retail or commercial lending systems and associated data processing workflows.

•

Master Data Management (MDM): Experience with MDM solutions, particularly customer demographic data processing and integration.

•

Core Banking and Deposit Systems: Knowledge of retail and commercial deposit processing and core banking systems, preferably within the Canadian banking domain.

•

Advanced Cloud ETL and Data Integration: Experience designing cloud-based ETL solutions, including Kafka-based message processing, batch data ingestion, and business-layer data integration.

Ideal Candidate Profile

•

Strong hands-on technical expertise combined with team leadership capabilities.

•

Excellent analytical, problem-solving, and troubleshooting skills.

•

Ability to communicate effectively with technical teams and business stakeholders.

•

Experience delivering reliable, scalable, and high-quality data warehouse solutions in complex enterprise environments.

•

Comfortable working onsite in Toronto, Ontario.

Apply About employer

More about this job

Responsibilities

Lead the design, development, maintenance, and optimization of ETL processes and end-to-end data warehouse solutions using SSIS and multiple database platforms. Coordinate and mentor ETL developers, translate business requirements into scalable data solutions, and ensure data quality, reconciliation, and reliable delivery for banking and financial services applications.

Requirements

Requires 10+ years of IT experience with strong hands-on expertise in ETL development, enterprise data warehousing, SSIS, and SQL Server, plus exposure to Sybase and/or IBM Netezza. Candidates should understand banking and financial services data and have proven technical leadership, team mentoring, troubleshooting, and end-to-end delivery capabilities.

Skills

ETL Development
Data Warehousing
Microsoft SSIS
Microsoft SSRS
Microsoft SQL Server
Sybase
IBM Netezza
Amazon Redshift
SQL Development
Query Optimization
Performance Tuning
Data Integration
Data Quality
Technical Leadership
Banking and Financial Services
AWS Glue

Visa sponsorship

Not detected in the job text

Keywords

ETL
Data Warehousing
Microsoft SSIS
Microsoft SSRS
Microsoft SQL Server
Sybase
IBM Netezza
Amazon Redshift
AWS Glue
Amazon EMR
Spark
Kafka
SQL
Data Integration
Data Ingestion
Data Transformation
Data Reconciliation
Data Quality
Query Optimization
Performance Tuning
Banking
Financial Services
Lending Systems
Core Banking
Deposit Processing
Master Data Management
Customer Demographic Data
Cloud ETL
Batch Processing
Technical Leadership

Report this job