Title: Data Migration Specialist. ERP and Operational Systems
Role purpose
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.
This is a remote role open to people who reside in states as listed: AZ, CA, CO, DC, FL, GA, IL, KS, KY, MD, MA, MI, NM, NC, OH, SC, TN, TX, UT, VA
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.
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.
Success measures
- Accurate, repeatable migrations with minimal rework.
- Clean cutovers with validated financial and operational data.
- Reduced hypercare issues tied to legacy data.
- Well-documented, reusable migration processes.