Data Migration Specialist

The Data Migration Specialist is responsible for planning, executing, validating, and reconciling data migrations from legacy systems into ERP and operational platforms. This role ensures that historical and transactional data is migrated accurately, completely, and in alignment with business and regulatory requirements.

This role is execution-focused and works within the standards defined by the Data Architect., Migration planning and execution

• Analyze legacy data sources and assess data readiness for migration.
• Develop data extraction, transformation, and load (ETL) plans aligned to target systems.
• Build and execute migration scripts, tools, and repeatable migration processes.
• Perform mock conversions and final production cutovers.

Data mapping and transformation

• Create detailed source-to-target mapping documents.
• Apply transformation rules, data cleansing logic, and enrichment where required.
• Validate that migrated data aligns with target ERP configuration and business rules.

Data validation and reconciliation

• Perform row-level and aggregate reconciliations pre- and post-migration.
• Validate financial balances, open transactions, and historical records.
• Partner with finance and operations teams to confirm business signoff.
• Document issues, resolutions, and lessons learned for reuse.

ERP and OpCo rollout support

• Support phased ERP and OpCo migrations.
• Participate in cutover planning and execution.
• Support hypercare by resolving migration-related defects and data issues.
• Maintain migration runbooks and documentation.

• 5+ years of experience performing data migrations for ERP or large enterprise systems.
• 5+ years of hands-on experience with SQL and data transformation techniques.
• Experience migrating data from accounting, project, or operational systems.
• Strong reconciliation and validation skills, especially for financial data.
• Ability to work under cutover timelines with precision and discipline.

Preferred qualifications

• Experience migrating from mid market systems such as Sage, Great Plains, QuickBooks, or similar.
• Experience supporting ERP systems such as BuildOps, Procore, or comparable platforms.
• Experience with ETL tools, scripting, or migration frameworks.
• Experience supporting multi-entity or multi-company data migrations. Technology Doesn’t Change the World, People Do.®

Robert Half is the world’s first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.