Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 1 hour ago
SM
RQ11735 – Business Analyst – Senior (Onsite)
S M Software Solutions Inc
Toronto, ON
- Internship
Client: Ministry of Public and Business Service Delivery and Procurement – RQ11735
Added 1 hour ago
SM
RQ11741 – Product Manager – Senior (Onsite)
S M Software Solutions Inc
Toronto, ON
- Internship
Client: Ministry of Public and Business Service Delivery and Procurement – RQ11741
Added 1 hour ago
SM
RQ11856 – Training Specialist – Senior (Onsite)
S M Software Solutions Inc
Toronto, ON
- Internship
Client: Ministry of Public and Business Service Delivery and Procurement – RQ11856
Added 1 hour ago
SM
RQ11858 – Oracle Cloud Integration Specialist – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
Added 1 hour ago
SM
RQ11858 – Oracle Cloud Integration Specialist – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
Added 1 hour ago
SM
RQ11845 – Software Developer – Senior (Onsite)
S M Software Solutions Inc
Toronto, ON
- Internship
Client: Ministry of Public and Business Service Delivery and Procurement – RQ11845
Added 1 hour ago
SM
RQ11731 – Business Analyst – Senior (Onsite)
S M Software Solutions Inc
Toronto, ON
- Internship
Client: Ministry of Public and Business Service Delivery and Procurement – RQ11731
Added 1 hour ago
SM
RQ11487 – Software Developer – ETL – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
Client: Ministry of Public and Business Service Delivery and Procurement – RQ11487
Added 1 hour ago
SM
RQ11856 – Training Specialist – Senior (Onsite)
S M Software Solutions Inc
Toronto, ON
- Internship
Client: Ministry of Public and Business Service Delivery and Procurement – RQ11856
Added 1 hour ago
SM
RQ11516 – Solutions Designer – Senior (Onsite)
S M Software Solutions Inc
Toronto, ON
- Internship
Client: Ministry of Public and Business Service Delivery and Procurement – RQ11516
Added 1 hour ago
SM
RQ11735 – Business Analyst – Senior (Onsite)
S M Software Solutions Inc
Toronto, ON
- Internship
Client: Ministry of Public and Business Service Delivery and Procurement – RQ11735
Added 1 hour ago
SM
RQ11734 – Business Analyst – Senior (Onsite)
S M Software Solutions Inc
Toronto, ON
- Internship
Client: Ministry of Public and Business Service Delivery and Procurement – RQ11734
Added 1 hour ago
SM
RQ11673 – Report Developer – Junior
S M Software Solutions Inc
Toronto, ON
- Internship
Client: Ministry of Public and Business Service Delivery and Procurement – RQ11673
Added 1 hour ago
SM
RQ11735 – Business Analyst – Senior (Onsite)
S M Software Solutions Inc
Toronto, ON
- Internship
Client: Ministry of Public and Business Service Delivery and Procurement – RQ11735
Added 1 hour ago
SM
RQ11487 – Software Developer – ETL – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
Client: Ministry of Public and Business Service Delivery and Procurement – RQ11487
Added 1 hour ago
SM
RQ11516 – Solutions Designer – Senior (Onsite)
S M Software Solutions Inc
Toronto, ON
- Internship
Client: Ministry of Public and Business Service Delivery and Procurement – RQ11516
Added 1 hour ago
SM
RQ11734 – Business Analyst – Senior (Onsite)
S M Software Solutions Inc
Toronto, ON
- Internship
Client: Ministry of Public and Business Service Delivery and Procurement – RQ11734
Added 1 hour ago
SM
RQ11731 – Business Analyst – Senior (Onsite)
S M Software Solutions Inc
Toronto, ON
- Internship
Client: Ministry of Public and Business Service Delivery and Procurement – RQ11731
Added 1 hour ago
SM
RQ11731 – Business Analyst – Senior (Onsite)
S M Software Solutions Inc
Toronto, ON
- Internship
Client: Ministry of Public and Business Service Delivery and Procurement – RQ11731
Added 1 hour ago
SM
RQ11673 – Report Developer – Junior
S M Software Solutions Inc
Toronto, ON
- Internship
Client: Ministry of Public and Business Service Delivery and Procurement – RQ11673
Added 1 hour ago
SM
RQ11673 – Report Developer – Junior
S M Software Solutions Inc
Toronto, ON
- Internship
Client: Ministry of Public and Business Service Delivery and Procurement – RQ11673
Added 1 hour ago
SM
RQ11741 – Product Manager – Senior (Onsite)
S M Software Solutions Inc
Toronto, ON
- Internship
Client: Ministry of Public and Business Service Delivery and Procurement – RQ11741
Added 1 hour ago
SM
RQ11856 – Training Specialist – Senior (Onsite)
S M Software Solutions Inc
Toronto, ON
- Internship
Client: Ministry of Public and Business Service Delivery and Procurement – RQ11856
Added 1 hour ago
SM
RQ11734 – Business Analyst – Senior (Onsite)
S M Software Solutions Inc
Toronto, ON
- Internship
Client: Ministry of Public and Business Service Delivery and Procurement – RQ11734
Added 1 hour ago
SM
RQ11733 – Business Analyst – Senior (Onsite)
S M Software Solutions Inc
Toronto, ON
- Internship
Client: Ministry of Public and Business Service Delivery and Procurement – RQ11733

