Job Description

Term: December 15, 2025- August 13, 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 & Delivery: Lead the design and implementation of robust ETL solutions using Azure Synapse and related technologies. Translate business needs into scalable data workflows, ensuring seamless integration across Dynamics 365, Dataverse, and external systems.
Prioritization: Manage and prioritize data tasks effectively, focusing on high-impact deliverables such as data transformation, cleansing, enrichment, and normalization. Ensure timely delivery of ETL pipelines aligned with business goals and compliance standards.
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 maintain data quality, security, and governance, especially when handling sensitive data.
Technical Expertise: Apply strong SQL and T-SQL skills for data manipulation and performance tuning. Utilize Azure SQL Databases, Dataverse, and storage technologies to optimize data architecture. Leverage tools like SQL Server Management Studio and XRM Toolbox for efficient data management.
Must haves:
5+ years of proven working experience in an ETL role; strong understanding of ETL principles, including data extraction, transformation, and loading processes.
Strong SQL skills and experience working with Azure SQL Databases and Dataverse.
Knowledge of Microsoft Dynamics 365 Customer Engagement (CE).

Skills Required