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

Medical insurance

401(k) with match

Paid holidays

PTO - paid time off

Hybrid schedule

Certification program

Job summary

ERP Advisors Group is seeking an ERP Data Migration Consultant to join our Lakewood office. You will lead ETL scripting, data mapping, cleansing, and loading legacy data into ERP systems such as NetSuite, Microsoft BC, Acumatica, and others.

You will work directly with clients in a consulting capacity and bridge technical execution with business processes. The role requires strong SQL skills, excellent communication, and a collaborative approach.

Qualifications

• Bachelor's degree in a related field.
• 2–4 years with SQL Server or MySQL.
• Experience with Microsoft Access and ERP platforms.
• Strong client-facing consulting experience preferred.
• Knowledge of accounting, manufacturing, distribution, and construction processes.
• Fluent English, excellent communication.

Responsibilities

• Develop and maintain ETL migration scripts to move data between systems.
• Access client legacy systems and extract data for transformation.
• Map extracted data to target formats and validate accuracy with SQL.
• Create stored procedures to convert legacy data for new software.
• Collaborate with accounting, operations, and IT teams to align data processes.
• Engage with clients to gather requirements and communicate progress.

Skills

SQL scripting

Data mapping

ETL processes

Client-facing consulting

Analytical thinking

Verbal & written communication

English proficiency

Team collaboration

Documentation

Education

Bachelor's degree in Business Administration / IT / CIS or related

Tools

SQL Server

MySQL

Microsoft Access

NetSuite

Microsoft Dynamics BC

Acumatica

SAP

Oracle

Workday

Job description

Description

ERP Advisors Group

(Lakewood, CO)

Is expanding fast - Looking for a dedicated

ERP Data Migration Consultant (ETL/SQL Specialist)

Why you should join our group:

ERP Advisors Group is seeking a technical, professional, and friendly ERP 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).
• 401(k) Profit Sharing - 5-year vesting schedule.

(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!

Our Location: 390 Union Boulevard Suite 540, Lakewood CO 80228 www.erpadvisorsgroup.com

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.
• Automate data tasks using Microsoft SQL Server scripting.
• 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.