Title: MS Dynamics Architect

Duration: 10+ months contract with possibilities of extension

Location: Toronto, ON (Hybrid)

Job Description:

We are seeking a highly experienced Dynamics 365 Customer Engagement (CE) Data Migration Specialist to join our team in a mission-critical role supporting enterprise-wide CRM modernization. The ideal candidate will possess a strong background in Microsoft Dynamics 365 CE, Azure data integration, and ETL pipeline design and testing.

Key Responsibilities:

• Lead the implementation, configuration, customization, and operation of Microsoft Dynamics 365 CE.
• Design, develop, and maintain large-scale CRM applications, including workflow processes and dynamic forms.
• Conduct CRM application analysis and performance optimization within enterprise environments.
• Develop and implement data management strategies, including data migration plans, data synchronization, and governance policies.
• Design and deploy ETL pipelines using Azure Data Factory, Azure Synapse, PolyBase, and related tools.
• Automate and validate data migration testing workflows, particularly migrating data to Dataverse/Dynamics 365 CE.
• Work with T-SQL, PL/SQL, and various data modeling and reporting tools (e.g., ERWIN, SSIS, SSRS).
• Administer and configure Azure resources such as Data Lake, Blob Storage, Key Vault, and Application Insights.
• Participate in CI/CD and DevOps processes to support continuous delivery and integration.

Required Skills and Experience:

Dynamics 365 CE (30%)

• Proven experience with Dynamics 365 CE functionalities, implementation, and customization.
• Strong understanding of CRM platforms, database environments, and performance tuning.
• Experience in large-scale enterprise CRM design and delivery.

Azure Data Migration & ETL / SQL (30%)

• Strong knowledge of Azure ETL services, including Data Factory, Synapse, and data orchestration tools.
• Hands-on expertise in SQL Server, Oracle, Azure SQL DB, and data modeling tools like ERWIN.
• Experience with SSIS, SSRS, and data pipeline design and optimization.

Data Migration Test Automation (30%)

• Demonstrated experience in automating and validating CRM data migrations, particularly into Dataverse.
• Familiarity with test frameworks and methodologies for data accuracy and transformation integrity.

Azure Platform (10%)

• Experience with Azure cloud infrastructure, including resource configuration and management.
• Azure certifications are a plus.
• Working knowledge of CI/CD pipelines using Azure DevOps.

Knowledge Transfer Requirements:

• Document all tasks, processes, data models, architecture artifacts, and test strategies.
• Ensure seamless knowledge transition using project-approved documentation and tools.
• Support project team during post-implementation reviews and continuous improvement initiatives.

Preferred Qualifications:

• Azure or Microsoft Dynamics certifications.
• Experience with metadata management, repository functions, and data dictionaries.
• Familiarity with structured methodologies (Agile, RAD, SDLC) and enterprise architecture standards.