Manufacturing Business Analyst

Aston Carter•Lower Saucon Township, PA

6d•$95,000 - $125,000•Hybrid

About The Position

The Manufacturing Business Analyst builds, owns, and maintains the company’s data foundation, including bills of materials (BOMs), costing structures, and raw material specifications. The role determines what data the organization retains, gathers critical information from operations, supply chain, and vendors, and ensures accurate entry into the ERP system. By defining and enforcing data standards, the analyst supports reliable purchasing, valuation, cost control, and financial and operational data that can withstand future due diligence. The role analyzes manufacturing and cost data, conducts root cause analysis, maintains ERP master data, and produces reports and insights using tools such as Excel, SQL, Power BI, Python, Tableau, and AI solutions. It works closely with operations, supply chain, and finance teams to improve data integrity and business decision-making. The position is permanent and based in Bethlehem, Pennsylvania. It is primarily onsite for the first 12 months of onboarding, after which it offers the flexibility to work remotely 1–2 days per week while remaining connected to manufacturing and operational teams. The stated pay range is $95,000–$125,000 per year; individual compensation depends on factors including qualifications, experience, and location.

Requirements

At least 3 years of hands-on experience maintaining and improving data within an ERP system.
At least 3 years of root cause analysis experience in the manufacturing industry.
At least 3 years of experience maintaining master data in a manufacturing or similar environment.
At least 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 Excel pivot tables and VLOOKUP functions for data analysis.
Experience with SQL, Power BI, Python, or Tableau for reporting, analytics, and data visualization.
Experience using AI tools such as Copilot, Claude, or OpenAI-based solutions to support analysis and automation.
Strong analytical skills, including the ability to interpret complex manufacturing and cost data and present clear insights.
Strong attention to detail and commitment to data accuracy and consistency.

Nice To Haves

Bachelor’s 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 advancing its use of technology and data-driven decision-making.

Responsibilities

Own and manage the company’s core data foundation, including BOMs, standard costing, and raw material specifications.
Determine which operational, supply chain, and vendor data the company retains, and ensure relevant information is accurately captured and maintained.
Collect data from operations, supply chain teams, and external vendors, and accurately enter it into the ERP and related systems.
Set, document, and enforce standards to keep master data consistent, reliable, and current.
Conduct root cause analysis of data issues affecting purchasing, valuation, and cost control, and implement corrective actions.
Maintain and continuously improve ERP master data to support accurate reporting and decision-making.
Analyze costing, BOMs, and related financial and operational data to support cost control and business performance.
Use Excel tools such as pivot tables and VLOOKUP to analyze and present data to stakeholders.
Use SQL, Power BI, Python, or Tableau to create reports, dashboards, and analyses of manufacturing and cost data.
Use AI tools such as Copilot, Claude, or OpenAI-based solutions to support analysis, automation, and process efficiency.
Collaborate with operations, supply chain, and finance teams to ensure data integrity and alignment with business needs.
Support preparation of accurate, defensible data and metrics for external review and future buyer due diligence.