Find work in Canada.

357,474 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 23 mins ago
C
Senior SAP/BDC BW Consultant
CGI
Toronto, ON
- Full-time
The Senior BW Consultant will lead SAP BW strategy, architecture, implementation, and transformation initiatives for clients, ensuring business requirements are delivered efficiently and…
Added 23 mins ago
LM
Senior Accountant
LifeSavvy Media
Montreal, QC
- Full-time
Added 23 mins ago
AI
Enterprise Account Executive
Avant Imaging & Information Management, Inc.
Toronto, ON · Scarborough, ON
- Full-time
…who can identify opportunities, open new accounts, develop senior-level relationships and turn initial projects into long-term client…
Added 23 mins ago
C
Lead Full Stack Developer, Vice President
Citi
Mississauga, ON
- Full-time
The Lead Full Stack Developer will join Client Technology - a business-focused engineering division within Services Markets Banking (SMB) - where you will design and deliver…
Added 23 mins ago
H
Senior Project Manager, Power Generation
HDR
Calgary, AB
- Full-time
As a Senior Project Manager, you will be joining a highly capable, multi-discipline global team that supports power and energy projects within the industrial, IPP, developer, and utility…
Added 23 mins ago
ES
Senior ServiceNow Architect
EPAM Systems
Canada
- Full-time
ServiceNow Certified Master Architect (CMA) or Certified Application Developer (CAD)
Added 23 mins ago
SM
RQ11619 – Business Analyst – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking an experienced Senior Business Analyst with strong expertise in business requirements gathering, business process reengineering, Agile methodologies, business modelling,…
Added 23 mins ago
SM
RQ11612 – Business Analyst – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking an experienced Senior Business Analyst with strong expertise in business requirements gathering, business process reengineering, Agile methodologies, business modelling,…
Added 23 mins ago
SM
RQ11611 – Business Analyst – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking a highly experienced Senior Business Analyst with extensive expertise in business requirements gathering, business process reengineering, Agile methodologies, user story…
Added 23 mins ago
TK
Senior Packaging Development Specialist
The Kersheh Group
Montreal, QC
- Full-time
As the Senior Packaging Development Specialist, you will collaborate with the design and production departments, and liaise with marketing consultants, while being responsible for designing…
Added 23 mins ago
SM
RQ11611 – Business Analyst – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking a highly experienced Senior Business Analyst with extensive expertise in business requirements gathering, business process reengineering, Agile methodologies, user story…
Added 23 mins ago
B&
Program Manager
Black & Veatch
Markham, ON
- $159,504 to $265,843 CAD / year
- Full-time
Interacts with senior government or public officials and/or executive level clients on significant project matters.
Added 23 mins ago
SM
RQ11611 – Business Analyst – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking a highly experienced Senior Business Analyst with extensive expertise in business requirements gathering, business process reengineering, Agile methodologies, user story…
Added 23 mins ago
SM
RQ11619 – Business Analyst – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking an experienced Senior Business Analyst with strong expertise in business requirements gathering, business process reengineering, Agile methodologies, business modelling,…
Added 23 mins ago
SM
RQ11619 – Business Analyst – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking an experienced Senior Business Analyst with strong expertise in business requirements gathering, business process reengineering, Agile methodologies, business modelling,…
Added 23 mins ago
SM
RQ11612 – Business Analyst – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking an experienced Senior Business Analyst with strong expertise in business requirements gathering, business process reengineering, Agile methodologies, business modelling,…
Added 23 mins ago
SM
RQ11518 – Business Analyst – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking an experienced Senior Business Analyst with strong expertise in business requirements gathering, business process reengineering, Agile methodologies, business modelling,…
Added 23 mins ago
SM
RQ11612 – Business Analyst – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking an experienced Senior Business Analyst with strong expertise in business requirements gathering, business process reengineering, Agile methodologies, business modelling,…
Added 23 mins ago
SM
RQ11714 – Business Analyst – Senior
S M Software Solutions Inc
Toronto, ON
- Full-time
We are seeking a Senior Business Analyst / Procurement Writer with strong writing, communication, public-sector procurement, and project coordination skills. The successful candidate will…
Added 23 mins ago
SM
RQ11714 – Business Analyst – Senior
S M Software Solutions Inc
Toronto, ON
- Full-time
We are seeking a Senior Business Analyst / Procurement Writer with strong writing, communication, public-sector procurement, and project coordination skills. The successful candidate will…
Added 23 mins ago
SM
RQ11714 – Business Analyst – Senior
S M Software Solutions Inc
Toronto, ON
- Full-time
We are seeking a Senior Business Analyst / Procurement Writer with strong writing, communication, public-sector procurement, and project coordination skills. The successful candidate will…
Added 23 mins ago
SM
RQ11693 – Privacy Impact Assessment (PIA) Specialist – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
Added 23 mins ago
SM
RQ11518 – Business Analyst – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking an experienced Senior Business Analyst with strong expertise in business requirements gathering, business process reengineering, Agile methodologies, business modelling,…
Added 23 mins ago
SL
Python Developer
Staffingine LLC
Toronto, ON
- Full-time
Python Backend Engineer/Senior Software Engineer
Added 23 mins ago
SM
RQ11517 – Privacy Impact Assessment (PIA) Specialist – Senior
S M Software Solutions Inc
Toronto, ON
- Internship