S M Software Solutions Inc

RQ11487 – Software Developer – ETL – Senior

Toronto, ON, Canada

Internship

Apply About employer

Applications open in a new tab.

Job details

Job type: Internship
Apply by: Dec 7, 2026
Experience: 6+ years of experience with Azure technologies, including:
Posting language: English
Posted: Nov 7, 2026

Original job description

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

We are seeking a highly experienced Senior Software Developer – ETL with strong expertise in Azure data technologies, data engineering, ETL development, Microsoft Fabric, Azure Databricks, PySpark, and Power BI. The ideal candidate will have hands-on experience designing and developing scalable data pipelines, transforming raw data into structured Silver and Gold layers, building semantic models, and developing high-performance Power BI reports and dashboards. The successful candidate will support enterprise data architecture, business intelligence, data integration, and analytical reporting initiatives while ensuring data accuracy, reliability, security, and performance.

Role Snapshot

Job Title: RQ11487 – Software Developer – ETL – 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
Working Schedule: Monday to Friday, between 8:00 AM and 5:00 PM, excluding lunch breaks
Security Level: No Clearance Required

Must Have

6+ years of experience with Azure technologies, including:
- Azure Databricks
- Azure Data Lake Gen 2
- Power BI development and semantic modelling
- Azure DevOps CI/CD
- PySpark
- Microsoft Fabric
- Star Schema or Snowflake data modelling experience

Orchestration & Ingestion

Proficiency in using Data Factory within Microsoft Fabric to build complex and scalable data pipelines.

Business Intelligence

Experience designing efficient Direct Lake semantic models in Power BI using Silver/Gold layer models to ensure high-speed reporting directly from OneLake.
Experience using semantic models to design and develop Power BI reports and dashboards.
Ability to develop operational and analytical Power BI reports and paginated reports.

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

The successful candidate will be responsible for the following:

Analyse data and design semantic models.
Transform raw data into Silver/Gold data for reporting consumption.
Design, develop, release, and deploy Power BI reports and dashboards that meet KPIs, including accuracy, reliability, and performance.
Review business requirements and related materials to use as input for the design and development of reports.
Design technical system specifications and translate them into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining applications, and conducting unit tests.
Resolve and troubleshoot technical problems that arise during the use and operation of software packages, including providing technical assistance with implementation, conversion, and migrations.
Provide specialized skills for developing data access queries.
Work in conjunction with data analysts to develop dashboards and other end-user reporting products.
Support the client's wide-ranging business information requirements by implementing and supporting OLAP analytical software solutions.
Develop and support customized query applications that analyse key business data.

