Data-Core Systems Inc.

Dynamics 365 CE Data Migration Consultant

Data-Core Systems Inc.

contract

Posted on:

Location Type: Hybrid

Location: Middletown • Pennsylvania • United States

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

SeniorLead

Tech Stack

AzureETL.NETSQLSSIS

About the role

  • Analyze source system data structures, including customer profiles, accounts, vehicles, transponders, payment methods, transactions, violations, invoices, and billing records
  • Identify critical data relationships, parent/child hierarchies, and foreign key dependencies
  • Develop detailed data mapping and transformation documentation from source systems to Dynamics 365 CE entities (standard and custom)
  • Build, test, and execute ETL pipelines using tools such as SSIS/KingswaySoft, Azure Data Factory, Power Platform Dataflows, or custom .NET utilities
  • Perform data cleansing, normalization, deduplication, and standardization to meet Dynamics CE data model requirements
  • Execute multiple migration cycles, including test loads, validation, and final production migration
  • Ensure referential integrity, high data quality, and accuracy of historical data
  • Generate reconciliation reports, resolve data inconsistencies, and troubleshoot migration errors
  • Document migration strategies, execution runbooks, and transformation rules for future reference

Requirements

  • 8-12 years of proven experience migrating data from tolling systems, transportation platforms, legacy CRMs, or other high-volume transactional systems
  • Strong SQL skills for complex queries, stored procedures, data transformation, and data validation
  • Hands-on experience with Microsoft Dynamics 365 CE / CRM data model, entities, and relationships
  • Proficiency with ETL/migration tools: SSIS with KingswaySoft, Azure Data Factory, Power Platform Dataflows, Custom C#/.NET migration scripts
  • Experience with large-scale migrations involving millions of records
  • Strong understanding of relational data structures such as: Customer ⇄ Account ⇄ Vehicle ⇄ Transponder ⇄ Transaction
  • Ability to analyze large datasets, identify anomalies, and resolve inconsistencies
  • Bachelor’s degree in engineering or a bachelor’s degree in technology from a recognized university
Benefits
  • N/A 📊 Check your resume score for this job Improve your chances of getting an interview by checking your resume score before you apply. Check Resume Score

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
SQLETLdata mappingdata transformationdata cleansingdata normalizationdata deduplicationdata validationdata migrationdata analysis
Soft skills
problem-solvinganalytical thinkingattention to detailcommunicationdocumentation