Inventory Analyst

Ellsworth Corporation; Village of Germantown (WI); On-site; USD 60,000 - 90,000; Full time

Job summary

Ellsworth Corporation seeks an Inventory Analyst to optimize stock levels and align inventory practices across the supply chain. You will analyze data, KPIs and reporting to assess inventory health, collaborating with distribution, commercial and procurement teams to implement effective stocking strategies.

You will develop dashboards and analytics to guide decisions, support SIOP/IBS processes and drive continuous improvement, leveraging SQL and Power BI for insights and optimization

Qualifications

• 2+ years of experience in inventory management or supply chain.
• Experience with inventory models and stocking strategies.
• Ability to work independently with minimal guidance and make data-driven recommendations.

Responsibilities

• Drive inventory strategy, optimization and alignment across supply chain operations.
• Develop and maintain inventory KPIs, reporting and analytics to guide decisions.
• Analyze safety stock, reorder points and service levels; propose optimization based on costs and demand.
• Create dashboards/reports to support inventory strategy execution (Power BI, SQL).
• Support SIOP/IBS processes and continuous improvement initiatives.

Skills

Inventory management

Data analysis

SQL

Power BI

Excel

Cross-functional teamwork

Communication

Problem solving

Leadership

Education

Bachelor's degree in Supply Chain

APICS CPIM Part 1 (preferred)

MS Excel certification (or equivalent)

Tools

ERP systems

Job description

Job Description:SummaryResponsible for driving inventory performance, optimization, and alignment across supply chain operations. This role analyzes inventory data, Key Performance Indicators (KPIs), and reporting to assess overall inventory health and collaborates cross-functionally to develop and implement effective stocking strategies. The analyst provides data-driven insights to influence business decisions and contributes to Sales, Inventory, Operating Planning (SIOP) and integrated business processes (IBS).ResponsibilitiesExecute and support enterprise inventory strategy, segmentation, and optimization frameworksCollaborate with distribution, commercial, and supply chain teams to implement efficient stocking solutionsDevelop and maintain inventory KPIs, reporting, and analytics to guide business decisionsAnalyze inventory recommendations (safety stock, reorder points, service levels) and make recommendations based on supplier costs, terms, and demand patterns. For ePlus - Presents inventory recommendations to customer audience to drive adoption, working with suppliers to expedite material customers as necessarySupport mitigation analysis for supply chain constraints. For ePlus - Communicates customers to mitigate stockouts, overstock, and scrap with product stocked at their locationInfluence planning, procurement, and operations through data-driven insightsApply inventory models (Economic Order Quantity (EOQ), safety stock, segmentation strategies) and maintain planning parametersIdentify opportunities for cost savings and operational efficiency improvementsDevelop dashboards and reporting tools supporting inventory strategy executionSupport (SIOP) / Integrated Business Planning (IBS) and continuous improvement initiativesExperience2+ years of experience in inventory management or supply chain.EducationBachelor’s degree from a four-year college in Supply Chain or related field. Other equivalent combinations of education and experience may be considered.Certifications, Business Licenses, Registrations, OtherMicrosoft Excel certification (or equivalent proficiency)APICS Certified in Planning and Inventory Management (CPIM) – Part 1 - preferredOther Qualifications, Skills, and AbilitiesAbility to work independently with minimal guidance, including making recommendations which may be outside standard operating proceduresPossess an understanding of the entire supply chain within the commodity and understands/communicates the impact of supply disruptions upstreamEffectively communicates the impact of supply disruptionsContinuous Improvement experience desiredStrong analytical skillsSQL and PowerBI experienceAttention to detail and accuracy requiredAbility to multitask in a fast-paced environmentStrong communication and interpersonal skillsFamiliarity with relevant industry regulations and standardsExperience leading projects or initiativesProficient with MS Office applications (Excel), ERP (Enterprise Resource Planning) software, etc.Demonstrated leadership in cross-functional environmentsTravelN/A