HM Note: This onsite role is three (3) days in office at discretion of manager.
Scope
- The Office of the Public Guardian and Trustee (OPGT) requires a solution architect CRM to provide technical leadership for the data migration into Dynamics 365 Customer Engagement (CE) and Finance and Operations (F and amp;O).
and nbsp;
Assignment Deliverables
As a technical leader in the data migration and reporting team you will provide expert guidance into all aspects of the data migration from legacy solutions into Dynamics 365 CE and F and amp;O full and delta load design and implementation and ensure a quality data migration. You will also lead the export of data assets from Dynamics CE and F and amp;O into the new data lakehouse and lead the design and implementation of the golden layer of the data lakehouse and modernized reports in PowerBI.
Other responsibilities include:
- Lead the development implementation and management of D365 CE and F and amp;O monitoring of the whole system.
- Define the interactions between application packages databases and middleware systems.
- Deliver customizations by defining and implementing entities fields workflows business rules forms and views ensuring they align with the business processes.
- Determine how the Dynamics CRM system will integrate with other systems and applications within the organizations technology landscape.
- Establish security measures to protect sensitive data and ensure proper access control within the CRM system.
- Optimize the performance of the Dynamics CRM system to ensure smooth operation and responsiveness.
- Ongoing Support: lead postmigration support analysis and resolution of datarelated issues or questions; help with optimizing data management processes in the new environment.
- Other duties as assigned.
The Vendors 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 and amp;IT Directive Operational Policy on the I and amp;IT Project Gateway Process and other applicable Guidelines Standards and Procedures.
Skills
Experience and Skill Set Requirements
Experience and Skillset Requirements
and nbsp;
Mandatory Requirements
At least 3 years of recent experience as CRM architect in Microsoft Dynamics 365 CE and F and amp;O implementation and solution integration
Desired Skills and Experience
Knowledge of Microsoft Dynamics 365 Customer Engagement (CE) and Finance and Operations (F and amp;O) functionalities and capabilities
- Extensive experience with CRM applications operating systems environments database technologies programming languages and communication protocols and nbsp;
- Knowledge of performance considerations in different environments and nbsp;
- Experience in structured methodologies for the design development and implementation of applications and nbsp;
- Extensive experience in CRM applications analysis and design in large enterprise environments and nbsp;
- Experience in the use of data and process modelling methodologies techniques and tools including a working knowledge of metadata structures repository functions and data dictionaries and nbsp;
- Experience developing enterprise architecture deliverables (e.g. models and documentation)
- Experience in designing developing implementing and maintaining large complex CRM applications workflow processes and dynamic forms.
- Knowledge of integration technologies commonly used with Dynamics such as DataVerse / Common Data Service (CDS) Data Entities and APIs.
- Experience with continuous integration/continuous deployment (CI/CD) processes around DevOps data workflows Synapse workspaces.
- 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.
and nbsp;
Resumes Evaluation/Criteria:
Criteria 1: Dynamics 365 CE and F and amp;O 40 Points
Knowledge of Microsoft Dynamics 365 Customer Engagement (CE) and Finance and Operations (F and amp;O) functionalities and capabilities implementation configuration customization and operation.
- Extensive experience with CRM applications operating systems environments database technologies programming languages and communication protocols and nbsp;
- Knowledge of performance considerations in different environments and nbsp;
- Experience in structured methodologies for the design development and implementation of applications and nbsp;
- Extensive experience in CRM applications analysis and design in large enterprise environments and nbsp;
- Knowledge of security measures and access controls within the CRM system.
and nbsp;
Criteria 2: Azure Data Migration / ETL / SQL 25 Points
- Experience with the design and implementation of data management strategies within Dynamics CRM data governance policies data quality data migration plans and designing data synchronization processes with other systems.
- Demonstrated experience in integrating various data sources and systems both onpremises and in the cloud using Azure ETL services or other ETL tools
- Demonstrated experience working with Azure Data Factory Azure Synapse workspaces PolyBase including knowledge of pipeline creation data flows integration runtimes triggers and monitoring. and nbsp;
- Demonstrated experience with data manipulation languages (TSQL PL/SQL) data definition languages query performance analysis and amp; tuning
- Demonstrated experience with SQL Server Oracle Azure SQL Databases
- Demonstrated experience with data modeling tools (preferably ERWIN)
Criteria 3: Data Warehouse / Lakehouse 25 Points
Demonstrated experience with data warehousing modelling concepts such as star and snowflake schemas and data modelling tools (preferably ERWIN)
- Demonstrated experience working Power BI creating interactive reports and dashboards configuring data gateways utilizing advanced features such as DAX and Power Query.
- Experience with SSIS SSRS
and nbsp;
Criteria 4: Azure Platform 10 Points
Experience in Azure resource configuration and administration such as Azure Data Lake Blob Storage Key Vault Application Insight resources resource groups and subscriptions.
- Azure cloud certifications
- Demonstrated experience with continuous integration/continuous deployment (CI/CD) tools and processes around Azure DevOps
and nbsp;
Knowledge Transfer
and nbsp;
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 as required by the project manager.
- All plans and amp; designs including architecture artefacts data models prototypes wireframes
and nbsp;
To whom
- Project Manager/Team Members
and nbsp;
When
- 1:1 meetings / team meetings / documentation in DevOps Wiki and boards throughout the duration of the project life cycle.
Must have:
- At least 3 years of recent experience as CRM architect in Microsoft Dynamics 365 CE and F and amp;O implementation and solution integration
Nice To have:
- Knowledge of Microsoft Dynamics 365 Customer Engagement (CE) and Finance and Operations (F and amp;O) functionalities and capabilities
- Extensive experience with CRM applications operating systems environments database technologies programming languages and communication protocols and nbsp;