RQ11258 - Sr. Software Developer - ETL

Source Code - 142 Jobs

Toronto, ON

Apply Now

Posted today

Job Details:

$70.82 - $106.25 / hour

Full-time

Experienced

RQ11258 - Sr. Software Developer - ETL

9-month contract (188 business days) - possible extension

ONSITE 5 days - 5700 Yonge Street

Security Level: CRJMC

Must-haves:

10+ years of experience in:

Designing and developing scalable Medallion Data Lakehouse architectures.
Expertise in data ingestion, transformation, and curation using Delta Lake and Databricks.
Building, automating, and optimizing complex ETL/ELT pipelines using Azure Data Factory (ADF), Databricks (PySpark, SQL, Delta Live Tables), and dbt.
Strong knowledge of relational (SQL Server, Synapse, PostgreSQL) and dimensional modeling.
CI/CD automation (Azure DevOps, GitHub Actions) for data pipelines.
Power BI

Nice-to-have:

Public Sector Enterprise Architecture artifacts (or similar)

Description:

· Design technical solutions for data acquisition and storage into our centralized data repository.

· Develop ELT scripts, design data-driven logic and conduct unit testing.

· Conduct database modeling and design as to improve overall performance.

· Produce design artifacts and documentation which will allow future support of the implemented solutions.

· 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.

· Execute service requests related to routine and ad-hoc data loads.

· Provide the data quality check and report on the data quality issue.

AI Disclaimer: Source Code may use artificial intelligence (AI) tools to assist in certain aspects of its recruiting and business operations.

Note: The higher end of the range is intended for absolutely exceptional candidates who meet all must-have requirements and most or all nice-to-have qualifications. The client will evaluate candidates based on both rate expectations and overall skill set when shortlisting.

INCORPORATED RATE RANGE (7.25 billable hours per day)

$88.52/hr - $106.25/hr Inc.

T4 RATE RANGE (7.25 billable hours per day)

$70.82/hr - $85.00/hr T4

#Information Technology jobs

Apply Now

Save

Share This Job:

Frequently Asked Questions

What is the contract duration and work location for this Sr. Software Developer - ETL role?

The position is a 9-month contract (188 business days) with on-site work five days a week at 5700 Yonge Street, Toronto, ON.

What are the must-have technical skills for this ETL Sr. Developer role?

Must-haves include designing scalable Medallion Data Lakehouse architectures, ETL/ELT pipelines with Azure Data Factory, Databricks (PySpark, SQL, Delta Live Tables), dbt, Delta Lake, relational modeling (SQL Server, Synapse, PostgreSQL), CI/CD automation (Azure DevOps, GitHub Actions), and Power BI.

What tools and technologies will I work with for data ingestion and transformation?

You will work with Delta Lake and Databricks for ingestion, transformation, and curation, and build ETL/ELT pipelines using Azure Data Factory, Databricks, and dbt.

Is there mention of salary or hourly rate for this role?

Yes, the incorporated rate range is $88.52/hr–$106.25/hr and the T4 rate range is $70.82/hr–$85.00/hr, with the higher end reserved for exceptional candidates.

What business intelligence tool is specified for this job?

Power BI is listed as part of the required skills.

What kind of responsibilities will I have in this role?

Responsibilities include designing data acquisition and storage solutions, developing and testing ELT scripts, performing database modeling, producing design artifacts, investigating incidents, executing data loads, and providing data quality checks and reports.

Where is this job posted and who is the employer?

The posting is for Source Code, located in Toronto, ON, and the role is listed as Full-time with a 9-month contract.