Inventory Control & Cost Sr. Analyst

The Stacole Company, Inc.; Glen Allen (VA); Ibrido; USD 100.000 - 110.000; Tempo pieno

Vantaggi offerti da questo lavoro

Medical, Dental, Vision

Life/AD&D

401k with company match

Paid time off

Descrizione del lavoro

Winebow is seeking a skilled Inventory Control and Margin Analytics professional in a hybrid role in the United States. You will identify slow-moving inventory, forecast demand, and optimize working capital while monitoring pricing and supplier agreements.

Strong Excel, BI tool proficiency, and AI tooling are required. The role involves close collaboration with Finance and Supply Chain to improve margins and inventory efficiency across portfolios and locations.

Competenze

• Bachelor's degree or equivalent experience in a relevant field.
• 3-5 years of inventory planning, analytics, pricing, or FP&A experience.
• Advanced Excel with pivot tables and lookups; large data sets.
• Proficiency with Power BI or Tableau.
• Familiar with generative AI tools (Claude, Copilot, ChatGPT).
• Strong knowledge of inventory metrics (turns, days of supply, fill rate).
• Experience extracting and reconciling data from ERP systems.
• Clear written and verbal communication to senior leadership.
• Attention to detail and ownership of recurring reports and controls.

Mansioni

• Identify slow-moving/a ged inventory and plan depletion or transfers.
• Report inventory value, turns, DOH, and working capital impact; explain variances.
• Forecast near-, mid-, and long-term inventory and spend with Finance and Supply Chain.
• Forecast portfolio mix impacts on inventory and working capital.
• Model PO timing, quantities, lead times, and container economics.
• Design and enhance inventory dashboards and analytics using BI tools and ERP data.
• Monitor pricing adherence and report exceptions to price lists and deals.
• Audit supplier agreements, rebates, depletion allowances, and price protection.
• Analyze gross margin by supplier/brand/SKU; build margin bridges by price/cost/mix/volume.
• Collaborate with Finance and Operations to maintain controls and avoid margin leakage.

Conoscenze

Advanced Excel

BI tools

Generative AI

Inventory analytics

ERP data extraction

Communication to leadership

Margin analysis

Data reconciliation

Formazione

Bachelor's degree in finance, Supply Chain, Economics, Business Analytics, or related field

Strumenti

Power BI

Tableau

ERP systems

Python

R

Descrizione del lavoro

Why Winebow?

At Winebow, we are strongly committed to creating an environment that fosters diversity, equity, and inclusion. We are intentional in our efforts to ensure that every employee has a sense of value and opportunity in our company, and we work tirelessly to promote a culture of inclusion where our team feels safe, respected, and valued. We want our Winebow family to feel at home and to be empowered to bring their best selves forward.

We seek talent from all backgrounds to join our organization and are dedicated to achieving a diverse workforce in all aspects of employment including but not limited to recruiting, hiring, promotion, training, benefits, wage and salary equity.

The salary range for this position is $100,000 - $110,000 annually. We also offer a comprehensive benefits package of medical, dental, vision, life, AD&D, 401k with company match, and paid time off. If you are hired at Winebow, your final base salary compensation will be determined based on factors such as geographic location, skills, education and/or experience. In addition to those factors, we consider internal equity of our current team members as a part of any final offer.

Essential Functions:

Inventory Control (approximately 60%)

Identify slow-moving, aged, excess, and at-risk inventory (e.g., vintage changes, expiring programs, discontinued items) and recommend action plans such as depletion programs, transfers, or supplier returns.

Report inventory value, turns, DOH, and working capital impact against targets by Portfolio, Location, Suppliers and explain variances. Develop inventory optimization recommendations to address variances.

Partner with Finance and Supply Chain to develop and maintain near-, mid-, and long- term forecasts and scenario analyses for on hand and on order inventory, purchase dollars, purchase receipts, and sales incorporating seasonal demand changes and other business drivers

Analyze and forecast inventory and working capital impact of Portfolio mix changes (Import, Domestic, SKU category mix)

Model purchase order timing, quantities, lead times, order minimums, and container economics to support optimal balance of inventory and operational costs.

Design and enhance inventory reporting, dashboards, and analytical tools using business intelligence platforms, artificial intelligence capabilities, and enterprise data sources

Margin Control (approximately 40%)

Monitor pricing adherence by comparing invoiced prices against approved price lists, frontline pricing, discounts, and deal structures; report and elevate exceptions.

Audit supplier agreement compliance, including depletion allowances, marketing funds, rebates, chargebacks, price protection, and volume incentives, ensuring all amounts due to Winebow are accurately billed and collected.

Analyze gross margin by supplier, brand, SKU, channel, customer, and sales representative;build margin bridges that attribute changes to price, cost, mix, and volume.

Identify and quantify margin improvement opportunities, including price increases, mix shifts, cost renegotiation, discount leakage, and underperforming SKUs.

Partner with Finance and Operations to design and maintain controls, approval workflows, and exception reports that prevent margin leakage.

Qualifications

Required

Bachelor's degree in finance, Supply Chain, Economics, Business Analytics, or a related field, or equivalent experience.

3-5 years of experience in inventory planning, supply chain analytics, pricing, or commercial/FP&A analysis.

Advanced Excel skills, including pivot tables, lookups, scenario modeling, and working with large data sets.

Proficiency with a BI tool such as Power BI or Tableau.

Working knowledge of generative AI tools such as Claude, Microsoft Copilot, or ChatGPT.

Strong understanding of inventory metrics (turns, days of supply, fill rate, safety stock) and margin drivers (price, cost, mix, volume).

Experience extracting and reconciling data from ERP systems.

Clear written and verbal communication skills, including presenting to senior leadership.

Strong attention to detail and comfort owning recurring reports and controls.

Preferred

Experience in wine, spirits, or beverage alcohol distribution or importing, including three-tier pricing and supplier programs (rebates, depletion allowances, chargebacks).

Experience with statistical or demand forecasting methods, or with tools such as Python or R.

Familiarity with distribution-specific ERP and planning systems.

A track record of delivering measurable inventory reduction or margin improvement.

Core Competencies

Analytical rigor and curiosity

Commercial judgment: connects analysis to business decisions

Ability to influence without direct authority across functions

Ownership and follow-through

Working Conditions:

This is a hybrid position. The employee is expected to work in the office Tuesday, Wednesday, and Thursday.

Equipment Used:

Computer and standard office equipment.

Physical Requirements:

Prolonged periods