ERP Data Migration Consultant (ETL/SQL Specialist)

ERP Advisors Group
Lakewood, CO, United States
about 1 month ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
2 years minimum
Compensation
$80,000.0 - $150,000.0
Working hours
Regular working hours
Languages
English
Job source

Tech stack

Microsoft Access Microsoft Word Microsoft Excel Databases Data Conversion Extract Transform Load (ETL) Data Mapping Data Transformation Data Migration Data Structures Microsoft Office Microsoft SQL Server
+18 more
MySQL Netsuite Oracle (Applications) Microsoft PowerPoint Sage Accounting SAP (Applications) SQL Stored Procedures SQL Databases Technical Data Management Systems Scripting Freeform SQL Acumatica Cloud ERP Platform Information Technology Epicor ERP Guidewire BillingCenter Infor Workday Legacy Systems

Job description

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.

Requirements

Do you have experience in SQL?, Do you have a Bachelor’s degree?, 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., * 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.

Benefits & conditions

Pulled from the full job description

  • 401(k) 4% Match
  • AD&D insurance
  • Parental leave
  • 401(k)
  • Health insurance
  • 401(k) matching
  • Paid time off, 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 the 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!

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on indeed.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:46 min

Navigating a career in cloud transformation consulting

Piet Van Dongen · LIVE

6:22 min

Eliminating HR bureaucracy and trusting employees

Rudi Bauer Rudi Bauer +1 · Cappuccino with HR

2:18 min

Scaling MySQL databases for massive user growth

Johannes Nicolai Johannes Nicolai +1 · LIVE

1:49 min

Scaling technical teams to achieve enterprise software transformation

Torben Schramme · WWC 2021

5:06 min

Primary reasons for capability gaps in modern recruitment systems

Rudi Bauer Rudi Bauer +1 · Cappuccino with HR

1:48 min

Analyzing network packets with database protocol tools

Daniël van Eeden Daniël van Eeden · WWC Europe 2026

Videos

See all

Related articles

See all