Find work in Canada.

358,736 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 20 mins ago
Sr. Solution Architect
Rogers Communications
Brampton, ON · Calgary, AB
This role sits within the Data & AI team and provides technical leadership across end-to-end data and AI architecture, from requirements and design through to implementation. You’ll work…
Added 1 hour ago
AS
Lead, Technology Strategy & Innovation
Alquemy Search & Consulting
Toronto, ON
- Contract
Cross-Functional Execution: Collaborate closely with engineering, data, risk, security, and architecture teams to translate business vision into practical implementation while leaving the…
Added 2 hours ago
SM
RQ11714 – Business Analyst – Senior
S M Software Solutions Inc
Toronto, ON
- Full-time
SEO, journey mapping, user stories, information architecture, content auditing and evaluation, wireframing, prototyping, persona development, user research, and content testing.
Added 2 hours ago
SM
RQ11713 – Software Developer – ETL – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
Experience creating technical documentation, including ETL source-to-target mappings, data model diagrams, architecture artifacts, detailed design documents, etc.
Added 2 hours ago
SM
RQ11531 – Scrum Master – Intermediate
S M Software Solutions Inc
Toronto, ON
- Internship
…associated with the development and implementation of enterprise architecture…
Added 2 hours ago
SM
RQ11713 – Software Developer – ETL – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
Experience creating technical documentation, including ETL source-to-target mappings, data model diagrams, architecture artifacts, detailed design documents, etc.
Added 2 hours ago
SM
RQ11718 – Software Developer – Intermediate
S M Software Solutions Inc
Toronto, ON
- Internship
Experience writing Web Services and implementing Service-Oriented Architecture (SOA).
Added 2 hours ago
SM
RQ11713 – Software Developer – ETL – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
Experience creating technical documentation, including ETL source-to-target mappings, data model diagrams, architecture artifacts, detailed design documents, etc.
Added 2 hours ago
SM
RQ11714 – Business Analyst – Senior
S M Software Solutions Inc
Toronto, ON
- Full-time
SEO, journey mapping, user stories, information architecture, content auditing and evaluation, wireframing, prototyping, persona development, user research, and content testing.
Added 2 hours ago
SM
RQ11718 – Software Developer – Intermediate
S M Software Solutions Inc
Toronto, ON
- Internship
Experience writing Web Services and implementing Service-Oriented Architecture (SOA).
Added 2 hours ago
SM
RQ11531 – Scrum Master – Intermediate
S M Software Solutions Inc
Toronto, ON
- Internship
…associated with the development and implementation of enterprise architecture…
Added 2 hours ago
SM
RQ11615 - Business Analyst - Junior
S M Software Solutions Inc
Toronto, ON
- Internship
…with OPS Unified Project Management Methodology, Enterprise Architecture and Gating Process, and OPS Standard Systems Development…
Added 2 hours ago
SM
RQ11619 – Business Analyst – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
…Agile methodologies, business modelling, enterprise business architecture, stakeholder engagement, business case development, requirements analysis, user stories, process mapping, systems…
Added 2 hours ago
SM
RQ11705 – Solutions Designer – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
…functional design documentation, application flows, and business architecture. The ideal candidate will have strong expertise in gathering and translating business requirements into…
Added 2 hours ago
SM
RQ11531 – Scrum Master – Intermediate
S M Software Solutions Inc
Toronto, ON
- Internship
…associated with the development and implementation of enterprise architecture…
Added 2 hours ago
SM
RQ11619 – Business Analyst – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
…Agile methodologies, business modelling, enterprise business architecture, stakeholder engagement, business case development, requirements analysis, user stories, process mapping, systems…
Added 2 hours ago
SM
RQ11518 – Business Analyst – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
…Agile methodologies, business modelling, enterprise business architecture, stakeholder engagement, business case development, requirements analysis, user stories, process mapping, systems…
Added 2 hours ago
SM
RQ11518 – Business Analyst – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
…Agile methodologies, business modelling, enterprise business architecture, stakeholder engagement, business case development, requirements analysis, user stories, process mapping, systems…
Added 2 hours ago
SM
RQ11611 – Business Analyst – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
…story development, business modelling, enterprise business architecture, stakeholder engagement, and I&IT solution delivery. The successful candidate will lead business analysis activities,…
Added 2 hours ago
SM
RQ11612 – Business Analyst – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
…Agile methodologies, business modelling, enterprise business architecture, stakeholder engagement, business case development, requirements analysis, user stories, process mapping, systems…
Added 2 hours ago
SM
RQ11615 - Business Analyst - Junior
S M Software Solutions Inc
Toronto, ON
- Internship
…with OPS Unified Project Management Methodology, Enterprise Architecture and Gating Process, and OPS Standard Systems Development…
Added 2 hours ago
SM
RQ11693 – Privacy Impact Assessment (PIA) Specialist – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
…information, including Internet tools, system interfaces, information security, information architecture, and data…
Added 2 hours ago
SM
RQ11705 – Solutions Designer – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
…functional design documentation, application flows, and business architecture. The ideal candidate will have strong expertise in gathering and translating business requirements into…
Added 2 hours ago
SM
RQ11705 – Solutions Designer – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
…functional design documentation, application flows, and business architecture. The ideal candidate will have strong expertise in gathering and translating business requirements into…
Added 2 hours ago
SM
RQ11619 – Business Analyst – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
…Agile methodologies, business modelling, enterprise business architecture, stakeholder engagement, business case development, requirements analysis, user stories, process mapping, systems…

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 extraction, transformation, loading, and performance optimization. Translate system specifications and business requirements into tested applications, troubleshoot technical issues, and produce technical documentation while collaborating with development teams and clients.

Requirements

The role requires experience with Azure and AWS data technologies, Databricks, ETL development and scheduling, data integration, data warehousing, database administration, complex SQL, and performance tuning. Candidates should also have experience with Git, technical documentation, business requirements, 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
ETL Development
Data Integration
Data Warehousing
SQL Performance Tuning
Database Administration
Data Modeling
Git
C#
PowerShell

Visa sponsorship

Not detected in the job text

Keywords

Microsoft Azure
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
Database Administration
SQL
Performance Tuning
Git
C#
APIs
PowerShell
Business Intelligence
Technical Documentation
AODA
Dashboard Development

Report this job