Data Migration Consultant Microsoft Dynamics 365 CE - 8-12 Years – Pennsylvania

Data Migration Consultant Microsoft Dynamics 365 CE - Toll Road Operations – 8-12 Years – Middletown, Pennsylvania, United States  

You will be responsible for planning, designing, and executing the migration of customer, account, vehicle, financial, and transaction data from a variety of source systems—including legacy CRMs, ERPs, SQL databases, flat files, Excel, cloud platforms, and tolling systems—into Microsoft Dynamics 365 Customer Engagement (CE).    

Location: Middletown, PA (Remote - one week in office)   

Your Future Employer: Our client is a roadway system and as a part of their digital transformation they are implementing a solution based on SAP BRIM & Microsoft Dynamics CE.   

Responsibilities:   

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

Requirements:   

1. 8-12 years of proven experience migrating data from tolling systems, transportation platforms, legacy CRMs, or other high-volume transactional systems
2. Strong SQL skills for complex queries, stored procedures, data transformation, and data validation
3. Hands-on experience with Microsoft Dynamics 365 CE / CRM data model, entities, and relationships
4. Proficiency with ETL/migration tools: SSIS with KingswaySoft, Azure Data Factory, Power Platform Dataflows, Custom C#/.NET migration scripts
5. Experience with large-scale migrations involving millions of records
6. Strong understanding of relational data structures such as:
7. Customer ⇄ Account ⇄ Vehicle ⇄ Transponder ⇄ Transaction
8. Ability to analyze large datasets, identify anomalies, and resolve inconsistencies
9. Bachelor’s degree in engineering or a bachelor’s degree in technology from a recognized university

Preferred Skills:

1. Experience with financial transactions, billing data, or violation/enforcement records.
2. Experience in enterprise-scale Dynamics 365 CE migrations.
3. Familiarity with data governance, security, and compliance requirements for financial or transportation data.
4. Knowledge of historical data migration and archival strategies.

 What's in it for you?   

Exciting growth opportunities, a dynamic work environment, and stable project work that strengthens both functional and cross-functional SAP skills. This role involves understanding complex data models, extracting structured and unstructured data, transforming and mapping it to Dynamics CE entities, and ensuring data quality, integrity, and reconciliation throughout the migration lifecycle.

Reach us: If you feel this opportunity is well aligned with your career progression plans, please feel free to reach out to me with your updated profile at twinkle@crescendo-global.com   

Disclaimer: Crescendo Global is specializes in Senior to C-level niche recruitment. We are passionate about empowering job seekers and employers with an engaging memorable job search and leadership hiring experience. Crescendo Global does not discriminate on the basis of race, religion, color, origin, gender, sexual orientation, age, marital status, veteran status, or disability status.   

Note: We receive a lot of applications on a daily basis, so it becomes a bit difficult for us to get back to each candidate. Please assume that your profile has not been shortlisted in case you don't hear back from us in 1 week. Your patience is highly appreciated.   

Scammers can misuse Crescendo Global’s name for fake job offers. We never ask for money, purchases, or system upgrades. Verify all opportunities at www.crescendo-global.com and report fraud immediately. Stay alert!   

Profile Keywords: Microsoft Dynamics 365 CE / CRM, Dynamics CE data model, Data migration / ETL, SSIS / KingswaySoft, Azure Data Factory, Power Platform Dataflows, C# / .NET custom migration scripts, SQL / T-SQL / complex queries / stored procedures, Data transformation, deduplication, normalization, Data validation & Data reconciliation, Referential integrity