Hybrid Forecasting Specialist — Retail Demand & Planning

Mattel; El Segundo (CA); On-site; USD 115,000 - 140,000; Full time

Job summary

Mattel is seeking a Specialist to lead forecasting and planning for a top retailer. You will be part of the Sales Planning & Analytics team, focusing on collaborative forecasting and inventory management.

You will support the Sales and Replenishment teams with forecasting, planning, and order fulfillment, ensuring optimal POS performance and in-stock levels. The role emphasizes partnership with Buyers and Replenishment Managers, end-to-end order optimization, and direct import execution from

Qualifications

• Proficient in MS Office and advanced Excel skills.
• Forecasting experience in a highly seasonal environment with long lead times.
• Experience analyzing large data sets and compiling into actionable reports for decision making.
• Knowledge of demand forecasting tools and cross-functional forecasting processes (JDA, SAP, Demantra, Anaplan).

Responsibilities

• Lead analysis of sales trends to improve weekly item-level POS projections.
• Align plans with internal stakeholders and retail partners for a collaborative retail plan.
• Select and apply models for item-level forecasts considering consumption, history, inventory and promos.
• Determine weekly shipping plan by item and channel to support POS plans and in-stock needs.
• Create product flow patterns based on seasonality, promotions, distribution and price point.
• Present findings in internal consensus meetings with cross-functional S&OP teams.
• Influence end-to-end order process to improve fill rate and order accuracy.
• Direct the Direct Import execution out of Asia with Customer Service in Hong Kong.

Skills

Analytical skills

Interpersonal communication

Business judgment

Process orientation

Tools

MS Office

Excel

JDA

SAP

Demantra

Anaplan

PowerBI

Alteryx

BigQuery

Job description

Mattel is seeking a Specialist to lead forecasting and planning for a top retailer. You will be part of the Sales Planning & Analytics team, focusing on collaborative forecasting and inventory management.

You will support the Sales and Replenishment teams with forecasting, planning, and order fulfillment, ensuring optimal POS performance and in-stock levels. The role emphasizes partnership with Buyers and Replenishment Managers, end-to-end order optimization, and direct import execution from