RQ09463 - Jr. Solution Architect - CRM

Source Code; Toronto; On-site; CAD 132,000 - 158,000; Full time

Job summary

Source Code is seeking a Jr. Solution Architect - CRM to lead data migration into Dynamics 365 CE and oversee system integration and reporting. This onsite role requires technical leadership in Azure data services and CRM architecture to ensure a smooth transition from legacy systems.

You will coordinate with stakeholders, define data structures, and implement security and performance best practices across the CRM environment.

Qualifications

• Must have at least 1 year as CRM architect for Dynamics 365 CE implementations.
• Experience with data migration and system integration in enterprise environments.
• Knowledge of ETL tools and Azure data services.

Responsibilities

• Lead the data migration into Dynamics 365 Customer Engagement (CE).
• Provide technical leadership for D365 CE, data fixes and post-migration support.
• Define interactions between apps, databases and middleware.
• Deliver customizations: entities, fields, workflows, forms and views.
• Ensure security, performance, and integration with other systems.

Skills

CRM architect

Dynamics 365 CE

Data migration

Solution integration

Tools

Azure Data Factory

Azure Synapse

PolyBase

SQL Server

Oracle

Azure SQL Database

Job description

About the job RQ09463 - Jr. Solution Architect - CRM

RQ09463 - Jr. Solution Architect - CRM

ONSITE 5 days -595 Bay Street, Toronto

Security Level CRJMC + Credit Check

Must Have:

• At least 1 year of recent experience as CRM architect in Microsoft Dynamics 365 CE implementation, data migration and solution integration
• 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 SQL Server, Oracle, Azure SQL Databases

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)

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 the delivery of data fixes post the data migration.

Other responsibilities include:

• Lead the development, implementation, and management of D365 CE, 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.

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.

Desired Skills and Experience

Knowledge of Microsoft Dynamics 365 Customer Engagement (CE) 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.

AI Disclaimer: Source Code may use artificial intelligence (AI) tools to assist in certain aspects of its recruiting and business operations.

Note: The higher end of the range is intended for absolutely exceptional candidates who meet all must-have requirements and most or all nice-to-have qualifications. The client will evaluate candidates based on both rate expectations and overall skill set when shortlisting.

• $95.49/hr - $114.62/hr Inc.