Senior Planner, Customer Forecasting

Jobtailor; California (MO); On-site; USD 85,000 - 110,000; Full time

Job summary

Jobtailor seeks a Demand Planning professional to own customer forecasts across major retailers and optimize inventory positions. You will partner with Demand Planning to feed the S&OP process and lead retailer interface meetings to review forecasts and service levels.

The role requires 3–5 years in customer supply chain with large SKU experience, strong Excel skills, and familiarity with CPFR/IBP. Experience with Circana/NielsenIQ and retailer portals is highly valued.

Qualifications

• Bachelor’s degree in supply chain, business, economics, data analytics, or related field required.
• 3–5 years in customer supply chain, forecasting, replenishment, or planning (CPG or beauty experience preferred).
• Experience with major retailer supply chain teams (Walmart Retail Link, Target Partners Online, Amazon Vendor Central).
• Experience forecasting/supporting large SKU assortments (500+ SKU).
• Analytical thinker with strong attention to detail.
• Proficiency in Microsoft Excel (pivot tables, VLOOKUP, data modeling) and ERP/forecasting systems.
• Experience with POS data platforms (Circana, NielsenIQ) and customer forecasting portals.
• Familiarity with CPFR/IBP collaborative forecasting processes.

Responsibilities

• Own Customer Forecasting: Collect, validate, and manage customer team forecasts, replenishment data, and inventory positions across key accounts.
• Collaborate with Demand Planning: Provide accurate, timely customer inputs to feed the internal demand plan and S&OP.
• Retailer Interface: Lead meetings with customer replenishment teams to review forecasts and in-stock performance.
• Prepack & Promo Planning: Align forecast with production capacity and allocation strategy.
• Inventory & Service Monitoring: Track metrics and elevate risks with recommended actions.
• Reporting & Analytics: Maintain dashboards and scorecards on forecast accuracy and event performance.

Skills

Forecasting

Inventory Management

Data Analytics

Retailer Collaboration

Excel Proficiency

ERP/Forecasting Systems

POS Data Analysis

Collaborative Forecasting

SKU Management

Reporting

Education

Bachelor’s degree in supply chain, Business, Economics, Data Analytics, or related field

Tools

Microsoft Excel

ERP Systems

Circana

NielsenIQ

Walmart Retail Link

Target Partners Online

Amazon Vendor Central

Job description

• Own Customer Forecasting: Collect, validate, and manage customer team forecasts, replenishment data, and inventory positions across Walmart, Target, Walgreens, Amazon, and other key accounts
• Collaborate with Demand Planning: Provide accurate, timely customer inputs (POS trends, promotional lifts, event calendars) to feed the internal demand plan and S&OP process
• Retailer Interface: Lead regular meetings with customer replenishment teams to review forecasts, in-stock performance, promotional readiness, and service risks
• Prepack & Promo Planning: Partner with Demand Planning and Commercial teams to align customer specific prepack and promotional forecasts with production capacity and allocation strategy
• Inventory & Service Monitoring: Track key metrics (in-stocks, OTIF, customer fill rates) and elevate risks to Demand Planning and Supply Planning with recommended actions
• Reporting & Analytics: Maintain clear dashboards and scorecards on customer forecast accuracy, bias, and event performance; share insights with Commercial leadership and cross-functional teams

Requirements

• Bachelor’s degree in supply chain, Business, Economics, Data Analytics, or a related field required
• 3–5 years in customer supply chain, forecasting, replenishment, or planning (CPG or beauty experience preferred)
• Experience working directly with major retailer supply chain teams (Walmart Retail Link, Target Partners Online, Amazon Vendor Central) strongly preferred
• Experience forecasting and supporting large SKU assortments, with 500+ SKU experience required
• Analytical thinker with strong attention to detail
• Proficiency in Microsoft Excel (pivot tables, VLOOKUPs, data modeling) and ERP/forecasting systems
• Experience with POS data platforms (Circana, NielsenIQ, Retail Link) and customer forecasting portals
• Familiarity with collaborative forecasting processes (CPFR/IBP)

Core Competencies

Demonstrates expertise in customer forecasting, inventory management, and data analytics, with a strong focus on collaboration with demand planning and retailer interfaces. Proficient in utilizing analytical tools and methodologies to enhance supply chain efficiency and accuracy.

Highest-signal resume keywords

• Customer Forecasting
• Inventory Management
• Data Analytics
• Retailer Supply Chain Experience
• Microsoft Excel Proficiency

ATS Optimization Keywords

Hard Skills

• Forecasting
• Replenishment
• Planning
• Analytical Thinking
• Attention to Detail
• Data Modeling
• POS Data Analysis
• Collaborative Forecasting Processes
• SKU Management
• Reporting

Industry Keywords

• Supply Chain
• Consumer Packaged Goods
• Beauty Industry
• Demand Planning
• S&OP Process

Tools & Technologies

• Microsoft Excel
• ERP Systems
• Circana
• NielsenIQ
• Walmart Retail Link
• Target Partners Online
• Amazon Vendor Central