ERP Data Migration Consultant (ETL/SQL Specialist) at ERP Advisors Group

Lakewood, Colorado, United States -

Full Time

Start Date

Immediate

Expiry Date

08 Apr, 26

Salary

150000.0

Posted On

08 Jan, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL, ETL, Data Mapping, Data Cleansing, Data Loading, Microsoft SQL Server, Microsoft Access, ERP Software, Data Validation, Data Transformation, Communication, Problem Solving, Team Collaboration, Documentation, Automation, Client Liaison

Industry

Business Consulting and Services

Description

Description ERP Advisors Group(Lakewood, CO) Is expanding fast – Looking for a dedicatedERP 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 Dynamics, Acumatica, etc. 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. Deliver high-quality, results-driven data projects. 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. Exposure to prevalent ERP software packages including NetSuite, Microsoft, Acumatica, Infor, Epicor, Sage, Oracle, Workday, etc. required. Familiarity with Accounting, Manufacturing, Distribution, and Construction business processes and software required. Advanced level of experience with Microsoft Office applications (Excel, Word, PowerPoint). Maintains and demonstrates a professional yet approachable demeanor. 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.

Responsibilities

The ERP Data Migration Consultant will develop and maintain ETL migration scripts, extract and map data from legacy systems, and ensure data accuracy through validation processes. They will also collaborate with various teams to align technical data processes with business goals.