RQ11258 Sr. Software Developer ETL

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:

1. Designing and developing scalable Medallion Data Lakehouse architectures.
2. Expertise in data ingestion transformation and curation using Delta Lake and Databricks.
3. Building automating and optimizing complex ETL/ELT pipelines using Azure Data Factory (ADF) Databricks (PySpark SQL Delta Live Tables) and dbt.
4. Strong knowledge of relational (SQL Server Synapse PostgreSQL) and dimensional modeling.
5. CI/CD automation (Azure DevOps GitHub Actions) for data pipelines.
6. 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