Manufacturing Business Analyst

Aston Carter; Bethlehem (Northampton County); Hybrid; USD 95,000 - 125,000; Full time

Job summary

Aston Carter seeks a Manufacturing Business Analyst in Bethlehem, PA. You will own and maintain the data foundation—BOMs, costing, and raw material specs—driving data standards across operations, supply chain, and vendors to improve purchasing, valuation, and cost control.

This role combines hands-on ERP data management with advanced analytics using Excel, SQL, Power BI, Python, or Tableau. You will collaborate with finance and manufacturing teams, support due diligence data, and help ensure

Qualifications

• Bachelor's degree in accounting, finance, supply chain, information systems, data analytics, or a related field.
• Experience with ERP data governance and master data management.
• Experience with BOMs, standard costing, and cost accounting.
• Proficiency with Excel pivot tables and VLOOKUP for data analysis.
• Experience with SQL, Power BI, Python, or Tableau for reporting and visualization.

Responsibilities

• Own and manage the company data foundation, including BOMs, standard costing, and raw material specifications.
• Decide which operational, supply chain, and vendor data to retain and ensure accurate capture in ERP.
• Enter data into ERP and related systems with high accuracy.
• Set, document, and enforce data standards for master data consistency.
• Conduct root cause analysis to identify data-related issues affecting purchasing, valuation, and cost control.
• Maintain and improve master data within the ERP to support reporting and decision-making.
• Analyze costing, BOMs, and related data to support cost control and performance.
• Use Excel tools to analyze and present data; build reports with SQL/Power BI/Python/Tableau.
• Utilize AI tools to enhance data analysis, automation, and process efficiency.
• Collaborate with cross-functional teams to ensure data integrity and alignment with business needs.

Skills

ERP data management

Root cause analysis

Master data management

BOMs

Standard costing

Excel (Pivot tables, VLOOKUP)

SQL

Power BI

Python

Tableau

AI tools (Copilot/Claude/OpenAI)

Education

Bachelor's degree in accounting/finance/supply chain/data analytics or related field

Tools

SAGE ERP

Microsoft Excel

SQL

Power BI

Python

Tableau

Job description

Job Title: Manufacturing Business Analyst

Job Description: The Manufacturing Business Analyst plays a central role in building, owning, and maintaining the companys data foundation, including bills of materials (BOMs), costing structures, and raw material specifications. This position defines what data the organization retains, pursues critical information from operations, supply chain, and vendors, and ensures accurate entry into the ERP system. By setting and enforcing data standards, the analyst improves purchasing, valuation, and cost control, and helps ensure that financial and operational numbers remain reliable and durable for future due diligence.

Responsibilities

• Own and manage the companys core data foundation, including BOMs, standard costing, and raw material specifications used across the business.
• Decide which operational, supply chain, and vendor data the company retains, and ensure that all relevant information is accurately captured and maintained.
• Pursue and collect data from operations, supply chain teams, and external vendors, and enter it into the ERP and related systems with high accuracy.
• Set, document, and enforce data standards to keep master data consistent, reliable, and up to date across the organization.
• Conduct root cause analysis to identify data-related issues affecting purchasing, valuation, and cost control, and implement corrective actions.
• Maintain and continuously improve master data within the ERP system to support accurate reporting and decision-making.
• Analyze costing, BOMs, and related financial and operational data to support improved cost control and business performance.
• Use Excel tools such as pivot tables and VLOOKUP functions to analyze and present data clearly to stakeholders.
• Leverage SQL, Power BI, Python, or Tableau to build reports, dashboards, and analyses that provide meaningful insights into manufacturing and cost data.
• Utilize AI tools such as Copilot, Claude, or OpenAI-based solutions to enhance data analysis, automation, and process efficiency.
• Collaborate with cross-functional teams in operations, supply chain, and finance to ensure data integrity and alignment with business needs.
• Support the preparation of accurate, defensible data and metrics that can withstand external review and due diligence by future buyers.

Essential Skills

• Hands-on experience working with ERP systems, including maintaining and improving data within an ERP environment for at least 3 years.
• Minimum of 3 years of root cause analysis experience within the manufacturing industry.
• Minimum of 3 years of experience maintaining master data in a manufacturing or similar environment.
• Minimum of 3 years of experience with standard costing or bills of materials (BOMs).
• Strong proficiency in master data management and data governance practices.
• Ability to create and use pivot tables and VLOOKUP functions in Microsoft Excel for data analysis.
• Experience with SQL, Power BI, Python, or Tableau for reporting, analytics, and data visualization.
• Experience utilizing AI tools such as Copilot, Claude, or OpenAI-based solutions to support analysis and automation.
• Solid analytical skills with the ability to interpret complex manufacturing and cost data and present clear insights.
• Strong attention to detail and commitment to data accuracy and consistency.

Additional Skills & Qualifications

• Bachelors degree in accounting, finance, supply chain, information systems, data analytics, or a related field.
• Experience with SAGE ERP or similar ERP platforms.
• Background in the food and beverage industry or other process manufacturing environments.
• Familiarity with standard costing methodologies and cost accounting principles.
• Ability to work collaboratively with operations, supply chain, and finance teams.
• Interest in contributing to a growing team that is advancing its use of technology and data-driven decision-making.

Work Environment

This role is primarily onsite during the initial onboarding period, with the expectation of working on-site for the first 12 months to deeply understand systems, processes, and cross-functional workflows. After this period, the position offers flexibility to work remotely 12 days per week, while remaining closely connected to manufacturing and operational teams. The environment is focused on growth, technology adoption, and continuous improvement, with regular use of ERP systems, advanced analytics tools, and AI solutions to support data-driven decisions.

Job Type & Location

This is a Permanent position based out of Bethlehem, PA.

Pay And Benefits

The pay range for this position is $95000.00 - $125000.00/yr.

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.

benefits, benefits, benefits, benefits, benefits, benefits, benefits, benefits, benefits, benefits

Workplace Type

This is a hybrid position in Bethlehem,PA.

Application Deadline

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

About Aston Carter

Aston Carter provides world-class corporate talent solutions to thousands of clients across the globe. Specialized in accounting, finance, human resources, talent acquisition, procurement, supply chain and select administrative professions, we extend the capabilities of industry-leading companies. We draw on our deep recruiting expertise and expansive network to meet the evolving needs of our clients and talent community with agility and excellence. With offices across the U.S., Canada, Asia Pacific and Europe, Aston Carter serves many of the Fortune 500. We are proud to be a ClearlyRated Best of Staffing® Platinum Award winner for both client and talent service.

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.