Master Data Specialist - Bill Of Materials

Aston Carter; United States; À distance; USD 34 000 - 48 000; Plein temps

Avantages offerts par ce poste

Remote work

Résumé du poste

Aston Carter is seeking a Master Data Specialist BOM for a 12+ month contract that is largely remote. You will clean, standardize, and centralize BOM and related master data to support an upcoming ERP implementation, collaborating with quality and plant teams across multiple sites.

The role emphasizes Excel-based data validation, handling large BOM datasets, and working in ambiguity to ensure ERP-ready data. Travel to central US facilities may be required.

Qualifications

• Experience cleaning and standardizing BOM and part data.
• Proficient in Excel for data validation and pivot tables.
• Ability to work with large data sets and multiple plants.
• Familiarity with BOM structures in production environments.
• Experience with data governance or data cleansing projects.

Responsabilités

• Collaborate with governance and quality teams for ERP prep.
• Analyze and consolidate BOMs, recipes, and quality data.
• Identify and resolve inconsistencies in part numbers across plants.
• Review data for completeness and clarify missing information.
• Extract and transform data from Excel for ERP readiness.
• Validate data using Excel tools and reconcile large datasets.
• Support documentation of data standards and governance rules.
• Assist in testing master data during ERP implementation.
• Communicate with plant personnel and stakeholders to align standards.

Connaissances

BOM data handling

Excel pivot tables / lookups

Data governance & cleansing

ERP systems experience

Large dataset analysis

Cross-functional collaboration

Formation

Bachelor's degree

Outils

SAP

Microsoft Excel

ERP software

Description du poste

Job Title: Master Data Specialist BOM

This contract role supports the governance team in preparing for an upcoming ERP implementation by cleaning, standardizing, and centralizing master data, with a strong focus on bills of material (BOM) for liquid and fluid-based production. The Master Data Specialist works primarily remotely and collaborates closely with quality and plant teams to consolidate inconsistent part and BOM data into a unified, ERP-ready structure.

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.

Essential Skills

• 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.
• Ability to work effectively in ambiguous situations and "in the grey," making sound decisions with incomplete information.
• 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.

Additional Skills & Qualifications

• SAP experience, particularly with BOM or master data modules, is a plus.
• Bachelors degree is a plus.
• Prior experience in master data governance or data cleansing projects is beneficial.
• Familiarity with standardizing part numbers and BOM structures across multiple locations is advantageous.

Work Environment

This is an estimated 12+ month contract assignment with a primarily remote work arrangement. Candidates based in the Midwest may also work 100% remotely, with periodic travel to facilities in the central United States to support on-site data and process reviews. Work is computer-based, heavily focused on Excel and ERP-related tools, and involves frequent virtual collaboration with governance, quality, and plant teams.

Job Type & Location

This is a Contract position based out of Edwardsville, IL.

Pay and Benefits

The pay range for this position is $25.00 - $35.00/hr.

Individual compensation offered for this position within this range will depend on many factors, including qualifications, skills, relevant experience, job knowledge, geographic location, internal equity, and other pertinent job-related factors.

Eligibility requirements apply to some benefits and may depend on your jobclassification and length of employment. Benefits are subject to change and may besubject to specific elections, plan, or program terms. If eligible, the benefitsavailable for this temporary role may include the following:Medical, dental & visionCritical Illness, Accident, and Hospital401(k) Retirement Plan Pre-tax and Roth post-tax contributions availableLife Insurance (Voluntary Life & AD&D for the employee and dependents)Short and long-term disabilityHealth Spending Account (HSA)Transportation benefitsEmployee Assistance ProgramTime Off/Leave (PTO, Vacation or Sick Leave)

Job Type & Location

This is a Contract position based out of Edwardsville, IL.

Application Deadline

This position is anticipated to close on Oct 28, 2026.

Workplace Type

This is a fully remote position.

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

If you would like to request a reasonable accommodation, such as the modification or adjustment of the job application process or interviewing process due to a disability, please email [e-mail] for other accommodation options.

San Francisco Fair Chance Ordinance: Pursuant to the San Francisco Fair Chance Ordinance, for all positions located in the city and county of San Francisco, we will consider for employment qualified applicants with arrest and conviction records.

Massachusetts Lie Detector: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

Use of Artificial Intelligence (AI): We may use Artificial Intelligence (AI) to support parts of our hiring process, including sourcing, screening, and evaluating candidates. AI helps assess applications and qualifications, but final decisions are made by our hiring team. By applying, you acknowledge and agree that your application may be reviewed using AI tools.