We are seeking an expert Senior Software Developer - ETL to lead critical data migration and engineering tracks for the Office of the Public Guardian and Trustee (OPGT) Modernization program. In this role, you will be responsible for migrating historical data from legacy systems and streaming data from core ERP/CRM environments into a modern Microsoft Azure data lakehouse. You will design automated data pipelines across multi-layered data structures, configure secure digital file migrations into an enterprise OpenText document management solution, and build analytical business intelligence assets using Power BI.
Location: Toronto, ON (Onsite, 7.25 hours per day between 8:00 AM and 5:00 PM)
Duration: 10-month contract (aligned with VOR framework timelines)
AdvantagesEnterprise Migration Ownership: Command full technical delivery over a highly visible migration portfolio spanning big data pipelines and specialized enterprise document storage (OpenText).
Modern Architecture Stack: Broaden your cloud profile by manipulating raw data into refined, analytics-ready multi-tier data structures (Bronze/Silver/Gold) inside Azure Synapse.
Long-Term Continuity: Benefit from a stable 10-month contract framework with potential extensions structured through a multi-year VOR master service agreement.
Stable Schedule: Operate under a reliable, standard daytime corporate schedule within an elite public sector-aligned data team based in downtown Toronto.
ResponsibilitiesData Lakehouse Engineering: Analyze business requirements to design and construct robust data assets within an Azure data lakehouse framework across multi-layered data stores (Bronze, Silver, and Golden layers).
Pipeline Automation & Orchestration: Build, automate, and orchestrate scalable enterprise ETL pipelines within Azure Synapse Workspaces utilizing triggers, data flows, integration runtimes, and performance monitors.
Dynamics 365 Data Integration: Extract, transform, and ingest structured data from Dynamics 365 Customer Engagement (CE) and Dynamics 365 Finance & Operations (F&O) using Dataverse, Common Data Service (CDS), Data Entities, and native APIs.
OpenText Document Migration: Define and implement automated ETL workflows to safely extract and migrate high-sensitivity digital files from legacy systems into an enterprise OpenText document management solution.
Advanced Data Modeling: Design relational, physical, and logical data models that align with the organization's Minimum Viable Product (MVP) analytical and reporting needs.
Query Performance Optimization: Write complex T-SQL/PL-SQL scripts, profile data streams, and perform deep database tuning to optimize query execution and overall lakehouse processing efficiency.
Data Security & Governance: Implement strict data masking, column-level security controls, and encryption mechanisms to safeguard sensitive data within Azure SQL databases, Data Lakes, and Power BI dashboards.
DevOps & CI/CD Deployment: Manage analytics source code within Azure Repos, log project deliverables in Azure DevOps, and construct continuous integration/continuous deployment (CI/CD) release pipelines for Synapse workspaces.
Executive Visualization & Reporting: Develop precise data dashboards and Power BI reports, verifying data accuracy, profiling integrity, and compliance with public-sector architecture standards.
QualificationsCore ETL Seniority: 5+ years of proven professional experience in a dedicated ETL Developer role, possessing an advanced grasp of ingestion design patterns, data cleansing, enrichment, and normalization.
Azure Data Stack Expertise: High proficiency navigating Azure Synapse Workspaces, Azure SQL Databases, Blob Storage, Key Vaults, and Azure Data Lake Storage (ADLS).
Dynamics Ecosystem Literacy: Demonstrated hands-on experience extracting and manipulating backend data structures mapped out of Dynamics 365 CE & F&O environments.
Scripting & Database Languages: Expert-level mastery of data manipulation languages (T-SQL/PL-SQL) alongside practical programming skills in Python and cloud automation via PowerShell or Azure CLI.
Tooling Proficiency: Extensive experience using SQL Server Management Studio (SSMS), XRM Toolbox, and enterprise data modeling suites.
Asset Certifications: Valid Microsoft credentials such as Azure Data Engineer Associate (DP-203), Azure Database Administrator Associate, or Azure Fundamentals are highly desirable.
SummaryIf you're interested in the Senior Software Developer - ETL role based in Toronto, we encourage you to apply online at www.randstad.ca. Only qualified candidates will be contacted for the next steps. We look forward to hearing from you!
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to
accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
){kind=logo}
