Senior Software Developer - ETL

We are seeking a highly accomplished Senior Software Developer - ETL for an enterprise-level contract opportunity based in Toronto. In this role, you will take on a premier data engineering, ETL development, and business intelligence capacity, specializing in designing, building, and optimizing modern data lakehouse architectures and semantic reporting models.

As a Senior Software Developer - ETL, you will bridge the gap between complex source datasets, enterprise data platforms, and executive reporting solutions. Operating fully onsite in Toronto, you will lead the transformation of raw data into curated Silver and Gold lakehouse layers, architect scalable data ingestion pipelines using Microsoft Fabric and Azure Data Factory, and develop high-speed Direct Lake semantic models in Power BI. This position demands a technical data authority with extensive hands-on expertise across Azure Databricks, Azure Data Lake Gen 2, PySpark, Microsoft Fabric, dimensional data modeling (Star/Snowflake schema), and automated CI/CD pipelines who can ensure high-performance, accurate, and reliable data delivery.

Location: Toronto, ON

Assignment Type: Onsite (5 days per week)

Contract Duration: 6-month contract (with potential for extension)

Advantages
Modern Lakehouse Stack: Direct hands-on engineering across Microsoft Fabric, Azure Databricks, OneLake, and PySpark.

Next-Gen BI Architecture: Build high-speed Direct Lake semantic models in Power BI querying directly against Silver/Gold layers.

Full-Lifecycle Data Engineering: Own data pipelines end-to-end, from complex ingestion to dimensional modeling and reporting.

Enterprise CI/CD Automation: Deploy robust data products and automated pipeline release workflows using Azure DevOps.

Responsibilities
Analyze complex source data structures and design robust dimensional data models, including Star and Snowflake schemas.

Build, optimize, and maintain scalable ETL/ELT pipelines to transform raw data into curated Silver and Gold layers within lakehouse environments.

Design and orchestrate complex data ingestion pipelines utilizing Data Factory within Microsoft Fabric and Azure Data Factory.

Design, implement, and optimize efficient Direct Lake semantic models in Power BI to enable rapid, real-time reporting directly from OneLake.

Design, build, test, and deploy interactive Power BI reports, operational dashboards, and paginated reports that satisfy performance and accuracy KPIs.

Translate business and reporting requirements into detailed technical specifications, architecture diagrams, and data transformation logic.

Develop, compile, test, and maintain optimized PySpark scripts and data access queries for high-throughput analytical workloads.

Partner with business analysts and reporting teams to refine data visualizations, OLAP solutions, and self-service analytics frameworks.

Troubleshoot and resolve technical bottlenecks, pipeline execution failures, data discrepancy issues, and performance regressions.

Automate continuous integration and continuous deployment (CI/CD) pipelines for data assets, scripts, and reporting solutions using Azure DevOps.

Support data governance best practices, including row-level and column-level security implementations, data access controls, and data lineage tracking.

Qualifications
Core Technical & ETL Development Requirements
Azure Data Platform Tenure: Minimum 6+ years of dedicated hands-on experience working with Microsoft Azure data technologies and services.

Databricks & Data Lake: Proven hands-on experience using Azure Databricks, PySpark, and Azure Data Lake Storage Gen 2.

Microsoft Fabric & Orchestration: Demonstrated proficiency building and orchestrating scalable data pipelines using Microsoft Fabric and Data Factory.

Power BI & Semantic Modeling: Deep expertise in Power BI development, semantic modeling, paginated reports, and designing high-performance Direct Lake semantic models querying Silver and Gold lakehouse layers.

Data Modeling: Solid experience architecting enterprise analytical data structures using Star Schema or Snowflake schema methodologies.

DevOps Automation: Demonstrated hands-on experience implementing CI/CD pipelines and version control for data workflows using Azure DevOps.

Preferred Technical Assets & Domain Knowledge
Data Architecture: Strong competency implementing Medallion Architecture (Bronze, Silver, Gold layers), Lakehouses, and modern Data Warehouses.

Data Governance & Security: Practical knowledge of implementing data governance principles, row-level and column-level security, and data lineage tracking.

Azure Data Factory: Experience with standalone Azure Data Factory (ADF) v2 pipelines.

Public Sector Context: Prior experience delivering data platform or ETL solutions within a public sector environment is an asset.

Soft Skills & Delivery Attributes
Analytical Problem Solving: Superior diagnostic and query optimization skills to isolate data discrepancies, pipeline bottlenecks, and reporting latencies.

Communication & Collaboration: Excellent written and verbal communication skills with a proven track record of collaborating effectively with data analysts, developers, and business stakeholders.

Summary
If you're interested in the "Senior Software Developer - ETL" role based in Toronto, we encourage you to apply online at www.randstad.ca.
Only qualified candidates will be contacted for the next steps. We look forward to hearing from you!

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to [email protected] to ensure their ability to fully participate in the interview process.

This posting is for existing and upcoming vacancies.