ERP Data Migration Consultant (ETL/SQL Specialist)

ERP Advisors Group
Lakewood, United States of America
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate
Compensation
$ 150K

Job location

Lakewood, United States of America

Tech stack

Microsoft Access
Microsoft Word
Microsoft Excel
Databases
Data Conversion
ETL
Data Mapping
Data Transformation
Data Migration
Data Structures
Microsoft Office
Microsoft SQL Server
MySQL
Netsuite
Oracle Applications
Microsoft PowerPoint
Sage Accounting
SAP Applications
SQL Stored Procedures
SQL Databases
Technical Data Management Systems
Scripting (Bash/Python/Go/Ruby)
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