ETL/Data Integration Developer (32598)

Job Title: Senior Software Developer - ETL

Project: Office of the Public Guardian and Trustee (OPGT) - Dynamics 365 and Data Warehouse Integration

Must-Have Qualifications

• 10+ years of experience in IT software development and testing teams.
  
  
• 5+ years of proven experience integrating various data sources and systems, preferably with Microsoft Azure Cloud technologies. Must include experience with:
  
  
  • Microsoft Dynamics 365 CRM and ERP applications (such as D365 Finance & Operations)
    
    
  • Power Platform tools (PowerApps, Power Automate)
    
    
  • Azure Data Factory and Azure Synapse Analytics
• 2+ years of experience configuring the D365 Customer Engagement security model to meet business requirements.
  
  
• Proficiency in scripting and development using:
  
  
  • Azure PowerShell, Azure CLI, .NET, C#, Power Platform, and Logic Apps
• Experience with:
  
  
  • Azure Data Factory, Azure Synapse Workspaces
    
    
  • CI/CD pipelines and DevOps practices
    
    
  • Strong SQL skills and experience with Azure SQL Databases and Dataverse
    
    
  • Good understanding of Azure storage concepts and technologies

Scope of Work

The OPGT requires a Senior Software Developer - ETL to support the integration of a new Microsoft Dynamics 365 solution and a data warehouse with both internal (OPS) and external systems. This role is part of a cross-functional integrations team composed of internal and vendor staff.

Assignment Deliverables

The Senior Software Developer will be responsible for:

• Designing, developing, and executing test plans, test cases, scripts, and test data based on functional and technical specifications.
  
  
• Creating and maintaining comprehensive testing documentation and traceability from test plans through execution.
  
  
• Performing manual and automated testing to ensure integration functionality and performance.
  
  
• Collaborating with stakeholders to integrate testing processes into the CI/CD pipeline.
  
  
• Supporting analysis, development, and system-level testing activities.
  
  
• Planning and executing system integrations with Microsoft Dynamics 365 Customer Engagement.
  
  
• Verifying configuration, tuning, and optimization of Dynamics 365 applications to support seamless integration.
  
  
• Analyzing and optimizing system integration performance.
  
  
• Providing functional guidance to CRM users through documentation, training sessions, and issue resolution.
  
  
• Developing secure data/file transfer processes using network protocols, sFTP, APIs, Power Platform, and Logic Apps.
  
  
• Creating encryption and decryption processes in an Azure environment.
  
  
• Conducting thorough testing to ensure data accuracy and integrity in all interfaces.
  
  
• Documenting all developed processes and participating in additional assigned duties as needed.

Vendor Personnel Responsibilities

The selected candidate must:

• Complete work and achieve project milestones by specified deadlines.
  
  
• Communicate any issues related to deliverables promptly to the Cluster/Ministry Project Manager.
  
  
• Submit deliverables for approval upon completion.
  
  
• Comply with:
  
  
  • Ontario Government and Cluster/Ministry security procedures
    
    
  • Applicable architecture and technology standards
    
    
  • Conflict of Interest and Confidentiality Guidelines
    
    
  • I&IT Directive, Operational Policy on the I&IT Project Gateway Process, and all relevant standards
• Provide knowledge transfer to designated Cluster/Ministry staff.

Mandatory Experience and Skills

• 10+ years in IT software development and testing
  
  
• 5+ years of integration experience with:
  
  
  • Microsoft Azure technologies
    
    
  • Dynamics 365 CRM and ERP (Customer Engagement and Finance & Operations)
    
    
  • PowerApps, Power Automate, Azure Data Factory, Synapse Analytics
• 2+ years configuring D365 Customer Engagement security models
  
  
• Proficiency in:
  
  
  • Azure PowerShell, Azure CLI
    
    
  • .NET, C#
    
    
  • Power Platform, Logic Apps
    
    
  • Azure Data Factory, Azure Synapse Workspaces
• Strong SQL skills; experience with:
  
  
  • Azure SQL Databases
    
    
  • Dataverse
    
    
  • Azure storage concepts
• Deep knowledge of:
  
  
  • Integration technologies such as Dataverse, Data Entities, APIs
    
    
  • Data pipeline architectures and Azure workflow orchestration tools

Nice-to-Have Qualifications

• Microsoft Azure certifications (e.g., Azure Administrator, Azure Developer, Azure Data Engineer, Azure Database Administrator)

Desired Skills and Experience

• Ability to monitor and troubleshoot integration processes and optimize data processing in Azure
  
  
• Familiarity with version control systems (e.g., Azure Repos) and collaboration tools (e.g., Azure DevOps)
  
  
• Experience with:
  
  
  • SQL Server Management Studio
    
    
  • Azure data management tools
    
    
  • XRM Toolbox
    
    
  • Power Platform (PowerApps, Power Automate)
    
    
  • Dynamics CE and F&O