S M Software Solutions Inc

RQ11713 – Software Developer – ETL – Senior

Toronto, ON, Canada

Internship

Apply About employer

Applications open in a new tab.

Job details

Job type: Internship
Apply by: Nov 10, 2026
Posting language: English
Posted: Oct 11, 2026

Original job description

Client: Ministry of Treasury Board Secretariat - RQ11713

We are seeking a Senior Software Developer – ETL with extensive experience in Microsoft Azure data technologies, Amazon Web Services (AWS), ETL development, data integration, data warehousing, database administration, SQL performance tuning, and business intelligence solutions. The successful candidate will design, develop, and maintain scalable data pipelines, implement data extraction, transformation, and loading processes, optimize database performance, develop technical documentation, and support enterprise data warehouse and business intelligence initiatives.

Role Snapshot

Job Title: RQ11713 – Software Developer – ETL – Senior
Client: Ministry of Treasury Board Secretariat
Work Location: 222 Jarvis Street, Toronto, Ontario, Canada
Work Arrangement: Onsite – 5 Days per Week
Estimated Start Date: January 5, 2027
Estimated End Date: October 5, 2027
Business Days: 188.00
Extension: 120.00 days
Hours: 7.25 hours per day
Security Level: CRJMC

Must Have

Experience with the Microsoft suite of technologies, including:

Azure Data Factory
Azure SQL Database
Azure Data Lake
Power BI

Experience with the Databricks Platform.
Experience with the Amazon Web Services (AWS) suite of technologies, including Amazon Aurora, Amazon Relational Database Service (RDS), AWS Glue, OpenSearch, etc.
Experience developing data extraction, transformation, and load (ETL) programs, including daily and initial load functionality, across a wide range of data repositories, such as structured and semi-structured files, relational databases, and multidimensional data stores.
Experience developing, implementing, and maintaining scheduling and dependency logic for Extract, Transform, and Load (ETL) scripts.
Experience with data integration, data cleansing, and data analytics.
Experience with data modelling and design principles for data marts and data warehouses.
Experience in database management and administration.
Experience constructing complex SQL queries and performing database performance tuning.
Experience with Git and knowledge of source control strategies.
Experience creating technical documentation, including ETL source-to-target mappings, data model diagrams, architecture artifacts, detailed design documents, etc.
Experience eliciting, documenting, and validating business requirements.
Experience in the software development lifecycle, from development through testing, quality assurance, and delivery.
Solid communication skills, including the ability to understand, comprehend, and follow instructions and requirements, and communicate clearly and effectively both verbally and in writing.

Nice to Have

Knowledge and understanding of the Accessibility for Ontarians with Disabilities Act (AODA) and related regulations and standards.
Experience designing visual dashboards to highlight trends and Key Performance Indicators (KPIs), and developing scheduled and ad-hoc reports.
Experience with programming languages such as C#, including developing application code such as APIs and functions.
Experience writing scripts using PowerShell and other scripting languages.

Description

Assignment Deliverables

Designs, develops, and maintains database backend and ETL applications for data warehouse and business intelligence solutions. Uses knowledge of ETL languages and development techniques to build and expand application functionality by writing high-quality code using appropriate patterns. Ensures applications remain scalable while complying with standards and following best practices.
Tests and debugs applications and ensures that software is properly documented.
Collaborates clearly and professionally as part of a development team and communicates with clients.

Responsibilities

Design, implement, and expand data pipelines by performing extraction, transformation, and loading (ETL) activities.
Translate technical system specifications into functional and tested applications.
Develop detailed programming specifications, write or generate code, compile data-driven programs, maintain applications, and conduct unit testing.
Troubleshoot and resolve technical issues arising during software package usage and operations.
Provide technical assistance for software implementation, data conversion, and migration activities.

General Skills

Demonstrate experience in programming, analysis, and specialized software package support.
Collaborate with IT professionals throughout the Software Development Life Cycle (SDLC).
Apply structured methodologies for application development, design, implementation, and maintenance.
Design, code, test, debug, and document applications.
Utilize object-oriented and third-generation programming tools.
Demonstrate proficiency in one or more programming languages.
Apply application design principles, modern design patterns, deployment practices, and troubleshooting techniques.
Work with relational and hierarchical database technologies.
Use information retrieval tools and query languages.
Demonstrate knowledge of communication protocols.
Gather and document requirements from diverse business stakeholders and subject matter experts.
Apply strong analytical, problem-solving, and decision-making skills.
Demonstrate effective verbal and written communication, interpersonal, and negotiation skills.
Collaborate effectively within teams and consistently meet project deadlines.

ETL Skills

