Job Description

Term: December 15, 2025- June 23, 2026
Location: Onsite/Hybrid, 595 Bay Street, Toronto, ON
Our client is seeking a Senior ETL - Software Developer
Key Deliverables for Senior ETL - Software Developer
Product Requirements: Translate complex business needs into scalable ETL solutions using Azure Data Factory, Synapse, and related technologies. Design data pipelines that support ingestion, transformation, and movement across cloud and on-premises systems, with a focus on Dynamics 365 integrations via Dataverse, CDS, and APIs.
Product Delivery: Build and maintain robust ETL workflows, ensuring high data quality through profiling, validation, and error handling. Apply advanced transformation techniques including cleansing, enrichment, and normalization. Monitor and troubleshoot pipelines, optimize query performance, and implement efficient data processing strategies.
Prioritization: Manage and prioritize ETL development tasks based on business impact, compliance needs, and performance goals. Ensure timely delivery of data solutions aligned with governance standards and privacy regulations.
Collaboration: Work closely with cross-functional teams using Azure DevOps and version control tools to manage code, track changes, and support CI/CD processes. Collaborate with stakeholders to resolve incidents, recommend enhancements, and support training and documentation efforts.
Must-haves:
5+ years of proven working experience in an ETL role; strong understanding of ETL principles, including data extraction, transformation, and loading processes; knowledge of common ETL design patterns. Understanding of data pipeline architectures, Azure workflow orchestration tools, and concepts related to data ingestion, transformation, and movement.
Proficiency in Azure Data Factory, Azure Synapse workspaces, PolyBase, including knowledge of pipeline creation, data flows, integration runtimes, triggers, and monitoring.
Knowledge of integration technologies commonly used with Dynamics, such as DataVerse / Common Data Service (CDS), Data Entities, and APIs.

Skills Required