Log in Sign up free
Apply now

Posted yesterday

Software Developer ETL

@ Upstaff

View all jobs

Toronto, Ontario

Full-time
Apply now
SIGNALS

Overview

Upstaff is hiring a Senior Software Developer – ETL for the Ontario Public Sector, a full-time role. The work centres on building scalable data pipelines on Azure and Microsoft Fabric, transforming data into Silver and Gold layers, and delivering Power BI reports. The posting asks for onsite work in Toronto and may include support for the Protect Ontario by Unleashing Our Economy Act projects.

Responsibilities:

  • Design and build scalable data pipelines in Microsoft Fabric and Azure
  • Transform raw data into Silver and Gold layers
  • Develop semantic models and Power BI reports and dashboards
  • Implement CI/CD pipelines using Azure DevOps
  • Troubleshoot and support deployment and migration

Requirements summary:

  • Strong Azure technologies experience
  • Hands-on Azure Databricks and PySpark
  • Microsoft Fabric and Power BI semantic modelling
  • Star Schema and Snowflake data modelling
  • Direct Lake semantic model design

Tools & skills

Azure DatabricksAzure Data Lake Storage Gen2Microsoft Fabric Data FactoryPower BIAzure DevOpsPySparkSQL
Source and dates

Source type not verified · zoho

Employer posting date
2026-11-05
First seen by our source
2026-11-06
Source record updated
2026-11-06

These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.

Job details

SenioritySenior
DepartmentSoftware development
Hours per week40 (estimated)
Travelair: none · ground: none
Work settingOffice
PositionMostly sitting
Physical demandsphysical low · computer high
LanguagesEnglish

Summary and details written by AI from the posting; the employer’s posting is the authority.

Apply now
FieldValue
Open jobs on Jobsy10
Job description

Job Description

The Ontario Public Sector is seeking a Senior Software Developer – ETL with strong expertise in Azure Data Engineering, Microsoft Fabric, Databricks, PySpark, and Power BI.

The successful candidate will be responsible for designing and developing scalable data pipelines, transforming raw data into Silver and Gold data layers, developing semantic models, and delivering high-performance Power BI reports and dashboards.

The resource may also support projects related to the Protect Ontario by Unleashing Our Economy Act, as required.

Key Responsibilities

  • Analyze business data and design semantic data models.

  • Transform raw data into Silver and Gold layers for reporting and analytics.

  • Design, develop, deploy, and maintain Power BI reports and dashboards.

  • Develop operational, analytical, and paginated reports.

  • Build scalable data pipelines using Microsoft Fabric Data Factory.

  • Develop and optimize data access queries using SQL and PySpark.

  • Implement data engineering solutions using Azure Databricks and Azure Data Lake Storage Gen2.

  • Translate business requirements into technical specifications and working applications.

  • Implement CI/CD pipelines using Azure DevOps.

  • Develop and support OLAP analytical solutions.

  • Troubleshoot technical issues and support software implementation, migration, and deployment.

  • Collaborate with data analysts and business stakeholders to deliver reporting solutions.

Mandatory Skills and Experience

  • Strong experience with Azure technologies.

  • Hands-on experience with Azure Databricks.

  • Experience with Azure Data Lake Storage Gen2.

  • Strong Power BI development and semantic modelling skills.

  • Experience implementing CI/CD pipelines using Azure DevOps.

  • Strong PySpark development experience.

  • Hands-on Microsoft Fabric experience.

  • Experience with Star Schema and Snowflake data modelling.

  • Proficiency in Microsoft Fabric Data Factory for developing complex and scalable data pipelines.

  • Experience designing Direct Lake semantic models in Power BI using Silver and Gold layer models.

  • Experience developing operational, analytical, and paginated Power BI reports.

Desirable Skills

  • Experience with Azure Data Factory.

  • Experience building Lakehouses and Data Warehouses.

  • Strong PySpark and SQL optimization skills.

  • Knowledge of Medallion Architecture (Bronze, Silver, and Gold).

  • Experience implementing data governance and security.

  • Knowledge of Row-Level Security and Column-Level Security.

  • Experience with data lineage tracking.

