Production Controller
(S&OP & Operational Planning)

Department: Operations
Location: Napa, CA/ American Canyon, CA (Hybrid)
Reports To: Vice President of Operations

Comp Range: $90k-110k

+ 10% Annual Bonus based on performance reviews and company profits

About Us: Last Bottle, Inc. and its sister-companies belong to a portfolio of much-loved wine businesses—each with a distinct identity, loyal following, and shared commitment to excellence. From daily deal sites to exclusive club experiences, we lead the industry with innovation, integrity, and an obsession for quality. Our team sits at the intersection of tradition and technology, building the future of wine while staying rooted in what makes it special.

About the Role
The Production Controller (PC) is a data-driven operations planner responsible for transforming how our organization forecasts, schedules, and executes daily fulfillment. This role bridges Sales, Marketing, Supply Chain, and Warehouse Operations to build a true Sales & Operations Planning (S&OP) function—turning reactive operations into proactive, model-based execution.

The PC leverages data modeling, advanced Excel (including macros), and dashboarding to forecast labor, capacity, and materials. Acting as an “operational engineer,” this individual dives deep into raw data to create actionable insights that drive efficiency, staffing decisions, and non-inventory planning.

Key Responsibilities

S&OP Development & Forecasting

Build and maintain demand forecasts using offer calendars, historical trends, and conversion data.

Partner with Sales, Marketing, and Supply Chain to translate forecasted sales into daily and weekly operational load plans.

Facilitate S&OP meetings to align volume expectations, material readiness, and staffing across departments.

Labor & Capacity Planning

Create predictive labor models using fulfillment performance data (UPH, pick/pack rates, order complexity, SKU mix, etc.).

Recommend staffing levels, shift configurations, and overtime needs to Operations Managers based on forecasted workload.

Support strategic planning for surge events and promotional periods to balance throughput and cost efficiency.

Data Analytics & Dashboarding

Develop automated dashboards and reporting tools to visualize inbound/outbound volumes, throughput, and labor utilization.

Analyze large datasets from WMS, ERP, and marketing platforms to uncover trends, bottlenecks, and optimization opportunities.

Apply Excel macros, pivot tables, and formulas to structure raw data for performance reporting and scenario modeling.

Materials & Non-Inventory Forecasting

Use forecasted order mix to predict consumption of packaging materials, inserts, and shipping supplies.

Collaborate with Procurement to ensure timely replenishment and optimal stock levels.

Monitor usage variance and implement process controls to reduce waste.

Continuous Improvement & Industrial Engineering

Lead or contribute to Lean, Six-Sigma, or 5S initiatives to streamline workflows and eliminate waste.

Use time-study and throughput analysis to improve process efficiency and labor productivity.

Partner with leadership to document and standardize planning procedures and data models.


Qualifications
5+ years of experience in production control, operations analysis, or supply chain planning within eCommerce, logistics, or manufacturing.

Advanced Excel proficiency required (macros, VBA, pivot tables, complex formulas, and modeling).

Strong analytical and statistical skills with proven experience turning raw data into actionable insights.

Experience with WMS, ERP, or BI platforms (Linnworks, NetSuite, Power BI, or equivalent).

Lean, Six-Sigma, or Industrial Engineering background strongly preferred.

Excellent communication and facilitation skills; able to influence cross-functional teams.

Bachelor’s degree in Operations, Supply Chain, Industrial Engineering, or related field preferred.


Core Competencies

Data Mastery: Transforms complex datasets into clear operational plans.

Systems Thinking: Connects sales inputs, operational capacity, and material needs into one integrated forecast.

Process Discipline: Applies Lean/Six-Sigma principles to drive continuous improvement.

Collaborative Planning: Aligns Sales, Marketing, and Operations on one shared set of assumptions and KPIs.

Action Orientation: Uses insights to anticipate challenges and solve problems before they impact fulfillment.


What We Offer:

Competitive salary with bonus potential

Health, dental, and vision benefits

401(k) with company match