Description 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.
Key responsibilities
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.
Requirements Required qualifications
- 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.
Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app and get 1-tap apply, notifications of AI-matched jobs, and much more.
All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information.
2025 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking "Apply Now," you're agreeing to Robert Half's Terms of Use and Privacy Notice.
Never miss an opportunity! Create an alert based on the job you applied for.