Jobs in Canada

Email me new jobs Save this search

Added 7 hours ago
SM
RQ00240 – Product Manager – Senior
S M Software Solutions Inc
Toronto, ON
- Full-time
Degree in Business, Computer Science, Information Systems, Engineering, Data/Analytics, or a related field, or equivalent experience.
Added 7 hours ago
SM
RQ11673 – Report Developer – Junior
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking a Junior Report Developer / Data Engineer with experience in developing, implementing, and maintaining enterprise data solutions using modern Azure cloud technologies. The…
Added 7 hours ago
SM
RQ11717 – Business Analyst – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
…business analysis, requirements gathering, business process re-engineering, business case development, and system functional requirements. The ideal candidate will have strong expertise in…
Added 7 hours ago
SM
RQ11717 – Business Analyst – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
…business analysis, requirements gathering, business process re-engineering, business case development, and system functional requirements. The ideal candidate will have strong expertise in…
Added 7 hours ago
SM
RQ00241 – Software Developer – ETL – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
Degree in Computer Science, Information Systems, Engineering, Data/Analytics, or a related discipline, or equivalent experience.
Added 7 hours ago
SM
RQ11673 – Report Developer – Junior
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking a Junior Report Developer / Data Engineer with experience in developing, implementing, and maintaining enterprise data solutions using modern Azure cloud technologies. The…
Added 7 hours ago
SM
DevOps Engineer
S M Software Solutions Inc
Mississauga, ON
- Full-time
We are looking for an experienced DevOps Engineer with 10+ years of experience in DevOps engineering, CI/CD automation, infrastructure management, containerization, orchestration, and…
Added 7 hours ago
SM
RQ11717 – Business Analyst – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
…business analysis, requirements gathering, business process re-engineering, business case development, and system functional requirements. The ideal candidate will have strong expertise in…
Added 7 hours ago
SM
RQ11673 – Report Developer – Junior
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking a Junior Report Developer / Data Engineer with experience in developing, implementing, and maintaining enterprise data solutions using modern Azure cloud technologies. The…
Added 7 hours ago
SM
RQ00240 – Product Manager – Senior
S M Software Solutions Inc
Toronto, ON
- Full-time
Degree in Business, Computer Science, Information Systems, Engineering, Data/Analytics, or a related field, or equivalent experience.
Added 7 hours ago
SM
Java Developer or Python Developer – Data Lineage & Metadata
S M Software Solutions Inc
Mississauga, ON
- Full-time
We are looking for a highly skilled Java Developer or Python Developer specializing in Data Lineage and Metadata Management with strong expertise in software engineering, backend…
Added 7 hours ago
SM
RQ00245 – Machine Learning Engineer – Senior
S M Software Solutions Inc
Toronto, ON
- Full-time
…ideal candidate will have strong Python and machine-learning engineering expertise, with a proven ability to take machine-learning models from experimentation through development and into…
Added 7 hours ago
SM
DevOps Engineer
S M Software Solutions Inc
Mississauga, ON
- Full-time
We are looking for an experienced DevOps Engineer with 10+ years of experience in DevOps engineering, CI/CD automation, infrastructure management, containerization, orchestration, and…
Added 7 hours ago
SM
RQ00240 – Product Manager – Senior
S M Software Solutions Inc
Toronto, ON
- Full-time
Degree in Business, Computer Science, Information Systems, Engineering, Data/Analytics, or a related field, or equivalent experience.
Added 7 hours ago
SM
RQ11676 – Software Developer – ETL – Intermediate
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking an experienced Intermediate Software Developer – ETL (Power BI Developer) with strong expertise in Microsoft Power BI, DAX, Power Query (M), SQL, data modelling, and…
Added 7 hours ago
SM
RQ11676 – Software Developer – ETL – Intermediate
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking an experienced Intermediate Software Developer – ETL (Power BI Developer) with strong expertise in Microsoft Power BI, DAX, Power Query (M), SQL, data modelling, and…
Added 7 hours ago
SM
RQ11676 – Software Developer – ETL – Intermediate
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking an experienced Intermediate Software Developer – ETL (Power BI Developer) with strong expertise in Microsoft Power BI, DAX, Power Query (M), SQL, data modelling, and…
Added 7 hours ago
SM
RQ11843 – Software Developer – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking a highly experienced Senior Software Developer with strong expertise in developing, designing, implementing, and maintaining n-tier enterprise applications. The ideal…
Added 7 hours ago
SM
Java Developer or Python Developer – Data Lineage & Metadata
S M Software Solutions Inc
Mississauga, ON
- Full-time
We are looking for a highly skilled Java Developer or Python Developer specializing in Data Lineage and Metadata Management with strong expertise in software engineering, backend…
Added 7 hours ago
SM
Java Developer or Python Developer – Data Lineage & Metadata
S M Software Solutions Inc
Mississauga, ON
- Full-time
We are looking for a highly skilled Java Developer or Python Developer specializing in Data Lineage and Metadata Management with strong expertise in software engineering, backend…
Added 7 hours ago
SM
RQ00245 – Machine Learning Engineer – Senior
S M Software Solutions Inc
Toronto, ON
- Full-time
…ideal candidate will have strong Python and machine-learning engineering expertise, with a proven ability to take machine-learning models from experimentation through development and into…
Added 7 hours ago
SM
RQ00241 – Software Developer – ETL – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
Degree in Computer Science, Information Systems, Engineering, Data/Analytics, or a related discipline, or equivalent experience.
Added 7 hours ago
SM
RQ00245 – Machine Learning Engineer – Senior
S M Software Solutions Inc
Toronto, ON
- Full-time
…ideal candidate will have strong Python and machine-learning engineering expertise, with a proven ability to take machine-learning models from experimentation through development and into…
Added 7 hours ago
SM
RQ00241 – Software Developer – ETL – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
Degree in Computer Science, Information Systems, Engineering, Data/Analytics, or a related discipline, or equivalent experience.
Added 7 hours ago
SM
DevOps Engineer
S M Software Solutions Inc
Mississauga, ON
- Full-time
We are looking for an experienced DevOps Engineer with 10+ years of experience in DevOps engineering, CI/CD automation, infrastructure management, containerization, orchestration, and…

