Solutions Architect

Scope
:

• The Office of the Public Guardian and Trustee (OPGT) require a solution architect - CRM to provide technical leadership for the data migration into Dynamics 365 Customer Engagement (CE) and Finance and Operations (F&O).

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&O, full and delta load design and implementation and ensure a quality data migration.

Other responsibilities include:

• Lead the development, implementation and management of D365 CE and F&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 organization's 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 post-migration support, analysis and resolution of data-related issues or questions; help with optimizing data management processes in the new environment.
• Other duties as assigned.

Experience and Skill Set Requirements:

Must Haves:

• At least 3 years of recent experience as a CRM architect in Microsoft Dynamics 365 CE and F&O implementation, data migration, and solution integration

Nice to have:

• Knowledge of Microsoft Dynamics 365 Customer Engagement (CE) and Finance and Operations (F&O) functionalities and capabilities
• Extensive experience with CRM applications, operating systems, environments, database technologies, programming languages, and communication protocols

Skill Set Requirements:

Mandatory Requirements:

• At least 3 years of recent experience as CRM architect in Microsoft Dynamics 365 CE and F&O implementation, data migration and solution integration

Desired Skills and Experience
:

• Knowledge of Microsoft Dynamics 365 Customer Engagement (CE) and Finance and Operations (F&O) functionalities and capabilities
• Extensive experience with CRM applications, operating systems, environments, database technologies, programming languages and communication protocols
• Knowledge of performance considerations in different environments
• Experience in structured methodologies for the design, development and implementation of applications
• Extensive experience in CRM applications analysis and design in large enterprise environments
• 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
• 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.

Dynamics 365 CE and F&O:

• Knowledge of Microsoft Dynamics 365 Customer Engagement (CE) and Finance and Operations (F&O) functionalities and capabilities, implementation, configuration, customization, and operation.
• Extensive experience with CRM applications, operating systems, environments, database technologies, programming languages and communication protocols
• Knowledge of performance considerations in different environments
• Extensive experience in CRM applications analysis and design in large enterprise environments

Azure Data Migration/ETL/SQL:

• 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 on-premises 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.
• Demonstrated experience with data manipulation languages (T-SQL, PL/SQL), data definition languages, query performance analysis & tuning
• Demonstrated experience with SQL Server, Oracle, Azure SQL Databases
• Demonstrated experience with data modeling tools (preferably, ERWIN)
• Experience with SSIS, SSRS

Dynamics 365 CE Security:

• Demonstrated experience with Dynamics 365 security, user profiles, Dataverse security concepts and implementation.
• Knowledge of security measures and access controls within the CRM system.

Azure Platform:

• 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.