Job Description
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 storag...