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

📌 Source Code (Toronto)
🏢 CareerBeacon
📍 Toronto