Inventory Analyst II

Griots Garage Inc•Plainfield, IN

5d•$65,000 - $80,000•Onsite

About The Position

The Inventory Analyst II conducts scheduled inventory audits via a physical cycle count process by checking physical stock against inventory records to ensure accuracy. The IA analyzes and interprets inventory-related data from various sources, such as receipt of inventory records, supplier (CMO) information, and inventory management systems. The IA is also responsible for managing and optimizing inventory operations, ensuring accurate stock levels, and facilitating the smooth flow of goods within the organization. With expertise in data mining, statistical analysis, and data visualization, the analysts identify patterns, trends, and insights that inform inventory strategies.

Requirements

Bachelor’s degree preferred
4-6 years of experience in logistics and manufacturing operations inventory control
Maintain accurate inventory records, including tracking stock levels, conducting regular audits, and reconciling discrepancies between physical counts and inventory records
Proficiency in Microsoft Excel (advanced formulas, pivot tables, VLOOKUP/XLOOKUP, data analysis)
Experience with inventory software like SAP, Oracle, Epicor, NetSuite
Strong mathematical and problem-solving skills to interpret complex datasets and identify root causes of errors
Ability to operate forklifts or pallet jacks and work in a warehouse environment is preferred
Credentials such as CPIM (Certified in Production and Inventory Management) or CSCP (Certified Supply Chain Professional) are preferred

Nice To Haves

Bachelor’s degree
Ability to operate forklifts or pallet jacks and work in a warehouse environment
CPIM (Certified in Production and Inventory Management) or CSCP (Certified Supply Chain Professional) certifications

Responsibilities

Collect sales and inventory data to identify trends in loss and recovery.
Prepare reports for weekly or monthly summaries for management regarding inventory accuracy, turnover rates, and obsolescence.
Monitor and analyze inventory levels, turnover, and demand trends to prevent shortages and excess stock while maintaining raw materials and finished goods inventory accuracy of 97-99% or greater.
Utilize ABC inventory classification methodologies to prioritize inventory management activities and optimize counting frequencies based on item value, movement, and criticality.
Manage and execute a structured ABC cycle count program, ensuring compliance with established count schedules (A Items: High Value/High Usage counted four times per year; B Items: Moderate Value/Usage counted two times per year; C Items: Low Value/Low Usage counted once per year).
Conduct physical inventory audits, reconcile discrepancies between physical stock and ERP/WMS records, investigate root causes of variances, and implement corrective actions.
Audit item master data, BOMs, routings, inventory transactions, and location accuracy to maintain inventory integrity.
Maintain and update inventory databases, using ERP (Enterprise Resource Planning) or WMS (Warehouse Management Systems) software.
Partner with QC/QA on non-conformances and quarantine inventory by developing and implementing inventory control procedures and recommending system enhancements to improve accuracy and efficiency.
Work closely with Supply chain, Sales, Manufacturing and Logistics teams to coordinate inventory flows and ensure timely transfer of inventory between locations and replenishment of stock.
Investigate inventory losses or discrepancies and implement strategies to prevent future issues.
Train staff on inventory procedures and best practices.