Find work in Canada.

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

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 1 hour ago
HT
Financial Manager - PLM (Product Line Mgmt)
Husky Technologies
Bolton, ON
- Full-time
Translate complex data into clear, actionable recommendations for senior leadership
Added 1 hour ago
UO
Senior Coordinator, Competency Assessment
University of Ottawa
Ottawa, ON · Roger Guindon Hall
- Full-time
…thresholds. They are responsible for providing accurate and timely data and appropriate logistical support to the Clerkship Competence and Promotion Committee (CCPC) to ensure informed,…
Added 1 hour ago
Sr. Solution Architect
Rogers Communications
Brampton, ON · Calgary, AB
Act as a senior technical partner to business stakeholders, architects, engineers, data science, analytics, security, governance, and platform teams.
Added 1 hour ago
AC
Trader (Blockchain) Toronto
AP Capital
Toronto, ON
- Full-time
Support senior traders with trade execution and strategy monitoring
Added 3 hours 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 3 hours ago
SM
RQ11713 – Software Developer – ETL – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
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…
Added 3 hours ago
SM
RQ11713 – Software Developer – ETL – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
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…
Added 3 hours ago
SM
RQ11713 – Software Developer – ETL – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
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…
Added 3 hours 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 3 hours 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 3 hours 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 3 hours 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 3 hours 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 3 hours 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 3 hours 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 3 hours 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 3 hours 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 3 hours 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 3 hours ago
SM
RQ11648 – Business Analyst – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking a Senior Business Analyst with extensive experience in business analysis, requirements gathering, requirements management, business process modelling, stakeholder engagement,…
Added 3 hours 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 3 hours ago
SM
RQ11648 – Business Analyst – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking a Senior Business Analyst with extensive experience in business analysis, requirements gathering, requirements management, business process modelling, stakeholder engagement,…
Added 3 hours 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 3 hours 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 3 hours ago
SM
RQ11706 – Software Developer – Senior
S M Software Solutions Inc
Toronto, ON
- Full-time
We are seeking a Senior Software Developer with extensive experience in Oracle Siebel CRM technical configuration, solution design, development, and integration. The ideal candidate will…
Added 3 hours ago
SM
RQ11648 – Business Analyst – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking a Senior Business Analyst with extensive experience in business analysis, requirements gathering, requirements management, business process modelling, stakeholder engagement,…

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 applications supporting data warehouses and business intelligence solutions. Optimize data integration and database performance, document technical designs, test and troubleshoot applications, and collaborate with stakeholders and development teams.

Requirements

Requires extensive experience with Azure and AWS data technologies, Databricks, ETL development, 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
Amazon Aurora
Amazon RDS
OpenSearch
ETL Development
SQL Performance Tuning
Data Warehousing
Data Modeling
Git
C#

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#
APIs
PowerShell
Business Intelligence
Technical Documentation
AODA
Dashboard Design

Report this job