Solutions Architect

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 .