OPGT MOD 2 - 1xSoft. Dev. ETL(Snr) -206+291 Days [Reporting]

← Back to Jobs

Job Details

Closing Date: Friday, May 29, 2026 at 12:00 p.m.

Location: 595 Bay Street, Toronto, Ontario, Canada

Client: Ministry of Public and Business Service Delivery and Procurement

Department: Justice Technology Services

Start Date: 2026-06-01

End Date: 2027-03-31

Work Arrangement: Onsite

Job Type: Contract

Job ID: 0527257

Project Overview

The OPGT Modernization initiative is an IT program to support continued service delivery for Ontarians who cannot care for themselves and have no one able to act on their behalf. Phase 1 delivered a cloud-based, fully integrated Microsoft Dynamics 365 solution replacing end-of-life case, financial, and document management systems as an MVP. Phase 2 will enhance the MVP by adding workflows, automation, and new features and functionality, including improved data and document capabilities.

Key Responsibilities

Analyze business requirements and design the data warehouse/lakehouse/golden layer on Microsoft Azure
Identify and define data to be extracted and migrated to the data warehouse/lakehouse or document storage solution
Develop and automate ETL processes to load data from external solutions into the data warehouse/lakehouse (bronze/silver/golden layers) and integrate data into the data warehouse
Identify and define digital data/files to be extracted and migrated to the OpenText-based document management solution
Develop and automate ETL processes to load digital files from external storage solutions into the OpenText-based document storage solution
Create logical and physical data models aligned with reporting and analytics needs
Implement security controls to protect sensitive data within the data warehouse and reports
Develop reports, dashboards, and visualizations and ensure report quality, accuracy, and integrity
Fine-tune the data warehouse and reporting processes to optimize query performance and overall system efficiency
Complete work and achieve milestones within assigned deadlines
Notify the project manager in writing of issues or material concerns related to deliverables
Submit deliverables for approval as they are completed
Comply with Ontario Government and ministry security procedures and practices
Comply with Ontario Government and ministry architecture/technology standards and best practices
Comply with conflict of interest and confidentiality guidelines
Other duties as assigned

Qualifications & Requirements

REQUIRED

Must be able to work onsite
Proven working experience in an ETL role; strong understanding of ETL principles (data extraction, transformation, loading) and 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 Synapse workspaces (pipeline creation, data flows, integration runtimes, triggers, monitoring)
Knowledge of integration technologies used with Dynamics (DataVerse / Common Data Service (CDS), Data Entities, APIs)
Proven experience working with data from Dynamics 365 CE and Dynamics 365 F&O as an ETL developer

NICE TO HAVE

Experience integrating various data sources and systems (on-premises and cloud) using Azure ETL services or other ETL tools
Expertise in data transformation techniques (data cleansing, aggregation, enrichment, normalization) using Azure cloud technologies
Understanding of data quality management practices (data profiling, data validation, error handling) within ETL processes
Understanding of data governance principles, data privacy regulations, and experience working with high-sensitivity data; knowledge of best practices for data security and compliance in Azure
Ability to monitor and troubleshoot ETL processes, optimize query performance, and implement efficient data processing techniques in Azure
Strong SQL skills and experience with Azure SQL Databases and Dataverse; understanding of Azure storage concepts and technologies
Proficiency in scripting languages like Python and Azure-specific scripting using PowerShell or Azure CLI
Expertise with data manipulation languages (T-SQL, PL/SQL), data definition languages, physical database design, data modelling, query performance analysis and tuning
Familiarity with version control and collaboration tools (Azure Repos, Azure DevOps)
Experience with CI/CD processes around DevOps, data workflows, Synapse workspaces
Experience with SQL Server Management Studio, Azure data management tools, XRM toolbox, data modeling tools
Azure cloud certifications (Azure Fundamentals, Azure Data Engineer Associate, Azure Database Administrator Associate)

EVALUATION CRITERIA

ETL - 30 points

Demonstrated experience with ETL development, data pipelines, workflow orchestration and data ingestion, transformation, and movement
Demonstrated experience in integrating various data sources and systems, both on-premises and in the cloud, using Azure ETL services or other ETL tools
Demonstrated experience working with Azure Synapse workspaces, including knowledge of pipeline creation, data flows, integration runtimes, triggers, and monitoring.
Demonstrated experience with data manipulation languages (T-SQL, PL/SQL), data definition languages, query performance analysis & tuning
Demonstrated experience with SQL Server, Oracle, Azure SQL Databases
Demonstrated experience with data modeling tools
Demonstrated experience in scripting languages like Python and with Azure-specific scripting using PowerShell or Azure CLI.
Experience with software development lifecycle
Experience with data modeling, physical database design, data flow diagrams

Azure Platform - 20 points

Demonstrated experience with Azure Synapse Workspaces
Demonstrated experience Azure data management tools, DevOps, Synapse Studio
Experience in Azure resource configuration and administration such as Azure Data Lake, Blob Storage, Key Vault, Application Insight resources, resource groups and subscriptions.
Familiar with Azure cloud platform
Azure cloud certifications

Dynamics 365 CE & FO - 30 points

Demonstrated experience working with integration technologies commonly used with Dynamics, such as DataVerse / Common Data Service (CDS), Data Entities, and APIs.
Proven experience working with data from Dynamics 365 CE and Dynamics 365 F&O as an ETL developer

DevOps and CI/CD - 20 points

Demonstrated experience with continuous integration/continuous deployment (CI/CD) tools and processes around DevOps, data workflows, Synapse workspaces.

Key Skills & Competencies

API integration, Application Insights, Azure CLI, Azure Data Lake, Azure DevOps, Azure Key Vault, Azure Repos, Azure SQL Database, Azure Synapse, Azure Synapse Studio, Azure workflows, Blob Storage, CI/CD, Common Data Service, Data Entities, Dataverse, Data modeling, Data warehouse, ETL, Integration runtimes, Microsoft Azure, Microsoft Dynamics 365, OpenText, Oracle, Physical database design, PL/SQL, Power BI, PowerShell, Python, Query tuning, SQL, SQL Server, SQL Server Management Studio, Synapse pipelines, T-SQL, Workflow orchestration, XRM Toolbox

Applications for this position will be accepted until Friday, May 29, 2026 at 12:00 p.m..

If you meet the requirements for this role, please apply now.

Apply for This Position

Click "Apply." If no email opens, check your pop-up blocker or email your resume directly to resume@govtechtalentsolutions.ca, including the Requisition Number and Job Title in the subject line.