Data Migration Specialist
Location
United States
Posted
4 days ago
Salary
$105K - $135K / year
Seniority
Mid Level
Job Description
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
Related Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
As a Senior Manager, Data Integration, you’ll have the opportunity to make a meaningful impact by helping advance the mission of USGBC. This role is accountable for driving enterprise-wide data maturity, enabling scalable, future-state architecture that supports advanced analyt...
Data Engineer
GopuffGroceries, Alcohol, Home Essentials & more. Order in seconds, delivered in minutes.
The Data Engineer will design, build, and maintain scalable batch and real-time data pipelines to power analytics, experimentation, and machine learning. This role involves contributing to the data platform architecture and partnering cross-functionally to deliver high-quality, trusted data solutions.
Data Engineering Lead/Scientist
ExperianWe're unlocking the power of data to help create a better tomorrow.
Experienced Data Engineering Analyst Lead/Scientist transforming data into consumer features
Senior Manager Data Engineering
Johnson & JohnsonJohnson & Johnson is an award-winning, family-owned-and-operated company that has been providing health and wellness products for more than 120 years. Employing
Lead a data engineering team to enhance cloud data platforms, ensure high availability and reliability, and collaborate with cross-functional partners to meet business needs while driving innovation and mentoring team members.
