What are the responsibilities and job description for the Microsoft Dynamics 365 CE Data Migration Consultant position at Data-Core System, Inc.?
Data-Core Systems, Inc. is a provider of information technology, consulting and business process services. We offer breakthrough tech solutions and have worked with companies, hospitals, universities and government organizations. A proven partner with a passion for client satisfaction, we combine technology innovation, business process expertise and a global, collaborative workforce that exemplifies the future of work. For more information about Data-Core Systems, Inc., please visit https://datacoresystems.com/.
Data-Core Systems Inc. is seeking a Microsoft Dynamics 365 CE Data Migration Consultant to be a part of our Consulting team. You will participate and effectively contribute to the design, development, and implementation of complex applications, often using new technologies. You will provide technical expertise and systems design for individual initiatives. You will have the opportunity to work with other SME consultants from our existing team.
Responsibilities
- 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.
Required Skills & Qualifications
- 8-10 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.
- eProficiency 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.
- Experience with financial transactions, billing data, or violation/enforcement records is a plus.
Preferred Qualifications
- Experience in enterprise-scale Dynamics 365 CE migrations.
- Familiarity with data governance, security, and compliance requirements for financial or transportation data.
- Knowledge of historical data migration and archival strategies.
We are an equal opportunity employer.