RQ10949 - Sr. Software Developer - ETL

RQ10949 - Sr. Software Developer - ETL

10-month contract (206 business days) - 2 possible extensions

ONSITE 5 days - 21 College Street

Security Level: CRJMC + Credit Check

Must-haves:

• 5+ years of proven working experience in an ETL role ; strong understanding of ETL principles, including data extraction, transformation, and loading processes; knowledge of 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, including knowledge of pipeline creation, data flows, integration runtimes, triggers, and monitoring.
• Knowledge of 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
• Demonstrated experience with SQL Server, Oracle, Azure SQL Databases
• Python

Scope:

The Office of the Public Guardian and Trustee (OPGT) requires a Senior Software Developer to migrate digital files to an OpenText based document management solution, migrate historical data from legacy systems to a data warehouse/lakehouse, to build data assets in the lakehouse, and to create PowerBI reports.

Assignment Deliverables:

• Data Warehouse Design: analyze business requirements and the data warehouse/lakehouse/golden layer on Microsoft Azure
• Data extraction: Identify/define data to be extracted and migrated to the data warehouse/lakehouse or document storage solution
• Data Integration and ETL: help 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.
• Digital file migration: Identify/define data/files to be extracted and migrated to the OPGT's OpenText based document management solution
• Data Integration and ETL: help develop and automate ETL processes to load digital files from external storage solutions into the enterprise OpenText based document storage solution
• Data Modeling: create logical and physical data models that align with the project's reporting and analytical needs.
• Data Security and Governance: implement appropriate security controls to protect sensitive data within the data warehouse and reports.
• Reporting and Visualization: develop reports, dashboards and visualizations as per reporting MVP. Ensure the quality, accuracy and integrity of reports.
• Performance Optimization: fine-tune the data warehouse and reporting processes to optimize query performance and overall system efficiency.
• Other duties as assigned.

You will also be required to:

• Complete work and achieve milestones within the assigned deadlines.
• Notify the Cluster/Ministry project Manager in writing of any issues or other material concerns related to the Assignment Deliverables, as soon as he/she becomes aware of them
• Submit Deliverables for the Cluster/Ministry approval as they are completed.
• Comply with the Ontario Government and the Cluster/Ministry security procedures and practices
• Comply with the Ontario Government and the Cluster/Ministry architecture/technology standards and best practices
• Comply with the Ontario Government and the Cluster/Ministry Conflict of Interest and Confidentiality Guidelines
• Provide knowledge and skill transfer to a designated Cluster/Ministry staff
• Comply with the Ontario Government I&IT Directive, Operational Policy on the I&IT Project Gateway Process, and other applicable Guidelines, Standards and Procedures.

INCORPORATED RATE RANGE (7.25 billable hours per day)

• $88.63/hr - $106.36/hr Inc.

T4 RATE RANGE (7.25 billable hours per day)

• $70.90/hr - $85.09/hr T4