Software Developer – ETL – Senior

Job Description

  • Contractor
  • Anywhere

About the job
Job Role: Software Developer – ETL – Senior

Location : Toronto, ON/Onsite

Position Type : Contract Role

 

5 Days Onsite

 

Start Date

2026-07-02

End Date

2027-03-31

 

Ideal Candidate Rate: CAD 90-95/Hr on Incorporated (Depending on the experience)

 

Must Have:

Develop ETL scripts, design data-driven logic and conduct unit testing.
Designing and developing scalable Medallion Data Lakehouse architectures.
Building, automating, and optimizing complex ETL/ELT pipelines using Azure Data Factory (ADF), Databricks (PySpark, SQL, Delta Live Tables), and dbt.
Expertise in data ingestion, transformation, and curation using Delta Lake and Databricks.
10+ years of experience with technical systems specifications and translating them into working, tested applications for large, complex, mission critical applications.
10+ years of experience in technical analysis, program code, detailed programming and reports specifications, program design, writing and /or generating code, and conducting unit tests.
Design technical solutions for data acquisition and storage into our centralized data repository.
Experience integrating structured and unstructured data sources into star/snowflake schemas.
Implementing orchestrated workflows and job scheduling in Azure environments.
Strong knowledge of relational (SQL Server, Synapse, PostgreSQL) and dimensional modeling.
Advanced SQL query optimization, indexing, partitioning, and data replication strategies.
Investigate and resolve incidents and identify whether the problem is caused by the data loading code or is due to bad data received from the data provider.

 

Note: AI-enabled tools may be used to sort applications based on job-related criteria. All AI generated results are vetted by our team and the decision of which candidates move forward is always made by a human.

Requirements added by the job poster

• 5+ years of work experience with SQL

• 5+ years of work experience with Microsoft Azure

• 7+ years of work experience with Extract, Transform, Load (ETL)