Desirable Skills And Experience

Experience with Azure Data Factory (ADF) v2.
Data Architecture & Engineering: Competency in building Lakehouses and Warehouses, writing optimized PySpark or SQL pipelines, and implementing Medallion Architecture (Bronze/Silver/Gold layers).
Data Governance: Experience with data security, including row-level and column-level security, and data lineage tracking.

Experience And Skill Set Requirements

The candidate will be evaluated based on the following experience and skill categories:

Mandatory Skills and Experience - 70%
6+ years of experience with Azure technologies, including Azure Databricks, Azure Data Lake Gen 2, Power BI development and semantic modelling, Azure DevOps CI/CD, PySpark, and Microsoft Fabric.
Experience with Star Schema or Snowflake data modelling.
Proficiency in using Data Factory within Microsoft Fabric to build complex and scalable data pipelines.
Experience designing efficient Direct Lake semantic models in Power BI using Silver/Gold layer models for high-speed reporting directly from OneLake.
Experience using semantic models to design and develop Power BI reports and dashboards.
Experience developing operational and analytical Power BI reports and paginated reports.
Desirable Skills and Experience - 25%
Experience with Azure Data Factory (ADF) v2.
Competency in building Lakehouses and Warehouses.
Experience writing optimized PySpark or SQL pipelines.
Experience implementing Medallion Architecture, including Bronze, Silver, and Gold layers.
Knowledge of data security, including row-level and column-level security.
Experience with data lineage tracking.
Education - 3%
Education-related qualifications and experience as applicable to the role requirements.
Public Sector Experience - 2%
Public sector experience relevant to the assignment and the Government of Ontario's business and information requirements.

How to Apply

If you are interested and your profile matches the requirements, kindly send the following mandatory documents to hrsmss@smsoftconsulting.com by Tuesday, November 10, 2026, at 9: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

Additional Information

Work Arrangement and Working Hours

This position is listed as Onsite, unless otherwise instructed by the Client. The resource is expected to work 7.25 hours per calendar day between the standard working hours of 8:00 AM and 5:00 PM, excluding lunch breaks, every Monday to Friday inclusive, at the identified Ontario Public Service (OPS) office location.

Onsite Requirement: 5 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 About employer

More about this job

Responsibilities

Design and build scalable data pipelines, transform raw data into Silver and Gold layers, and develop semantic models and Power BI reports and dashboards. Translate business requirements into tested applications, troubleshoot technical issues, support analytical and OLAP solutions, and collaborate with data analysts on reporting products.

Requirements

Requires 6+ years of experience with Azure data technologies, including Azure Databricks, Azure Data Lake Gen2, Microsoft Fabric, PySpark, Azure DevOps CI/CD, and Power BI development and semantic modeling. Candidates must also have data modeling and Fabric Data Factory pipeline experience, plus experience with Direct Lake models and operational, analytical, and paginated reports.

Skills

Azure Databricks
Azure Data Lake Gen2
Power BI
Semantic Modeling
Azure DevOps CI/CD
PySpark
Microsoft Fabric
Data Factory
ETL Development
Data Pipeline Development
Star Schema Modeling
Snowflake Modeling
Direct Lake
Medallion Architecture
Data Security
Data Lineage

Visa sponsorship

Not detected in the job text

Keywords

Azure Databricks
Azure Data Lake Gen2
Power BI
Microsoft Fabric
Azure DevOps
CI/CD
PySpark
SQL
ETL
Data Factory
Azure Data Factory v2
OneLake
Direct Lake
Semantic Models
Star Schema
Snowflake Modeling
Lakehouses
Warehouses
Medallion Architecture
Bronze Layer
Silver Layer
Gold Layer
Data Pipelines
Data Engineering
Data Governance
Row-Level Security
Column-Level Security
Data Lineage
OLAP
Paginated Reports

Report this job