ERP Data Migration Consultant (ETL/SQL Specialist)

ERP Advisors Group; Lakewood (CO); Hybrid; USD 80,000 - 150,000; Full time

Benefits offered by this job

Hybrid work schedule

Annual performance review

Maternity/Paternity Leave

401(k) with company match

Medical insurance

Job summary

ERP Advisors Group is seeking a Data Migration Consultant to move and transform legacy data into ERP systems such as NetSuite, Microsoft BC, and Acumatica. The role is client-facing, requiring strong SQL and data transformation skills.

You will work hybrid in Colorado, join a growing advisory firm, and benefit from training and a clear career path. Five-minute onboarding and ongoing professional development are included.

Qualifications

• Bachelor’s degree in Business Administration, Information Technology, Computer Information Systems, or related field.
• Two to four years experience with SQL Server or MySQL.
• Experience with Microsoft Access and other application development frameworks.
• Experience with major ERP platforms (NetSuite, Microsoft BC, Acumatica, Infor, Epicor, SAP, Oracle, Workday) required.
• Strong communication and client-facing skills.

Responsibilities

• Develop and maintain ETL migration scripts to move data between systems.
• Extract data from legacy systems into structured formats.
• Map source data to target file formats.
• Create and optimize SQL queries and stored procedures for data transformation.
• Load data into new ERP systems and validate results.
• Collaborate with Accounting, Operations, and IT to align data processes.
• Engage with clients to gather requirements and report migration progress.
• Explain technical solutions to non-technical stakeholders.

Skills

SQL

ETL scripting

Data mapping

Client-facing

SQL Server

MySQL

Communication

Problem solving

Education

Bachelor’s degree in related field

Tools

Microsoft Access

Excel

PowerPoint

ERP platforms (NetSuite, Microsoft BC, Acumatica)

Job description

Is expanding fast – Looking for a dedicated

Data Migration Consultant

Why you should join our group:

ERP Advisors Group is seeking a technical, professional, and friendly Data Migration Consultant to join our mission to become the world’s most trusted ERP Advisory firm!

• Amazing expansion opportunity.
• Supportive team culture.
• Use and learn next generation technology tools.
• Competitive salary & benefits package.
• Custom training program.
• Work with some of the most exciting mid-sized clients on the planet.
• Learn about multiple industries and software.

Offered salary and benefits package:

Depending on your experience and performance record, we offer a yearly salary of:

• ERP Data Migration Consultant with a minimum of 2 years relevant experience - $80,000 to $110,000
• ERP Data Migration Senior Consultant with a minimum of 4 years relevant experience - $110,000 to $150,000+

Additionally, we offer:

• Clear career path and growth opportunities.
• On the job industry and methodology training.
• Certification program.
• Annual Performance Review.
• Maternity/Paternity Leave.
• CO only: Up to 48 hours of Paid Sick and Safe time.
• 401(k) with up to 4% company match (100% vested).

(After 30 days)

• Paid holidays.
• Employer-sponsored medical insurance.
• Company-sponsored Life and ADD insurance.
• Voluntary Vision, Dental, Accident, and additional life insurance.

(After 90 Days)

• Accrue up to 120 hours of PTO per year with a payout at the end of the year.
• Two tiers of weekly production bonuses for billable hours.

About our company:

ERP Advisors Group is one of the country’s top independent enterprise software advisory firms. We advise our clients through some of their most challenging transformation projects and ensure they are always successful. We are a two-time Inc. 5000 fastest-growing privately held company and we are continuing to grow!

Your schedule: Hybrid, Monday to Friday, 8:00 am – 5 pm.

NOTE: This is a full-time, client-facing role. You must have a strong familiarity with SQL, excellent communication skills, a willingness to learn, and complete a high volume of tasks.

Your mission & responsibilities as an ERP Data Migration Consultant:

We’re seeking an ERP Data Migration Consultant experienced in ETL scripting, data mapping, cleansing, and loading legacy data into ERP systems such as NetSuite, Microsoft BC, Acumatica, and other modern ERP platforms. The ideal candidate enjoys solving complex data puzzles, thrives in a client-facing consulting environment, and can bridge technical execution with business process understanding.

Some of the ERP Data Migration Consultant’s duties and responsibilities include but are not limited to:

• Develop and maintain ETL (Extract, Transform, Load) migration scripts to move and prepare data between systems.
• Access client source legacy systems and extract original data into a structured database format.
• Map extracted client source data to the target file formats.
• Clean and validate extracted data using advanced SQL queries to ensure data accuracy.
• Create SQL Stored Procedures to convert client’s legacy data for their new software.
• Document, optimize, and execute data transformation procedures.
• Load data into new client systems as needed.
• Liaise between Accounting, Operations, and IT teams to align technical data processes with business goals.
• Work directly with clients in a professional consulting capacity to gather requirements, troubleshoot issues, and communicate migration progress.
• Analyze complex legacy data structures and creatively solve data conversion challenges.
• Deliver high-quality, results-driven data projects in fast-paced ERP implementation environments.
• Collaborate with the EAG Data Migration team and the client team on a regular basis.
• Communicate with EAG consulting team to ensure an organized and successful project.

Required experience and qualifications:

• Bachelor’s degree in Business Administration, Information Technology, Computer Information Systems, or related field.
• Two to four years experience working with SQL Server or MySQL.
• Experience working with Microsoft Access and other application development frameworks.
• Experience working with one or more major modern ERP platforms such as NetSuite, Microsoft BC, Acumatica, Infor, Epicor, Sage, Oracle, Workday, SAP, or similar systems required.
• Prior outward-facing consulting or client service experience is strongly preferred.
• Familiarity with Accounting, Manufacturing, Distribution, and Construction business processes and software required.
• Strong analytical thinking and a passion for solving complex data and business process challenges
• Advanced level of experience with Microsoft Office applications (Excel, Word, PowerPoint).
• Maintains and demonstrates a professional yet approachable demeanor.
• Strong verbal and written communication skills with the ability to interact effectively with both technical and non-technical stakeholders.
• Fluent in English, both written and verbal.
• Authorized to work for any employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.

Thank you for submitting your application online.