Remote Master Data Specialist - BOM & ERP Readiness

Aston Carter; Edwardsville (IL); Remote; USD 34,000 - 48,000; Part time

Job summary

Aston Carter is seeking a Master Data Specialist BOM for a contract role, focusing on cleaning, standardizing, and centralizing BOM data for an ERP implementation. The role collaborates with quality and plant teams and offers a primarily remote arrangement with periodic travel to central U.S.

facilities. The position requires experience with BOM datasets, Excel proficiency with pivot tables/lookups, and hands-on ERP exposure in manufacturing.

Qualifications

• Experience working with production data sets such as BOMs, recipes, and quality data from a liquid or fluid-based company.
• Intermediate Excel proficiency, including the ability to build and use pivot tables and lookup functions (e.g., VLOOKUP, HLOOKUP, or similar).
• Strong comfort working with large data sets and numerical information, with attention to detail and accuracy.
• Hands‑on experience with ERP systems in a production or manufacturing environment.
• Ability to collaborate with cross‑functional stakeholders, including quality and plant teams, to gather and validate data.

Responsibilities

• Collaborate with the governance and quality teams to support master data initiatives in preparation for an ERP implementation.
• Analyze and consolidate production data sets such as BOMs, recipes, and quality-related data from multiple plants that currently operate independently.
• Identify and resolve inconsistencies in part numbers and BOM structures across plants to create standardized and centralized master data.
• Receive BOM and related data from the Quality Manager and other stakeholders, review it for completeness, and clarify missing or ambiguous information as needed.
• Extract, organize, and transform data from Excel spreadsheets into formats compatible with the organizations systems and future ERP environment.
• Use Excel tools, including pivot tables and lookup functions, to validate, reconcile, and clean large data sets.
• Work comfortably in situations where requirements or data definitions are not fully clear, using judgment and collaboration to resolve issues.
• Support the documentation of data standards, naming conventions, and governance rules for master data related to production and quality.
• Assist in testing and validating master data within the ERP implementation process to ensure accuracy, consistency, and usability.
• Communicate regularly with plant personnel and cross-functional stakeholders to gather data, clarify discrepancies, and ensure alignment on master data standards.

Skills

BOM data analysis

Excel pivot tables

Data integrity

Ambiguity resolution

Cross-functional collaboration

ERP familiarity

Education

Bachelor's degree (preferred)

Tools

SAP

Excel

Job description

Aston Carter is seeking a Master Data Specialist BOM for a contract role, focusing on cleaning, standardizing, and centralizing BOM data for an ERP implementation. The role collaborates with quality and plant teams and offers a primarily remote arrangement with periodic travel to central U.S.

facilities. The position requires experience with BOM datasets, Excel proficiency with pivot tables/lookups, and hands-on ERP exposure in manufacturing.