ERP/BOM project

Position: ERP Project - BOM Data Specialist

Location: Elkhart, Indiana (100% onsite)

About the Company and Opportunity of ERP Project - BOM Data Specialist:

• Our client is a dynamic organization undergoing a critical ERP project with a focus on data management and cleansing.

• They value precision, analytical thinking, and a commitment to continuous improvement.

• This role offers the opportunity to work with large datasets and play a pivotal role in ensuring data accuracy and system efficiency.

Overview of the ERP Project - BOM Data Specialist role:

The ERP Project - BOM Data Specialist will be responsible for managing and cleansing large datasets, primarily focusing on Bill of Materials (BOM) updates. This role requires a keen eye for detail, strong analytical skills, and the ability to work with vast amounts of data - approximately 500,000 to 700,000 rows. Key responsibilities include:

• Performing data management, data cleansing, and data validation.

• Utilizing Power Query, pivot tables, and merge fields to normalize data and ensure accuracy.

• Conducting VLOOKUP and XLOOKUP functions to compare datasets against a "data truth."

• Identifying patterns within the data and implementing corrections as needed.

• Comparing old system data to the new ERP system to ensure consistency and integrity.

• Understanding the functional impact of legacy system data on subsets of the new system.

• Collaborating with the team to address inconsistencies and improve data quality.

Preferred Qualifications for the ERP Project - BOM Data Specialist role:

• Strong understanding of Bill of Materials (BOM) and data management processes.

• Proficiency in Power Query, Excel pivot tables, and VLOOKUP/XLOOKUP functions.

• Ability to recognize patterns and normalize large datasets.

• Experience working with large datasets (500K+ rows) and ensuring data accuracy.

• Familiarity with ERP systems and the ability to understand how legacy data impacts new systems.

• Willingness to learn Power Query (training provided if basic knowledge exists).

• Strong analytical and problem-solving skills.

Salary: $79,500.00 to $85,000.00depending on experience

Please Note: This role is 100% onsite.

Click here to apply online

Permanent