Inventory Analyst
Core
Provide critical support to the Inventory Manager by maintaining data integrity, managing inventory reporting, and monitoring Open Order (OPO) levels to optimize the optics supply chain.
Role type
Inventory Analyst
Builds
Monthly inventory and Open Order (OPO) projections, automated reporting workflows, and accurate inventory data for Contract Manufacturers (CMs) and Business Units.
Domain
Optics manufacturing supply chain
Deliverable
production ML models | product features | dashboards & analysis | client delivery
Required skills
Advanced Microsoft Excel (data modeling, pivot tables, charts), Power BI, ERP systems (Oracle), inventory management processes, manufacturing workflows, data analysis, variance investigation, cross-functional communication.
Preferred skills
AI-driven tools for automation, Excess and Obsolete (E&O) inventory management, Open Purchase Order (OPO) tracking and reconciliation, cross-functional collaboration with Contract Manufacturers.
Technologies
Microsoft Excel, PowerPoint, Power BI, Oracle ERP, AI tools
Responsibilities
Track weekly actuals against inventory and OPO projections, investigate variances, support preparation and validation of "Should-Be" inventory levels, identify opportunities to automate reporting workflows, support investigations into Excess and Obsolete (E&O) increases, review Liability Purchase Orders monthly with CMs, coordinate salvage and scrap processes with CMs and logistics teams.
Seniority
Individual Contributor