Manufacturing Inventory & Data Analyst

Duties & Responsibilities

• Manage day-to-day material transactions within SAGE ERP for all raw, WIP, and finished goods
• Ensure all production entries are accurate, complete, and posted within 24 hours
• Validate batch yields and finished good output against planned production runs
• Maintain master data settings for materials and finished goods within the ERP system
• Partner with IT and Accounting to support ERP upgrades and inventory module enhancements
• Provide clerical support for management team
• Lead month-end inventory processes for all departments including warehouse, production, and QA-controlled materials
• Cookcycle weekly cycle counts and spot audits; reconcile and document variances
• Maintain par levels and reorder thresholds based on historical usage and forecasted needs
• Identify slow-moving and obsolete inventory and facilitate appropriate disposition
• Oversee all inventory movements, including interdepartmental transfers and BOM consumption
• Work closely with inventory management at Erlanger to reconcile their inventory on a weekly or monthly basis
• Act as the single point of contact for all co-packing inventory and data tracking needs
• Monitor finished goods inventory levels by customer using SAGE to ensure visibility of production output and transfers to the external warehouse
• Prepare customer-specific reconciliation reports and host monthly review calls
• Manage contract pack-out documentation and production accountability by lot
• Flag and report any over/under usage trends or co-packing efficiency concerns
• Develop real-time dashboards for inventory levels, production status, material shrink, and customer balances
• Deliver daily, weekly, and monthly production and inventory performance reports
• Build predictive tools in Excel to support material planning and variance analysis – or in SAGE
• Analyze downtime, loss reports, and raw material trends to support continuous improvement
• Support operations leadership with custom data requests and ad hoc reports
• Collaborate with Receiving to ensure accurate PO receipts and lot tracking
• Work with QA to ensure accurate material release dates and status changes in the system
• Work with QA to reduce out of code raw materials and help track while using FEFO/FIFO principles
• Work with Shipping to validate inventory allocations, finished goods readiness, and outbound load accuracy
• Actively participate in SQF, FDA, customer, and internal audits, providing supporting documentation and traceability reports
• Document SOPs and training guides for all tasks related to inventory and data workflows
• Train and support other departments in proper inventory handling and ERP usage
• Conduct quarterly review of BOM accuracy and participate in standard cost reviews with Accounting
• Create CAPA action plans for recurring inventory or data integrity issues
• Support capital project analysis with data modeling and material flow mapping
• Conduct year-end physical inventory coordination, preparation, and system closure

Inventory Accuracy

Inventory Accuracy ≥ 98%

Cycle Count Completion

Cycle Count Completion: 100% on schedule

Report Timeliness

Report Timeliness: Daily by 9:00 AM

Discrepancy Resolution

Discrepancy Resolution ≤ 48 hours

Material Variance

Material Variance ≤ 1%