OPGT MOD 2 - 2xSoft. Dev. ETL(Snr) -206+175 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: 0527256

Project Overview

The OPGT Modernization initiative is enhancing a cloud-based, fully integrated Microsoft Dynamics 365 solution that replaced end-of-life case, financial, and document management systems. Following a Phase 1 MVP launch, Phase 2 will deliver additional workflows, automation, and new features, including data and document migrations and expanded reporting 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 into the data warehouse/lakehouse (bronze/silver/golden layers) and integrate data into the data warehouse
Identify and define digital 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 analytical 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 government security procedures and practices
Comply with 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 experience in an ETL role with strong understanding of ETL principles (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 Dynamics integration technologies (Dataverse / Common Data Service (CDS), Data Entities, APIs)
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 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 Python and Azure-specific scripting using PowerShell or Azure CLI
Expertise with T-SQL, PL/SQL, data definition languages, physical database design, data modelling, and query performance analysis & tuning
Familiarity with Azure Repos and Azure DevOps
Experience with CI/CD processes around DevOps, data workflows, and Synapse workspaces
Experience with SQL Server Management Studio, Azure data management tools, XRM toolbox, and 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

APIs, Application Insights, Azure Blob Storage, Azure CLI, Azure Data Lake, Azure DevOps, Azure Key Vault, Azure Repos, Azure SQL Database, Azure Synapse, CI/CD, Dataverse, Data Entities, Data modeling, Data warehouse, Dynamics 365 CE, Dynamics 365 F&O, ETL, Microsoft Azure, OpenText, Oracle, Power BI, PowerShell, Python, SQL Server, SQL Server Management Studio, Synapse Studio, T-SQL, 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.