Senior Software Developer - ETL

The Client is seeking a Senior Software Developer – ETL to lead the design and development of robust data integration and transformation solutions using Azure cloud technologies. This role supports large-scale data initiatives critical to the modernization of public services.

Job Title: Senior Software Developer – ETL

Job Location: Toronto, ON/Hybrid

Job Description

Must-Haves:

·         5+ years of hands-on ETL experience with strong knowledge of ETL design patterns, data pipelines, and Azure orchestration tools

·         Proficiency in Azure Data Factory, Synapse, PolyBase, SQL, and scripting with Python, PowerShell, or Azure CLI

·         Experience with Dynamics integration technologies (DataVerse/CDS, Data Entities, APIs)

·         Strong background in data transformation, data quality, and governance practices

·         Skilled in CI/CD processes, DevOps, version control, and data modeling tools like ERWIN

Key Responsibilities:

·         Design, develop, and optimize ETL pipelines across hybrid data environments

·         Integrate diverse data sources using Azure services and ensure data security and compliance

·         Monitor and troubleshoot ETL jobs, ensuring high data quality and performance

·         Collaborate with teams using Azure DevOps tools for agile development and deployment

·         Support data modeling, query tuning, and architecture alignment with enterprise standards