S M Software Solutions Inc

RQ11676 – Software Developer – ETL – Intermediate

Toronto, ON, Canada

Internship

Apply About employer

Applications open in a new tab.

Job details

Job type: Internship
Apply by: Dec 7, 2026
Posting language: English
Posted: Nov 7, 2026

Original job description

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

We are seeking an experienced Intermediate Software Developer – ETL (Power BI Developer) with strong expertise in Microsoft Power BI, DAX, Power Query (M), SQL, data modelling, and enterprise business intelligence solutions. The ideal candidate will have experience developing interactive dashboards, reports, semantic models, and data visualizations while working with large datasets and complex business requirements. The successful candidate will support the Government of Ontario's Data & AI transformation initiative by delivering reliable, scalable, and insightful reporting and analytics solutions across government programs and services.

Role Snapshot

Job Title: RQ11676 – Software Developer – ETL – Intermediate
Client: Ministry of Public and Business Service Delivery and Procurement
Work Location: 222 Jarvis Street, Toronto, Ontario, Canada
Work Arrangement: Onsite – 5 Days per Week
Estimated Start Date: September 28, 2026
Estimated End Date: March 31, 2027
Business Days: 133.00
Extension: Probable after the initial mandate
Hours: 7.25 hours per day
Security Level: No Clearance Required

Must Have

Qualifications

Degree or diploma in Computer Science, Information Systems, Data Analytics, Business Intelligence, or a related field.
Experience developing dashboards, reports, and visualizations using Microsoft Power BI.
Strong knowledge of DAX, Power Query (M), and Power BI data modeling concepts.
Experience working with SQL and relational databases.
Understanding of data warehousing, dimensional modeling, and business intelligence best practices.
Experience working with large datasets and transforming complex business requirements into reporting solutions.
Strong analytical, problem-solving, and communication skills.
Ability to work collaboratively with technical and non-technical stakeholders.
Strong understanding of dimensional modelling, star schema design, and analytical data modelling concepts.
Knowledge of data governance, metadata management, and data lineage principles.

Nice to Have

Experience working with Databricks, including connecting Power BI to Databricks SQL Warehouses and Lakehouse data sources.
Familiarity with Azure Data Platform services such as Azure Data Lake Storage, Azure Synapse Analytics, Azure Data Factory, or Microsoft Fabric.
Experience with enterprise data governance and data quality initiatives.
Knowledge of Python, R, or other analytics tools.
Experience supporting data and analytics platforms within a large public-sector or enterprise environment.
Exposure to Agile delivery methodologies and DevOps practices.

Description

Role Overview

The Government of Ontario is undertaking a large-scale Data & AI transformation initiative, with the Ontario Data Platform (ODP) serving as the enterprise technology ecosystem for data-driven decision-making, analytics, and artificial intelligence.

ODP provides a modern and scalable data environment that supports data ingestion, storage, processing, governance, quality, marketplace capabilities, and advanced analytics across ministries and government organizations.

We are seeking a Power BI Developer to support the development, maintenance, and enhancement of enterprise reporting and analytics solutions. The successful candidate will work closely with business stakeholders, data engineers, architects, and product teams to deliver insightful dashboards, reports, and data visualizations that enable evidence-based decision-making across government programs and services.

Key Responsibilities

