HM Note: This onsite role is three (3) days in office
Scope
The Office of the Public Guardian and Trustee (OPGT) requires a Senior Software Developer â ETL to perform activities for interfacing the new Dynamics 365 solution and data warehouse with internal (OPS) and external systems as a member of the integrations team made up of internal and vendor staff.
Assignment Deliverables
As a member of the integrations team, the person will be responsible for integrating and developing the new Dynamics 365 solution as a member of the integrations & development team made up of internal and vendor staff. A high-level list of deliverables for the integrations team follows:
Deliverables include:
-
Designing, developing, and implementing custom solutions within the Dynamics 365 platform& Dynamics 365 CRM applications using C#, JavaScript, and HTML
-
Designing and implementing integrations with other systems using Power Platform and other integration tools.
-
Verifying the configuration, tuning, and optimization of Dynamics 365 applications to ensure seamless integration with other external/internal enterprise systems.
-
Analyzing and optimizing the performance of the system integration.
-
Providing functional guidance to CRM users through documentation, training sessions, and the resolution of system issues.
-
Performing data validation tasks such as to validate the extracted/imported data to ensure its accuracy, completeness, and consistency. Help with identifying and resolving data quality issues.
-
Executing processes for transferring data and files between internal and external environments via network, sFTP, APIs, Microsoft Power Platform, Logic Apps.
-
Executing processes for encryption and decryption in an Azure environment.
-
Performing quality assurance related tasks such as to conduct thorough testing to verify the accuracy and integrity of the data manipulated in interfaces. Define test cases and address any issues or discrepancies that arise during the testing phase.
-
Other duties as assigned.
The Vendor's Personnel 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; and comply with the Ontario Government I&IT Directive, Operational Policy on the I&IT Project Gateway Process, and other applicable Guidelines, Standards and Procedures.
Skills
Experience and Skill Set Requirements
Experience and Skillset Requirements
Mandatory Requirements
-
5+ years working experience of Microsoft (MS) Dynamics 365 Customer Relationship Management (CRM) and Enterprise Resource Planning (ERP) applications such as Customer Engagement and Finance & Operations, PowerApps, Power Automate and Power BI, Data Factory and Data Pipelines.
-
5+ years of programming language experience using C#, Power FX, JavaScript, and HTML to:
-
Create and manage Dynamics 365 CRM online solutions.
-
Customize Dynamics 365 CRM forms.
-
Implement Dynamics 365 CRM views and visualizations.
-
Manage Dynamics 365 CRM entities.
-
Configure Dynamics 365 CRM field customizations.
-
Implement Dynamics 365 CRM entity relationships.
-
Create business process flows.
-
Proficiency in Azure-specific scripting using PowerShell or Azure CLI, .NET, C#, Power Platform, Logic Apps
-
Proven working experience in integrating various data sources and systems, both on-premises and in the cloud, using Azure ETL services or other ETL tools.
-
Proficiency in Azure Data Factory, Azure Synapse workspaces
-
Expert proficiency with data manipulation languages (T-SQL, PL/SQL), data definition languages, physical database design, data modeling, query performance analysis & tuning
Nice-to-Have Requirements
-
Azure cloud certifications (e.g., Azure Administrator, Azure Developer, Azure Data Engineer, Azure Database Administrator)
-
Knowledge of integration technologies commonly used with Dynamics, such as DataVerse, Data Entities, and APIs.
-
Experience with continuous integration/continuous deployment (CI/CD) processes around DevOps, data workflows, Synapse workspaces.
Desired Skills and Experience
-
5+ years programming experience related to MS Dynamics 365 applications, PowerApps, Power Automate and Power BI, Data Factory and Data Pipelines.
-
5+ years' experience using Microsoft Dynamics and Power Platform (including PowerApps, Power BI, and Power Automate) to enhance business functionality and overall performance.
-
In-depth understanding of CI/CD pipeline and enterprise DevSecOps implementation
-
Well versed in development with Model-Driven and Canvas Apps
-
Proven working experience in integrating various data sources and systems, both on-premises and in the cloud, using Azure ETL services or other ETL tools
-
In-depth knowledge of integration technologies commonly used with Dynamics, such as DataVerse, Data Entities, and APIs.
-
Expertise in data transformation techniques, aggregation, enrichment, and normalization using Azure cloud technologies.
-
Strong SQL skills and experience working with Azure SQL Databases and Dataverse; good understanding of Azure storage concepts and technologies.
-
Expertise with Microsoft Power Platform, Logic Apps.
-
Experience with continuous integration/continuous deployment (CI/CD) processes around DevOps, data workflows, Synapse workspaces.
Resumes Evaluation/Criteria:
Criteria 1: Microsoft Dynamics 365 CRM & ERP Applications Development Experience - 50 Points
-
Demonstrated development experience of MS Dynamics 365 Customer Relationship Management (CRM) and Enterprise Resource Planning (ERP) applications, PowerApps, Power Automate and Power BI, Data Factory and Data Pipelines.
Criteria 2: Data Manipulation Skills and Experience - 20 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 with data manipulation languages (T-SQL, PL/SQL), data definition languages, query performance analysis & tuning.
Criteria 3: Testing and Quality Assurance - 20 Points
-
Demonstrated experience of creation and execution of test cases, test scripts, and test data based on functional and technical specifications.
-
Maintain comprehensive testing documentation, including test plans, test cases, test results, and defect reports and ensure all documentation is up-to-date and accessible to relevant parties.
-
Identify potential risks related to testing and implement mitigation strategies.
Criteria 4: Communication Skills - 10 Points
-
Ability to effectively communicate complex technical information to non-technical stakeholders.
-
Ability to work collaboratively with cross-functional teams.
-
Strong interpersonal skills to build relationships with stakeholders.
Knowledge Transfer
What needs to be KT
-
Document the tasks executed and in process of execution as a member of the data migration team using the approach and tools required by the project manager.
To whom
-
Project Manager/Team Members
When
-
1:1 meetings / team meetings / documentation on SharePoint site, throughout the duration of the project life cycle etc.
Must haves:
-
5+ years working experience of Microsoft (MS) Dynamics 365 Customer Relationship Management (CRM) and Enterprise Resource Planning (ERP) applications such as Customer Engagement and Finance & Operations, PowerApps, Power Automate and Power BI, Data Factory and Data Pipelines.
-
5+ years of programming language experience using C#, Power FX, JavaScript, and HTML to:
-
Create and manage Dynamics 365 CRM online solutions.
-
Customize Dynamics 365 CRM forms.
-
Implement Dynamics 365 CRM views and visualizations.
-
Manage Dynamics 365 CRM entities.
-
Configure Dynamics 365 CRM field customizations.
-
Implement Dynamics 365 CRM entity relationships.
-
Create business process flows.
-
Proficiency in Azure-specific scripting using PowerShell or Azure CLI, .NET, C#, Power Platform, Logic Apps
-
Proven working experience in integrating various data sources and systems, both on-premises and in the cloud, using Azure ETL services or other ETL tools.
-
Proficiency in Azure Data Factory, Azure Synapse workspaces
-
Expert proficiency with data manipulation languages (T-SQL, PL/SQL), data definition languages, physical database design, data modeling, query performance analysis & tuning
Nice to have:
-
Azure cloud certifications (e.g., Azure Administrator, Azure Developer, Azure Data Engineer, Azure Database Administrator)
-
Knowledge of integration technologies commonly used with Dynamics, such as DataVerse, Data Entities, and APIs.
-
Experience with continuous integration/continuous deployment (CI/CD) processes around DevOps, data workflows, Synapse workspaces.