Senior Software Developer - ETL

We are seeking an experienced Senior Software Developer - ETL to design, build, and continuously expand enterprise data pipelines, data warehouses, and business intelligence solutions. In this role, you will be responsible for translating technical specifications into scalable backend database architectures and robust Extract, Transform, Load (ETL) routines. Working across cloud platforms (Azure and AWS) and big data ecosystems, you will design daily and initial data ingestion pipelines, construct complex SQL queries, optimize performance across structured and semi-structured repositories, and build source-to-target data mappings to support business analytics and decision-making.

Location: Toronto, ON (Fully Onsite – 5 days/week required)

Duration: 9-month contract.

Advantages
Multi-Cloud Tech Stack: Gain hands-on exposure across both Azure (Data Factory, Data Lake) and AWS (Glue, Aurora, OpenSearch) cloud environments.

Big Data & Analytics Focus: Drive large-scale data engineering using Databricks, Data Lake architectures, and Power BI visualization tools.

End-to-End Data Pipeline Ownership: Full lifecycle control spanning initial requirements gathering and dimensional modeling to pipeline deployment and performance tuning.

Dedicated Onsite Collaboration: Collaborate directly alongside senior data architects, software engineers, and analytics leads in a focused 5-day per week workspace.

Responsibilities
ETL Pipeline Engineering: Design, implement, and maintain scalable daily and initial ETL data pipelines across diverse data repositories, including relational databases, multi-dimensional stores, and semi-structured files.

Cloud & Databricks Data Architecture: Develop and optimize cloud-native data processing solutions using Azure (Data Factory, Azure SQL, Data Lake), AWS (Aurora, Glue, OpenSearch), and Databricks.

Database Modeling & SQL Optimization: Perform dimensional data modeling for data marts and enterprise data warehouses, writing complex SQL queries, stored procedures, and execution plans with a focus on performance tuning.

Data Integration & Cleansing: Implement data cleansing, validation, and transformation logic to ensure high data quality, source traceability, and accuracy for downstream analytics and Power BI dashboards.

Orchestration & Dependency Logic: Build, configure, and troubleshoot automated job schedules, execution dependencies, and pipeline orchestration logic.

Documentation & Mapping: Author comprehensive technical documentation, including ETL source-to-target mapping specifications, data model diagrams, pipeline architecture blueprints, and detailed design documents.

Source Control & DevOps: Utilize Git and source control strategies to manage code repositories, release scripts, and pipeline deployments across development, testing, and production environments.

Cross-Functional Collaboration: Partner with business analysts, data architects, and stakeholders to elicit data requirements, investigate pipeline anomalies, and present data-driven recommendations.

Qualifications
Microsoft Cloud & Analytics Stack: Hands-on experience developing data solutions with Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BI (Strictly Required).

AWS Cloud Suite & Databricks: Demonstrated experience with Databricks Platform and AWS technologies including Amazon Aurora, Relational Database Search, AWS Glue, and OpenSearch (Strictly Required).

ETL Development & Dependency Orchestration: Proven experience developing initial and daily ETL pipelines, managing schedule/dependency logic across structured and semi-structured data stores (Strictly Required).

Data Warehousing & SQL Tuning: Extensive background in dimensional data modeling for data marts/warehouses, complex SQL query development, and database performance tuning (Strictly Required).

Technical Documentation & Source Control: Experience producing ETL source-to-target mappings, data model diagrams, and utilizing Git version control strategies (Strictly Required).

Experience designing visual dashboards, key performance indicators (KPIs), and scheduled/ad-hoc canned reports in Power BI.

Hands-on scripting and application coding skills using C# (APIs, Functions) and PowerShell.

Familiarity with web accessibility standards (WCAG 2.1 Level AA / AODA compliance).

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.