Senior Forecasting & Replenishment Analyst - Retail

Mattel, Inc.and Subsidiaries; El Segundo (CA); On-site; USD 69,000 - 88,000; Full time

Job summary

Mattel Sales Corp. in El Segundo, California seeks a Sr Forecasting Analyst to lead replenishment and planning for Walmart, driving end-to-end forecast accuracy and inventory management. You will collaborate with the Mattel commercial team and retailer to ensure on-shelf availability and optimal order execution.

The role supports daily/weekly planning, CPFR meetings, and cross-functional forecasting, leveraging PowerBI and other tools to deliver actionable insights and drive business results.

Qualifications

• Proficient in MS Office and advanced Excel.
• Direct replenishment experience in seasonal environments.
• Experience analyzing large datasets and turning insights into actions.
• 3+ years in sales analysis or merchandise planning.

Responsibilities

• Own store in-stock metrics by influencing the end-to-end order process including order creation, reviewing daily orders, maintaining perfect PO's, and optimizing fill rate.
• Own the execution of our Direct Import business out of Asia, partnering closely with the Customer Service team in our Hong Kong office.
• Consumption execution - Drive a weekly shipping plan by item, by channel, to support POS plans, retailer in-stock and future order needs.
• Daily/Weekly involvement with the sales team coupled with retail analysts/buying team, joint business planning related to in season execution for promotional planning and fulfillment, domestic and import order reviews and chase/cancel with retailer.
• PO order recommendations for current and future looking domestic and direct import.
• Liaison between customer service and supply planning and allocations teams to maximize PO fill rates
• Actively lead and participate alongside Mattel sales team in key CPFR forecasting meetings with Walmart.
• Present business findings and recommend action plan for the season or year. Assist in managing and prioritizing follow-ups from meetings.
• Attend internal consensus meetings to present and share current execution at retail, provide key data findings to cross-functional S&OP teams to reach a consensus forecast on a month to month basis
• Reporting as requested to support the sales team / customer and other business needs.

Skills

MS Office

Excel Power User

Data analysis

Sales analysis

Tools

PowerBI

Alteryx

BigQuery

JDA

SAP

Demantra

Anaplan

Job description

Mattel Sales Corp. in El Segundo, California seeks a Sr Forecasting Analyst to lead replenishment and planning for Walmart, driving end-to-end forecast accuracy and inventory management. You will collaborate with the Mattel commercial team and retailer to ensure on-shelf availability and optimal order execution.

The role supports daily/weekly planning, CPFR meetings, and cross-functional forecasting, leveraging PowerBI and other tools to deliver actionable insights and drive business results.