Gather requirements and understand business processes to transform data according to end-user needs.
Maintain, optimize, and improve existing ETL processes.
Design scalable, maintainable, and efficient data architectures.
Collaborate with business stakeholders to design and deliver accurate, high-quality data solutions.
Investigate data to identify issues within ETL pipelines, notify end users, and recommend appropriate solutions.
Prepare detailed technical documentation for future reference and maintenance.

Desirable Skills

Develop and maintain Internet-ready applications.
Apply Rapid Application Development (RAD) methodologies.
Understand Information Management principles, concepts, policies, and practices.
Work with middleware technologies and gateways.
Review, analyse, and modify product installation scripts, including encoding, testing, and debugging.
Provide post-implementation support and resolve technical issues.
Conduct design walkthrough sessions with project teams.
Understand the Accessibility for Ontarians with Disabilities Act (AODA) and related regulations and standards.
Prepare user and system documentation as required.

Experience And Skill Set Requirements

Core Technical Skills - 50%

Experience with Microsoft technologies, including Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BI.
Experience with Amazon Web Services (AWS), including Amazon Aurora, Amazon Relational Database Service (RDS), AWS Glue, and OpenSearch.
Develop data extraction, transformation, and loading (ETL) programs for daily and initial data loads across structured and semi-structured files, relational databases, and multidimensional data stores.
Develop, implement, and maintain scheduling and dependency logic for ETL scripts.
Perform data integration, data cleansing, and data analytics.
Apply data modelling and design principles for data marts and data warehouses.
Perform database management and administration.
Construct complex SQL queries and perform database performance tuning.
Create technical documentation, including ETL source-to-target mappings, data model diagrams, architecture artifacts, and detailed design documents.

Other Technical Skills - 35%

Design visual dashboards to highlight trends and Key Performance Indicators (KPIs).
Develop scheduled and ad-hoc reports.
Work with programming languages such as C# to develop application code, including APIs and functions.
Write scripts using PowerShell and other scripting languages.
Use Git and apply source control strategies.
Participate in the Software Development Life Cycle (SDLC), including development, testing, quality assurance, and delivery.

Communications Skills - 10%

Elicit, document, and validate business requirements.
Demonstrate strong communication skills and the ability to understand, interpret, and follow instructions and requirements.
Communicate clearly and effectively through verbal and written communication.

Standards and Best Practices - 5%

Understand the Accessibility for Ontarians with Disabilities Act (AODA) and related regulations and standards.

How to Apply

If you are interested and your profile matches the requirements, kindly send the following mandatory documents to hrsmss@smsoftconsulting.com by Wednesday, October 14, 2026, at 10:00 AM EST.

Mandatory Documents

Updated Resume in Word format – Mandatory
References – Mandatory
Expected Hourly Rate – Mandatory
Visa Status – Mandatory
LinkedIn ID – Mandatory

Without the mandatory documents, we cannot submit a candidate.

WhatsApp Group

For daily job updates, you can also join our WhatsApp group using the link below:

Join Our WhatsApp Group

https://chat.whatsapp.com/KCmWoqPlxWvAZmyXLcd8or

Note

Onsite Work Requirement: The successful candidate is expected to work onsite five days per week, for 7.25 hours per calendar day, between the standard working hours of 8:00 AM to 5:00 PM (excluding lunch breaks), Monday to Friday inclusive, at the identified OPS office location.

Work Arrangement: 5 days onsite.

Email is the best way to reach us.

You have received this message either as a result of contacting our company to express interest in employment or as a result of posting your resume in a location that can be accessed by recruiters or HR specialists, which suggests an interest in being contacted about employment opportunities.

Apply About employer

More about this job

Responsibilities

Design, develop, and maintain scalable ETL pipelines and database backends for data warehouse and business intelligence solutions, including data integration, cleansing, loading, and performance optimization. Translate requirements into tested applications, troubleshoot operational issues, document solutions, and collaborate with stakeholders and development teams throughout delivery.

Requirements

The role requires extensive experience with Azure and AWS data technologies, Databricks, ETL development, data warehousing, database administration, complex SQL, and performance tuning. Candidates should also have experience with Git, technical documentation, requirements gathering, and the software development lifecycle, along with strong written and verbal communication skills.

Skills

Azure Data Factory
Azure SQL Database
Azure Data Lake
Power BI
Databricks
Amazon Web Services
AWS Glue
Amazon Aurora
Amazon RDS
OpenSearch
ETL Development
Data Integration
Data Warehousing
SQL Performance Tuning
Git
Data Modeling

Visa sponsorship

Not detected in the job text

Keywords

Azure Data Factory
Azure SQL Database
Azure Data Lake
Power BI
Databricks
Amazon Web Services
Amazon Aurora
Amazon RDS
AWS Glue
OpenSearch
ETL
Data Pipelines
Data Integration
Data Cleansing
Data Analytics
Data Warehousing
Data Marts
Data Modeling
Database Administration
SQL
Performance Tuning
Git
C#
PowerShell
Business Intelligence
Dashboards
Key Performance Indicators
AODA
Technical Documentation

Report this job