Software Developer - ETL - Senior

Senior Software Developer / ETL Developer

Client: Justice Technology Services

Location: 595 Bay Street Onsite

Job Description

The Office of the Public Guardian and Trustee (OPGT) is seeking a Senior Software Developer with strong expertise in ETL development, Azure data platforms, Dynamics 365 integrations, and enterprise data migration initiatives. The successful candidate will play a key role in migrating digital files to an OpenText-based document management solution, building scalable Azure-based data warehouse/lakehouse solutions, and developing enterprise reporting and analytics capabilities using Power BI.

This role requires hands-on experience with Azure Synapse Analytics, Dynamics 365 CE & F&O integrations, data pipelines, ETL frameworks, and modern DevOps practices. The consultant will work closely with project managers, architects, business analysts, and technical teams to support data migration, transformation, governance, and reporting activities within a highly secure government environment.

Requirements

Key Responsibilities

• Design and implement scalable Azure-based data warehouse/lakehouse solutions, including bronze, silver, and golden data layers.
  
• Develop and maintain ETL pipelines for extracting, transforming, cleansing, and loading data from multiple enterprise systems into Azure data platforms.
  
• Migrate historical data from legacy applications into Azure Synapse and enterprise data repositories.
  
• Support migration of digital files and metadata into OpenText document management solutions.
  
• Develop and automate data ingestion workflows using Azure Synapse Pipelines, Data Flows, Integration Runtimes, and orchestration tools.
  
• Integrate Dynamics 365 CE and Dynamics 365 Finance & Operations data using Dataverse/CDS, Data Entities, APIs, and Azure integration services.
  
• Create logical and physical data models aligned with reporting and analytical requirements.
  
• Develop Power BI dashboards, reports, and visualizations while ensuring data accuracy, quality, and integrity.
  
• Perform SQL query optimization, performance tuning, and troubleshooting for ETL and reporting workloads.
  
• Implement data governance, security, privacy, and compliance controls for sensitive enterprise data.
  
• Utilize Azure DevOps, Azure Repos, and CI/CD pipelines to manage deployments and data workflows.
  
• Develop scripts using Python, PowerShell, or Azure CLI for automation and operational support.
  
• Collaborate with cross-functional teams and provide technical documentation, knowledge transfer, and operational support throughout the project lifecycle.
  
• Ensure compliance with Ontario Government standards, security policies, architecture guidelines, and project delivery methodologies.
  

Benefits

Required Skills & Experience

• 5+ years of hands-on ETL development experience with strong understanding of data extraction, transformation, loading, and workflow orchestration.
  
• Strong expertise with Azure Synapse Analytics, including pipelines, data flows, triggers, monitoring, and integration runtimes.
  
• Experience with Azure SQL Database, SQL Server, Oracle, Azure Data Lake, Blob Storage, Key Vault, and related Azure data services.
  
• Proven experience integrating Dynamics 365 CE and Dynamics 365 F&O data using Dataverse/CDS, APIs, and Data Entities.
  
• Advanced SQL development skills including T-SQL, PL/SQL, query optimization, and database performance tuning.
  
• Experience with data modeling, physical database design, and enterprise data architecture.
  
• Proficiency in Python scripting and Azure automation using PowerShell or Azure CLI.
  
• Experience with Azure DevOps, version control systems, and CI/CD implementation for data solutions.
  
• Knowledge of data governance, data quality management, privacy regulations, and security best practices.
  
• Experience with Power BI reporting and dashboard development.
  
• Familiarity with OpenText document management solutions is considered an asset.
  

Nice to Have

• Azure certifications such as:
  
• Microsoft Certified: Azure Fundamentals
  
• Azure Data Engineer Associate
  
• Azure Database Administrator Associate
  
• Experience working within public sector or government environments.
  
• Experience with XRM Toolbox, Synapse Studio, and Azure data management tools.
  

Work Environment

• Assignment Type: Onsite
  
• Work Schedule: 7.25 hours/day between 8:00 AM – 5:00 PM, Monday to Friday.
  
• Candidate must comply with Ontario Government security, confidentiality, and project governance standards.