Inventory And Data AnalystThe Inventory and Data Analyst is responsible for managing the accuracy, reporting, and reconciliation of all plant inventory and production data. This role is critical in ensuring the integrity of our ERP system (SAGE), tracking co-packing production activities, and providing timely analytics to drive operational excellence. The Analyst will serve as a key liaison between Production, Receiving, Scheduling, Warehousing, Procurement, and Accounting to ensure data integrity and timely reporting.Duties & Responsibilities:Manage day-to-day material transactions within SAGE ERP for all raw, WIP, and finished goodsEnsure all production entries are accurate, complete, and posted within 24 hoursValidate batch yields and finished good output against planned production runsPerform routine audits on production paperwork vs.
system entries and resolve discrepanciesMaintain master data settings for materials and finished goods within the ERP systemPartner with IT and Accounting to support ERP upgrades and inventory module enhancementsProvide clerical support for management team.Lead month-end inventory processes for all departments including warehouse, production, and QA-controlled materials (i.e. swabs, supplies, test kits, etc.).Coordinate weekly cycle counts and spot audits; reconcile and document variancesMaintain par levels and reorder thresholds based on historical usage and forecasted needs (safety stocks on all raw materials- SAGE)Identify slow-moving and obsolete inventory and facilitate appropriate dispositionOversee all inventory movements, including interdepartmental transfers and BOM consumptionWork 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 needsMonitor 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 callsManage contract pack-out documentation and production accountability by lotFlag and report any over/under usage trends or co-packing efficiency concernsDevelop real-time dashboards for inventory levels, production status, material shrink, and customer balancesDeliver daily, weekly, and monthly production and inventory performance reportsBuild predictive tools in Excel to support material planning and variance analysis – or in SAGEAnalyze downtime, loss reports, and raw material trends to support continuous improvementSupport operations leadership with custom data requests and ad hoc reportsCollaborate with Receiving to ensure accurate PO receipts and lot trackingPartner with QA to ensure accurate material release dates and status changes in the systemWork with QA to reduce out of code raw materials and help track while using FEFO/FIFO principlesAssist Scheduling with inventory availability snapshots and material readiness reportsWork with Shipping to validate inventory allocations, finished goods readiness, and outbound load accuracyActively participate in SQF, FDA, customer, and internal audits, providing supporting documentation and traceability reportsDocument SOPs and training guides for all tasks related to inventory and data workflowsMaintain compliance with company inventory control policies and proceduresTrain and support other departments in proper inventory handling and ERP usageConduct quarterly review of BOM accuracy and participate in standard cost reviews with AccountingCreate CAPA action plans for recurring inventory or data integrity issuesSupport capital project analysis with data modeling and material flow mappingConduct year-end physical inventory coordination, preparation, and system closureInventory Accuracy ? 98%Cycle Count Completion: 100% on scheduleReport Timeliness: Daily by 9:00 AMDiscrepancy Resolution ?
48 hoursMaterial Variance ? 1%Knowledge, Skills and Abilities Required:Education and Experience:High School diploma or GED equivalentBachelor's degree in Supply Chain, Business Analytics, or related field preferred3+ years of experience in a manufacturing or food production environment preferred3-5 years' experience in an Analyst role preferably in a food production environmentCompetencies & Capabilities:Fundamental understanding of key manufacturing, ingredient and supply chain KPIs / metricsAn aptitude for effectively translating data findings to tell a story that can be easily understood by all kinds of personnel in various areas of the business.Have strong statistical, analytical, and manufacturing business acumen and a passion around utilizing analytics to solve business problems.Possess deep knowledge and understanding of our data sets and domainSelf-starter, strong drive, highly motivated to make change and bring about fact driven decisions.Strong analytical skills. Ability to derive insights from data and recommend actions to the businessAbility to operate in a complex, rapidly changing environment while adhering to tight schedules and multiple priorities.Demonstrated project management skills and proven ability to balance multiple projects in varying degrees of implementation.Strong organizational, problem-solving and attention to detail skills are required.Must be well-organized and able to coordinate multiple tasks and requests.Excellent verbal and written communication skills, and possess the ability to present information to external and internal groupsExperience supporting SQF, FDA, or USDA compliance preferredComputer/Technical:Proficient in MS Word, Excel, Power Point, MS BIExpert-level Excel skills (pivot tables, complex formulas, dashboards, macros)Advanced understanding of SAGE ERP or similar systemsProficient in leveraging AI to improve analytical models, methodologies and outputsWork Environment:Office-based with frequent floor presence and interaction with warehouse and production teams.Will need to travel to Erlanger, KY when needed as well, at least monthlyMust be able to perform physical inventory counts and work in freezer/cooler environments as neededOccasional evening/weekend hours required during month-end or audit prepEqual Opportunity Employer This employer is required to notify all applicants of their rights pursuant to federal employment laws.
For further information, please review the Know Your Rights notice from the Department of Labor.