American IT Systems is a rapidly growing staffing and recruitment firm specializing in providing comprehensive hiring solutions across the United States. With a focus on both technical and non-technical roles, the agency offers flexible staffing options, including contract, contract-to-hire, and permanent placements, to meet the diverse needs of its clients.Experience12+ years of overall experience with 5+ years in Microsoft Dynamics CRM / Dynamics 365 Customer Engagement data architecture rolesRole Summary: The Dynamics CRM Data Architect is responsible for defining, designing, and governing the data architecture, migration strategy, and integration patterns for Microsoft Dynamics 365 CE solutions. The role ensures data integrity, scalability, performance, and compliance across CRM implementations, upgrades, and transformation programs.Mandatory Technical SkillsMicrosoft Dynamics 365 CE / CRM (Sales, Service, Marketing) Data modeling and CRM entity designSQL Server, complex queries, and data analysisSSIS / KingswaySoft for CRM data migrationCRM SDK / Web APIs / ODataAzure integration services (Functions, Logic Apps, Service Bus)Experience with large scale data migration and transformation programsGood to Have Experience migrating from SFDC or legacy CRM platformsPower Platform data integrationexposure Azure Data Factory / Data Lake exposureMicrosoft certifications: MB 200, MB 400, PL 400Key Responsibilities:Data Architecture & DesignDesign end to end data architecture for Dynamics 365 CE, including entities, relationships, and data modelsDefine master data, transactional data, and reference data structures across CRM modulesEstablish data standards, naming conventions, and governance modelsReview and validate CRM schema designs created by development teamsData Migration & Data QualityDefine and execute data migration strategies from legacy systems (e.g., SFDC, Siebel, custom CRMs) into D365 CELead data migration using Data Migration Jobs, SSIS / Kingsway Soft, staging databasesPerform data mapping, transformation rules, cleansing, and validationEnsure reconciliation, auditability, and post migration data accuracyIntegration & Data MovementDesign and govern CRM integrations with upstream/downstream systemsDefine patterns using REST APIs, OData, Azure Functions, Logic Apps, Service BusEnsure data consistency across CRM, ERP, analytics, and external platformsPerformance, Security & GovernanceOptimize CRM data performance (indexes, bulk operations, async processing)If you are interested in this exciting opportunity, please send your resume to careers@americanitsystems.com.