Power BI Development & Reporting
Design, develop, and maintain interactive Power BI dashboards and reports to support business and operational needs.
Create data models, measures, and calculations using DAX to deliver meaningful business insights.
Implement data visualization best practices to ensure reports are intuitive, accessible, and actionable.
Gather and analyze business requirements and translate them into reporting solutions.
Develop and maintain enterprise semantic models, datasets, and reusable reporting assets that support standardized analytics and reporting.
Data Integration & Analytics Support
Connect and integrate data from various enterprise data sources, including databases, APIs, cloud platforms, and data warehouses.
Develop and optimize Power Query (M) transformations for efficient data preparation and reporting.
Collaborate with data engineering teams to ensure data quality, governance, and consistency across reporting solutions.
Support ad hoc data analysis and reporting requests from business stakeholders.
Perform data validation, reconciliation, and user acceptance testing (UAT) activities to ensure reporting accuracy and integrity.
Performance, Governance & Support
Monitor and optimize report performance, data refresh schedules, and workspace administration.
Apply security models, row-level security (RLS), and governance standards within Power BI.
Troubleshoot data, visualization, and performance issues and provide ongoing support to users.
Develop and maintain documentation for reports, datasets, and reporting standards.
Maintain data lineage, metadata, and documentation for reporting assets and semantic models.
Ensure reporting solutions comply with organizational data governance, security, privacy, and accessibility standards.
Stakeholder Engagement & Knowledge Sharing
Work closely with business users to understand reporting requirements and identify opportunities for enhanced analytics.
Provide guidance and training to report consumers and business teams on Power BI capabilities and best practices.
Participate in Agile delivery teams and contribute to continuous improvement initiatives.

Experience And Skill Set Requirements

Technical (Azure/Databricks) – 80%
Strong technical expertise in Microsoft Power BI, including dashboard development, reporting, data visualization, and enterprise analytics solutions.
Strong knowledge of DAX, Power Query (M), and Power BI data modelling concepts.
Experience working with SQL and relational databases.
Understanding of data warehousing, dimensional modelling, star schema design, and analytical data modelling concepts.
Experience developing and maintaining enterprise semantic models, datasets, and reusable reporting assets.
Experience integrating data from enterprise data sources, including databases, APIs, cloud platforms, and data warehouses.
Experience working with large datasets and transforming complex business requirements into reporting solutions.
Knowledge of data governance, metadata management, and data lineage principles.
Experience with data validation, reconciliation, and user acceptance testing (UAT).
Understanding of Power BI security models, row-level security (RLS), workspace administration, and governance standards.
Ability to monitor and optimize report performance and data refresh schedules.
Experience troubleshooting data, visualization, and performance-related issues.
Familiarity with Databricks, including connecting Power BI to Databricks SQL Warehouses and Lakehouse data sources.
Familiarity with Azure Data Platform services such as Azure Data Lake Storage, Azure Synapse Analytics, Azure Data Factory, or Microsoft Fabric.
Knowledge of Python, R, or other analytics tools.
Experience with enterprise data governance and data quality initiatives.
Exposure to Agile delivery methodologies and DevOps practices.
Communication – 10%
Strong analytical, problem-solving, and communication skills.
Ability to work collaboratively with technical and non-technical stakeholders.
Strong ability to gather and analyze business requirements and translate them into effective reporting solutions.
Ability to work closely with business users, data engineers, architects, and product teams.
Ability to provide guidance and training to report consumers and business teams on Power BI capabilities and best practices.
Ability to support ad hoc data analysis and reporting requests from business stakeholders.
Ability to participate effectively in Agile delivery teams and contribute to continuous improvement initiatives.
Public Sector – 10%
Experience supporting data and analytics platforms within a large public-sector or enterprise environment.
Understanding of enterprise data governance, data quality, security, privacy, and accessibility standards.
Ability to collaborate with stakeholders across government programs and organizations.
Understanding of the importance of evidence-based decision-making through enterprise reporting and analytics solutions.

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 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

Additional Information

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

Develop and maintain interactive Power BI dashboards, reports, semantic models, and reusable reporting assets, integrating enterprise data and translating business requirements into actionable analytics. Ensure reporting accuracy, performance, security, governance, and documentation while supporting users and collaborating with business stakeholders, data engineers, architects, and product teams.

Requirements

Requires a degree or diploma in computer science, information systems, data analytics, business intelligence, or a related field, along with Power BI, DAX, Power Query, SQL, data modeling, and data warehousing experience. Candidates should be able to work with large datasets, apply governance and security practices, validate reporting, and communicate effectively with technical and non-technical stakeholders; Azure, Databricks, analytics tools, and public-sector experience are advantageous.

Skills

Microsoft Power BI
DAX
Power Query (M)
SQL
Data Modeling
Dimensional Modeling
Star Schema Design
Data Warehousing
Semantic Models
Data Visualization
Data Governance
Data Lineage
Row-Level Security
Databricks
Azure Data Platform
Stakeholder Communication

Visa sponsorship

Not detected in the job text

Keywords

Microsoft Power BI
DAX
Power Query (M)
SQL
Relational Databases
Data Modeling
Dimensional Modeling
Star Schema
Data Warehousing
Business Intelligence
Semantic Models
Dashboards
Data Visualization
Databricks
Databricks SQL Warehouses
Lakehouse
Azure Data Lake Storage
Azure Synapse Analytics
Azure Data Factory
Microsoft Fabric
Python
R
Data Governance
Data Quality
Data Lineage
Metadata Management
Row-Level Security
User Acceptance Testing
Agile
DevOps

Report this job