Ideal Candidate Profile

  • Senior Azure Data Engineer or ETL Developer.

  • Strong background in Azure Databricks, PySpark, and ADLS Gen2.

  • Hands-on experience with Microsoft Fabric and Fabric Data Factory.

  • Strong Power BI reporting and semantic modelling expertise.

  • Experience with Direct Lake and OneLake.

  • Strong knowledge of Azure DevOps and CI/CD.

  • Previous Ontario Public Service or Canadian public sector project experience.

  • Willingness to work onsite in Toronto.


Similar jobs

  • Sales Associate

    Toronto, ON

    Rogers Communications: Rogers is Canada’s communications and entertainment company, driven to connect and entertain Canadians.

    We deliver a seamless experience, value expertise, dedication, and commitment to doing what’s right for our customers needs, every time.; Tailoring Solutions: Enhance the retail experience in our stores, providing best in class service by…

  • Community Enablement Specialist, Video (Askuity division)

    Toronto, ON
    HybridFull Time

    ASKUITY

    2+ YOEThe role will also measure the success of implemented content and make continuous improvements to optimize the user experience; If you are creative, collaborative, possess outstanding communication skills, and have…

    Editing, Collaboration, Merchandising, Communication skills, Motion graphics, Video editing

  • Nieuport Aviation Shuttle Operations Supervisor - Toronto

    Toronto, ON
    $60k–$65k/yrOn-siteFull Time

    Voyago

    2+ YOEVoyago needs a safety-focused supervisor with a college diploma or equivalent experience, preferably two years in a similar role, a valid B or C licence (or G licence upgradable within 3 months), a clean driver abstract and criminal record check with vulnerable sector screening, and strong customer service and communication skills.

  • Post Office Clerk, Hourly Part Time Day

    Toronto, ON
    Part Time

    Shoppers Drug Mart

    Candidates need a strong customer service focus, good written and verbal communication, basic computer skills and cash-handling experience. Strong organization, attention to detail, time management and the ability to work flexible shifts including evenings and weekends are also needed.

    Échelle

    Beauty Specialist, Hourly Part Time Day

    Toronto, ON
    Part Time

    Shoppers Drug Mart

    Candidates need retail sales experience with proven results, strong knowledge of beauty products, and the ability to give personalized makeup and skincare consultations and demonstrations. Strong communication skills and the physical ability to lift 50 lb and climb a ladder are required.

    Pharmacy Assistant, Hourly Full Time Flexible Shifts

    Toronto, ON
    Full Time

    Shoppers Drug Mart

    Candidates need a high school diploma, with a recognized pharmacy technician assistant course preferred. Prior pharmacy experience is an asset, along with strong organization, multitasking, problem-solving and attention to detail.

    Systèmes de pharmacie, Caisse

  • Legal Counsel - Disputes & Regulatory Lawyer

    Toronto, ON

    EY

    Support in identifying and addressing legal and regulatory issues including matters relating to client proposals, regulatory investigations, audit restatements, required reporting and…; Conduct legal research on…

  • Elementary ELA Teacher

    Toronto, ON
    $3.5k/mo

    Think Academy US: Think Academy US (www.TheThinkAcademy.com), a 100% owned subsidiary of TAL Education Group(NYSE: TAL), is recently established education technology…

    We welcome applicants with varying levels of teaching experience who are passionate about education and interested in professional development and long-term career growth; Work arrangements are subject to performance,…

    Counsel students, Teaching, Curriculum development, Communication skills, Tutoring, Problem solving

Locations & environments

Locations

All of CanadaRemote · Hybrid · On-site · Field

Pro tip: add remote jobs to widen your search.

Exclude locations

Workplace type

Company jobs in these results

These are this company’s jobs loaded in your current search. The company may have more openings.