Jobs in Canada

Group jobs by employerEmail me new jobs Save this search

Added 21 days ago
P
Full Stack Developer
PiiComm
ON · Plantagenet, ON
- Full-time
PiiComm is seeking a Full Stack Developer to join our growing R&D team. You will own deliverables from concept through deployment, building production-ready applications in Azure with…
Added 21 days ago
Senior Data Solutions Specialist
National Research Council Canada
Ottawa, ON
…for a limited hybrid work arrangement (combination of working onsite and…
Added 22 days ago
SM
Python Developer
S M Software Solutions Inc
Mississauga, ON
- Full-time
This is an on-site assignment, requiring candidates to be present in the office five days per week
Added 22 days ago
SM
RQ00821 – Solution Architect – CRM – Intermediate
S M Software Solutions Inc
Toronto, ON
- Internship
Hours: 7.25 hours per day, 5 days per week · Public Sector Experience: Must Have
Added 22 days ago
SM
RQ00821 – Solution Architect – CRM – Intermediate
S M Software Solutions Inc
Toronto, ON
- Internship
Hours: 7.25 hours per day, 5 days per week · Public Sector Experience: Must Have
Added 22 days ago
SM
Python Developer
S M Software Solutions Inc
Mississauga, ON
- Full-time
This is an on-site assignment, requiring candidates to be present in the office five days per week
Added 22 days ago
SM
RQ11529 – Automation Developer – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
Work Arrangement: Onsite – 5 Days per Week · Onsite – 5 days per week
Added 22 days ago
SM
RQ00821 – Solution Architect – CRM – Intermediate
S M Software Solutions Inc
Toronto, ON
- Internship
Hours: 7.25 hours per day, 5 days per week · Public Sector Experience: Must Have
Added 22 days ago
SM
RQ11486 – Data Ops/Cloud Data Engineer – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
Work Arrangement: Onsite – 5 Days per Week · Candidates Must Demonstrate Strong Hands-on Experience In The Mandatory Technical Skills And Responsibilities Outlined In The Must Have And General
Added 22 days ago
SM
RQ11716 – Systems Testing/QA Specialist – Intermediate
S M Software Solutions Inc
Toronto, ON
- Internship
Work Arrangement: Onsite – 5 Days per Week
Added 22 days ago
SM
RQ11486 – Data Ops/Cloud Data Engineer – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
Work Arrangement: Onsite – 5 Days per Week · Candidates Must Demonstrate Strong Hands-on Experience In The Mandatory Technical Skills And Responsibilities Outlined In The Must Have And General
Added 22 days ago
SM
RQ11716 – Systems Testing/QA Specialist – Intermediate
S M Software Solutions Inc
Toronto, ON
- Internship
Work Arrangement: Onsite – 5 Days per Week
Added 22 days ago
SM
RQ11716 – Systems Testing/QA Specialist – Intermediate
S M Software Solutions Inc
Toronto, ON
- Internship
Work Arrangement: Onsite – 5 Days per Week
Added 22 days ago
SM
RQ11486 – Data Ops/Cloud Data Engineer – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
Work Arrangement: Onsite – 5 Days per Week · Candidates Must Demonstrate Strong Hands-on Experience In The Mandatory Technical Skills And Responsibilities Outlined In The Must Have And General
Added 22 days ago
SM
RQ11529 – Automation Developer – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
Work Arrangement: Onsite – 5 Days per Week · Onsite – 5 days per week
Added 22 days ago
SM
RQ11529 – Automation Developer – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
Work Arrangement: Onsite – 5 Days per Week · Onsite – 5 days per week
Added 22 days ago
SM
Python Developer
S M Software Solutions Inc
Mississauga, ON
- Full-time
This is an on-site assignment, requiring candidates to be present in the office five days per week
Added 22 days ago
GM
Backend Engineer (Co-op)
General Magic
Toronto, ON
- Full-time
…from Radical Ventures, a16z and several AI luminaries. We work onsite in Toronto five days a…
Added 22 days ago
GM
AI Engineer (Co-op)
General Magic
Toronto, ON
- Full-time
…from Radical Ventures, a16z and several AI luminaries. We work onsite in Toronto five days a…
Added 22 days ago
SM
RQ00821 – Solution Architect – CRM – Intermediate
S M Software Solutions Inc
Toronto, ON
- Internship
Hours: 7.25 hours per day, 5 days per week · Public Sector Experience: Must Have
Added 22 days ago
SM
RQ00821 – Solution Architect – CRM – Intermediate
S M Software Solutions Inc
Toronto, ON
- Internship
Hours: 7.25 hours per day, 5 days per week · Public Sector Experience: Must Have
Added 22 days ago
SM
RQ00821 – Solution Architect – CRM – Intermediate
S M Software Solutions Inc
Toronto, ON
- Internship
Hours: 7.25 hours per day, 5 days per week · Public Sector Experience: Must Have
Added 22 days ago
SM
RQ11716 – Systems Testing/QA Specialist – Intermediate
S M Software Solutions Inc
Toronto, ON
- Internship
Work Arrangement: Onsite – 5 Days per Week
Added 22 days ago
SM
Python Developer
S M Software Solutions Inc
Mississauga, ON
- Full-time
This is an on-site assignment, requiring candidates to be present in the office five days per week
Added 22 days ago
SM
RQ11486 – Data Ops/Cloud Data Engineer – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
Work Arrangement: Onsite – 5 Days per Week · Candidates Must Demonstrate Strong Hands-on Experience In The Mandatory Technical Skills And Responsibilities Outlined In The Must Have And General

S M Software Solutions Inc

RQ11486 – Data Ops/Cloud Data Engineer – Senior

Toronto, ON, Canada

Internship

Apply on LinkedIn About employer

Applications open in a new tab.

Job details

Job type: Internship
Apply by: Nov 17, 2026
Posting language: English
Posted: Oct 18, 2026

Original job description

Client: Ministry of Public and Business Service Delivery and Procurement – RQ11486

We are seeking a Senior Data Ops/Cloud Data Engineer with extensive experience in designing, developing, automating, and optimizing complex data pipelines and cloud-based data platforms. The ideal candidate will have strong hands-on expertise in Databricks, Delta Live Tables (DLT), Unity Catalog or equivalent technologies, Azure Data Factory, advanced SQL, PySpark, data modelling, and enterprise-scale data migration and integration. The successful candidate will be responsible for building and optimizing ETL/ELT processes, implementing CI/CD practices, managing cloud data services, and supporting data engineering initiatives across multiple platforms, including Oracle, Azure Data Lake, Databricks, and Microsoft Fabric.

Role Snapshot

Job Title: RQ11486 – Data Ops/Cloud Data Engineer – Senior
Client: Ministry of Public and Business Service Delivery and Procurement
Work Location: 40 St. Clair Avenue West, Toronto, Ontario, Canada
Work Arrangement: Onsite – 5 Days per Week
Estimated Start Date: October 5, 2026
Estimated End Date: March 31, 2027
Business Days: 123.00
Extension: 60.00
Hours: 7.25 hours per day
Security Level: No Clearance Required

Must Have

Experience designing, building, automating, and optimizing complex data ETL/ELT processes using Databricks, Delta Live Tables (DLT), or equivalent technologies.
Experience developing unified data platforms using Databricks and Unity Catalog or equivalent technologies.
Experience with relational databases, including Oracle, MySQL, and SQL Server; relational and dimensional data modelling; advanced SQL; query optimization; data replication; and database administration.
Advanced SQL skills, including PL/SQL and T-SQL.
Experience with big data processing frameworks, including PySpark.
Proficiency in creating Azure Data Factory pipelines for copy activities and developing custom data pipelines in Databricks with CI/CD using Azure DevOps Git integration.
Experience with data migration and integration across different platforms, including:
- Oracle to Azure Data Lake
- Oracle to Databricks
- Oracle to Microsoft Fabric

Description

To respond to the priorities of the Government of Ontario through the passage of Bill 5, Protect Ontario by Unleashing Our Economy Act, 2025, the resource may be partially assigned to Bill 5-related projects or initiatives on an as-needed basis.

Responsibilities

Design and develop data pipelines from source systems to end users.
Optimize data pipelines.

General Skills

Experience with cloud data platforms, data management, and data exchange tools and technologies.
Experience with commercial and open-source data and database development and management, specializing in data storage settings and managing Cloud Data as a Service (DaaS), application Database as a Service (DBaaS), Data Warehouses as a Service (DaaS), and other storage platforms in both cloud and on-premises environments.
Experience with data pipeline and workflow development, orchestration, deployment, and automation, specializing in programming and pipelines to create and manage data flows and data movement.
Experience as a Cloud Data Engineer, including familiarity with and experience in different programming languages and the ability to integrate multiple platforms to create data pipelines, automate tasks, and write scripts.
Experience with DataOps principles, best practices, implementation, and Agile project development and deployment.
Experience with Continuous Integration/Continuous Development/Deployment (CI/CD) and data provisioning automation.
Experience with digital products, data analysis, data exchange, data provisioning, and data security.
Extensive expert experience in designing, developing, and implementing data conversion and migration of Very Large Data (VLD) across Online Analytical Processing (OLAP) and Online Transaction Processing (OLTP) environments to Cloud Software as a Service (SaaS), Platform as a Service (PaaS), and Infrastructure as a Service (IaaS) environments.
Experience in the design, development, and implementation of fact/dimension models, data mapping, data warehouses, data lakes, and data lakehouses for enterprise environments.
Experience managing cloud data services for project delivery, including storage, repositories, data lakes, data lakehouses, key vaults, virtual machines, disks, and related services.
Experience with structured, semi-structured, and unstructured data collection, ingestion, provisioning, and exchange; technological development of enterprise data warehouse, data lake, and data lakehouse solutions; and operational support.
Experience with DataOps performance monitoring and tuning.
Excellent analytical, problem-solving, and decision-making skills; verbal and written communication skills; presentation skills; interpersonal skills; and negotiation skills.
A team player with a track record of meeting deadlines.

Desirable Skills And Experience

Data lake design and development, with a focus on extracting and transforming data from various sources and loading it into a lakehouse using medallion architecture.
Advanced skills and hands-on experience with Oracle databases, Azure SQL Server, and Azure Data Factory.
Experience with cloud technologies, including Azure, Google Cloud, and AWS.
Experience with PL/SQL for data extraction, transformation, and loading; initial setup; and other ETL experience, including management and support activities such as troubleshooting, performance tuning, failover, and recovery.
Experience with scripting languages, including Python, Unix shell, and Scala.

Experience And Skill Set Requirements

Mandatory Skills and Experience - 70%

Candidates Must Demonstrate Strong Hands-on Experience In The Mandatory Technical Skills And Responsibilities Outlined In The Must Have And General Skills Sections, Including:

Designing, building, automating, and optimizing ETL/ELT data pipelines using Databricks, Delta Live Tables (DLT), or equivalent technologies.
Developing unified data platforms using Databricks and Unity Catalog or equivalent technologies.
Working with relational databases, data modelling, advanced SQL, PL/SQL, T-SQL, query optimization, data replication, and database administration.
Applying big data processing frameworks, including PySpark.
Developing Azure Data Factory pipelines and custom Databricks data pipelines with CI/CD and Azure DevOps Git integration.
Performing data migration and integration across Oracle, Azure Data Lake, Databricks, and Microsoft Fabric.
Applying DataOps principles, CI/CD, data provisioning automation, cloud data management, pipeline orchestration, performance monitoring, and tuning.
Supporting enterprise-scale data conversion, migration, warehousing, lake, and lakehouse solutions.
Desirable Skills and Experience - 25%
Data lake and lakehouse design and development using medallion architecture.
Advanced hands-on experience with Oracle databases, Azure SQL Server, and Azure Data Factory.
Knowledge of Azure, Google Cloud, and AWS.
PL/SQL-based data extraction, transformation, loading, ETL management, troubleshooting, performance tuning, failover, and recovery.
Scripting experience with Python, Unix shell, and Scala.
Education - 3%
Education-related qualifications and experience as applicable to the assignment requirements.
Public Sector Experience - 2%
Public sector experience relevant to the assignment and the priorities of the Government of Ontario.

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 21, 2026, at 8: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

Note:

The candidate is required to work from the office five days per week.

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 on LinkedIn About employer

More about this job

Responsibilities

Design, develop, automate, and optimize enterprise data pipelines and cloud data platforms, including ETL/ELT workflows and integrations across Oracle, Azure Data Lake, Databricks, and Microsoft Fabric. Manage data services and support migration, orchestration, CI/CD, performance monitoring, and tuning.

Requirements

Requires extensive senior-level hands-on experience with Databricks, Delta Live Tables or equivalent, Unity Catalog or equivalent, Azure Data Factory, advanced SQL, PySpark, data modeling, and relational databases. Candidates should also have experience with Azure DevOps CI/CD, DataOps, and enterprise-scale data migration and integration; cloud experience and scripting with Python, Unix shell, or Scala are desirable.

Skills

Databricks
Delta Live Tables
Unity Catalog
Azure Data Factory
Advanced SQL
PL/SQL
T-SQL
PySpark
Data Modeling
ETL/ELT Pipelines
Azure DevOps
CI/CD
Oracle
Azure Data Lake
Microsoft Fabric
DataOps

Visa sponsorship

Not detected in the job text

Keywords

Databricks
Delta Live Tables
Unity Catalog
Azure Data Factory
Azure DevOps
Microsoft Fabric
Azure Data Lake
Oracle
MySQL
SQL Server
Azure SQL Server
Advanced SQL
PL/SQL
T-SQL
PySpark
Python
Unix Shell
Scala
ETL/ELT
DataOps
CI/CD
Data Migration
Data Integration
Data Modeling
Data Warehousing
Data Lakehouse
Medallion Architecture
Pipeline Orchestration
Query Optimization
Google Cloud

Report this job

Work requirements

Jobs in Canada