ERP Project – BOM Data Special

Position: ERP Project – BOM Data SpecialistLocation: 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 experiencePlease Note: This role is 100% onsite.#INMAY2026Click here to apply online