Software Developer ETL Senior
Job Location:
Monthly Salary:
Experience Required:
Posted on:
Vacancies:
Job Summary
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.
Required Skills:
Mandatory Skills & Experience Cloud & Infrastructure Engineering Proven experience designing deploying and maintaining hybrid infrastructure environments across: Microsoft Azure Amazon Web Services (AWS) Linux-based environments SaaS solutions COTS solutions On-premises systems Strong experience with Windows and Linux server administration including: CentOS Ubuntu CoreOS Experience supporting modern web technology stacks including: LAMP MEAN Drupal Elasticsearch Experience with virtualization platforms storage solutions networking and enterprise infrastructure services. Strong understanding of cloud architecture frameworks technology assessments and cloud solution strategies. Identity & Access Management Experience managing and supporting identity and access controls using: Active Directory Microsoft Entra ID Enterprise IAM solutions Experience implementing authentication authorization and access governance controls. DevOps & CI/CD Automation Strong experience designing building and administering CI/CD pipelines for continuous integration and deployment. Experience with development and collaboration tools including: Azure DevOps JIRA Confluence Maven Jenkins Experience with Infrastructure as Code (IaC) and version-controlled deployments. Strong knowledge of DevOps methodologies automation frameworks and release management best practices. Experience with containerization and orchestration technologies including: Docker Kubernetes AKS / EKS Experience automating operational and compliance-related activities using: PowerShell Bash Python Programming & Scripting Hands-on experience with scripting and programming languages including: Python Bash PHP Java JavaScript Experience with build and configuration management tools including: Git Ansible Chef Puppet API & Integration Experience Experience building and consuming APIs and integration endpoints. Experience integrating cloud platforms enterprise systems and deployment pipelines. Understanding of enterprise integration architectures and service-based deployments. Security Monitoring & Compliance Strong understanding of infrastructure security cloud security and DevOps security best practices including: Least privilege access Secure logging Secrets management Vulnerability remediation Experience with security and monitoring tools including: Radware Dynatrace Splunk Azure Monitor / Log Analytics AWS CloudTrail / CloudWatch ELK Stack / SIEM solutions Experience implementing centralized audit logging and monitoring across enterprise platforms. Ability to support internal and external audits through reporting evidence gathering and log analysis. Experience supporting forensic investigations audit remediation and incident reviews. Familiarity with Government of Ontario I&IT Directives Policies and Information Technology Standards. Release Management & Operational Support Experience coordinating infrastructure and application releases across technical and business teams. Knowledge of change management processes deployment approvals rollback planning and release governance. Experience with release readiness reviews deployment validation and post-release monitoring. Ability to maintain release documentation operational records and audit artifacts. Project Management & Communication Strong project planning coordination and resource management skills. Experience with roadmap planning modernization initiatives and infrastructure investment planning. Strong stakeholder communication and cross-functional collaboration skills. Ability to explain complex technical concepts to business users leadership teams and non-technical stakeholders. Strong documentation reporting presentation and technical writing skills. Mobile Device Management Experience supporting mobile device management for cellular devices and tablets across multiple platforms and operating systems. Desirable Skills Experience supporting Government of Ontario enterprise environments. Experience with enterprise modernization and cloud transformation initiatives. Familiarity with enterprise governance compliance frameworks and audit readiness programs. Experience mentoring and coaching junior DevOps and infrastructure resources. Strong understanding of operational resilience disaster recovery and enterprise monitoring strategies. Additional Information Strong hands-on DevOps cloud infrastructure automation CI/CD security and enterprise release management experience is mandatory for this role.
