RQ09223 - Solution Architect - CRM - Junior
On-siteToronto, Ontario, Canada
Job Summary
Lead the data migration and reporting team for technical leadership on migrating legacy systems into Dynamics 365 Customer Engagement. Provide expert guidance on full and delta load design, implementation, and ensuring quality data migration while monitoring the D365 CE system. Define interactions between application packages, databases, and middleware, and deliver customizations including entities, workflows, and business rules. Establish security measures, optimize system performance, and lead post-migration support for data-related issues. Submit deliverables for Cluster/Ministry approval, notify project managers of concerns, and transfer knowledge to designated staff.
Required Qualifications
- At least 1 year of recent experience as CRM architect in Microsoft Dynamics 365 CE implementation, data migration and solution integration
- Azure cloud certifications
- Demonstrated experience with continuous integration/continuous deployment (CI/CD) tools and processes around Azure DevOps
Desired Qualifications
- 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
- 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
- Demonstrated experience with data migration testing, ideally from legacy data sources to Dataverse / Dynamics 365 CE
- Demonstrated experience with designing, implementing and supporting solutions to automate data migration testing to Dynamics 365
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.