What are the responsibilities and job description for the ERP Data Migration Consultant position at Oscar?
Oscar is working with a leading ERP Advisory firm that is looking for an experienced ERP Data Migration Consultant to join their team.
As the ERP Data Migration Consultant, you will be responsible for extracting, transforming, and loading legacy data into modern ERP platforms such as NetSuite, Microsoft Dynamics, Acumatica, and others. The ideal candidate is skilled in ETL processes, data mapping, cleansing, and scripting, and is comfortable collaborating directly with clients and cross-functional teams.
Key Responsibilities:
- Develop and maintain ETL scripts to extract, transform, and load data between legacy and ERP systems.
- Access client legacy systems and convert raw data into structured database formats.
- Map source data fields to target ERP data structures.
- Cleanse, verify, and validate data using advanced SQL queries to ensure accuracy and quality.
- Build SQL stored procedures to convert and prepare legacy data for new ERP environments.
- Document and optimize data transformation steps and processes.
- Automate data processing tasks using Microsoft SQL Server tools and scripting.
- Load validated and transformed data into client ERP systems.
- Coordinate with Accounting, Operations, and IT teams to ensure technical processes align with business objectives.
- Deliver accurate, high-quality data migration results within project timelines.
- Collaborate regularly with the EAG Data Migration team and client stakeholders.
- Maintain clear communication with the consulting team to support seamless project execution.
Qualifications:
- Bachelor’s degree in Business Administration, Information Technology, Computer Information Systems, or a related discipline.
- 2–4 years of hands-on experience with SQL Server or MySQL.
- Experience with Microsoft Access and application development tools.
- Exposure to leading ERP systems such as NetSuite, Microsoft Dynamics, Acumatica, Infor, Epicor, Sage, Oracle, Workday, etc.
- Knowledge of business processes in Accounting, Manufacturing, Distribution, or Construction.
- Advanced proficiency in Microsoft Office applications (Excel, Word, PowerPoint).
- Professional, approachable, and confident communication style.
Recap:
- Location: Lakewood, CO (Hybrid)
- Type: Full time Permanent
- Rate: $80k - $150k annual salary dependent on relevant experience
If you think you're a good fit for the role, we'd love to hear from you!
Salary : $80,000 - $150,000