RQ11713 - Software Developer - ETL - Senior I Toronto - Onsite I 1+year

Analyst Technical Solutions - 92 Jobs

Toronto, ON

Apply Now

Posted today

Job Details:

Full-time

Executive

RQ11713 - Software Developer - ETL - Senior

Organization: Central Agencies Cluster

Ministry: Ministry of Treasury Board Secretariat

Location: Toronto, ON Onsite

Pay rate: 95-101/hr incorp

Title

Software Developer - ETL

Description

Role Overview

The Senior ETL Developer will design, build, and maintain scalable database backends, data pipelines, and Extract, Transform, Load (ETL) solutions supporting Enterprise Data Warehouse and Business Intelligence platforms.

Key Responsibilities

• Pipeline Development: Design, build, and maintain initial and incremental (daily) ETL/ELT pipelines across structured and semi-structured datasets.

• Architecture & Modeling: Implement scalable data architectures, dimensional models, data marts, and warehouse repositories.

• Code & Automation: Write modular code, manage dependency scheduling logic, and build data cleansing routines.

• Performance Tuning: Optimize complex SQL queries and conduct database administration tasks.

• Documentation: Produce source-to-target mapping documents, data models, and detailed technical specifications.

• Support & Collaboration: Troubleshoot production pipeline defects, participate in design walkthroughs, and translate business requirements into technical deliverables.

Qualifications & Requirements

Mandatory Technical Skills

• Microsoft Azure Stack: Azure Data Factory (ADF), Azure SQL Database, Azure Data Lake Storage (ADLS), and Power BI.

• Cloud & Big Data Platforms: Databricks, AWS services (Amazon Aurora, RDS, AWS Glue, OpenSearch).

• ETL & Data Engineering: Advanced data extraction, transformation, data modeling, cleansing, and pipeline scheduling.

• Databases & Querying: Relational and dimensional databases, advanced SQL development, and query optimization.

• Source Control & SDLC: Full lifecycle development experience utilizing Git and standard branching strategies.

Nice-to-Have Skills

• Application Development: Experience with C#, REST APIs, Azure Functions, or microservices.

• Scripting: Automation using PowerShell or similar scripting languages.

• Reporting: Designing ad-hoc reports and executive KPI dashboards.

• Compliance: Working knowledge of the Accessibility for Ontarians with Disabilities Act (AODA) standards.

Evaluation Criteria

CategoryCriteria BreakdownWeightCore Technical Skills• Azure stack (ADF, Azure SQL, ADLS, Power BI)
• AWS ecosystem (Aurora, RDS, Glue, OpenSearch)
• End-to-end ETL design, scheduling, cleansing, and analytics
• Data warehousing, modeling, and administration
• Complex SQL optimization and performance tuning
• Source-to-target mapping and technical documentation50%Secondary Technical Skills• Git source control strategies
• End-to-end SDLC best practices
• Application development (C#, APIs, Functions)
• PowerShell scripting and automation
• Dashboard and KPI report design35%Communication Skills• Requirement elicitation, stakeholder management, and validation
• Clear written documentation and technical communication10%Standards & Compliance• Understanding of AODA standards and government IT guidelines5%Total Score100%

#Information Technology jobs

Apply Now

Save

Share This Job:

Frequently Asked Questions

Where is this ETL Senior Developer role located and is it on-site or remote?

This is an on-site role based in Toronto, ON.

What is the pay rate for this Senior ETL Developer position?

The pay rate listed is $95.00–$101.00 per hour, incorp.

What are the main responsibilities of the Senior ETL Developer?

Responsibilities include designing, building, and maintaining ETL/ELT pipelines, implementing scalable data architectures, writing modular code and data cleansing routines, tuning performance, and producing data models and technical documentation.

What technical skills are required for this Senior ETL Developer role?

Mandatory skills include Azure Data Factory, Azure SQL Database, ADLS, Power BI, Databricks, AWS Glue, Aurora, RDS, OpenSearch, advanced SQL, data modeling, and Git/SO lifecycle development.

Are there any nice-to-have skills that could strengthen a candidate’s application?

Nice-to-have skills include experience with C#, REST APIs, Azure Functions, microservices, PowerShell scripting, and designing ad-hoc reports or KPI dashboards.

What evaluation criteria will be used to assess candidates for this role?

Evaluation emphasizes end-to-end ETL design, data warehousing and modeling, SQL optimization, Git/SRC control, SDLC practices, and communication skills in documentation and stakeholder interaction.