About this role

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:

· 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

Sr. Software Developer - ETL