Master Data Specialist- BOM

Aston Carter•Edwardsville, IL

1d•$25 - $30•Hybrid

About The Position

The Master Data Specialist – BOM will support a major master data governance initiative in preparation for an upcoming ERP implementation. The role focuses on cleaning, standardizing, and centralizing bill of material (BOM) and related production data across multiple manufacturing plants. This position works primarily remotely, with occasional on-site collaboration, and plays a key role in ensuring that product and quality data is accurate, consistent, and ready for integration into new systems.

Requirements

Proven experience working with production data sets such as BOMs, recipes, and quality data.
Intermediate proficiency in Microsoft Excel, including pivot tables and lookup functions (e.g., VLOOKUP, HLOOKUP, INDEX/MATCH).
Strong comfort working with large data sets and numerical information.
Ability to evaluate data for completeness, accuracy, and consistency.
Comfort working in ambiguous situations and making progress when information is incomplete or evolving.
Strong attention to detail and a methodical approach to data validation and cleanup.
Effective communication skills to collaborate with quality and operations stakeholders.

Nice To Haves

Experience working with ERP systems or supporting ERP implementations is a plus.
Bachelor’s degree in a relevant field is a plus.
Experience working in a manufacturing-based company is highly desirable.
Familiarity with data governance concepts and master data management practices is beneficial.
Ability to document processes, data mappings, and standards clearly and concisely.

Responsibilities

Support master data governance initiatives focused on BOM and production data in preparation for an ERP implementation.
Collect, review, and validate BOM and related production data (such as recipes and quality data) from multiple manufacturing plants.
Work closely with the Quality Manager to obtain detailed BOM information and clarify data requirements.
Assess incoming data to determine completeness, accuracy, and consistency across plants and product lines.
Identify and resolve inconsistencies in part numbers and materials where different plants use different identifiers for the same item.
Consolidate and standardize BOM and production data to support a centralized master data structure.
Extract data from Excel spreadsheets and reformat it into structures that can be ingested by internal systems.
Use intermediate Excel functions, including pivot tables and lookups, to analyze, reconcile, and transform large data sets.
Document data definitions, mappings, and transformation rules to support ongoing data governance and ERP readiness.
Collaborate with cross-functional stakeholders to clarify data questions and align on standard data practices.
Work comfortably with ambiguous or incomplete information, proactively seeking clarification and proposing data solutions.
Contribute to continuous improvement of data quality processes and standards throughout the duration of the project.