Mattel

Forecasting Specialist - Walmart

Mattel • $94K — $118K *
Retail & Consumer Goods
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • 5+ years of experience in sales analysis or merchandise buying/planning
  • Proficient in MS Office, especially Excel
  • Direct forecasting experience in a highly seasonal environment
  • Extensive experience analyzing large data sets and compiling actionable reports
  • Knowledge of demand forecasting tools (e.g., JDA, SAP, Demantra, Anaplan)

Responsibilities

  • Lead sales trend analysis to enhance item-level POS projections
  • Develop item-level forecasts considering consumer consumption and inventory levels
  • Create weekly shipping plans to support retailer needs
  • Attend consensus meetings to present POS demand forecasts
  • Collaborate with sales team in forecasting meetings with Buyers and Replenishment Managers
  • Influence order processes to improve store in-stock metrics
  • Direct execution of Direct Import business from Asia

Benefits

  • Flexible work model with in-office days and remote Fridays
  • Inclusive workplace culture encouraging diverse applicants
  • Opportunities for professional growth and development
  • Access to a collaborative and innovative team environment
  • Comprehensive benefits package to support employee wellbeing
Full Job Description
Job Description

The Opportunity:

Mattel is currently seeking a Specialist to lead the forecasting and planning for a top retailer. This role will be a member of a dynamic team focused on collaborative sales forecasting and inventory management. The S.P.A. Specialist will be instrumental in supporting both the Sales team and the customer inventory and planning teams in areas of forecasting, planning, and order fulfillment.

What Your Impact Will Be:
  • Serves as subject matter expert (SME) on assigned account and brands.
  • Forecasting capabilities - Lead the analysis of sales trends to improve weekly item level POS projections. Own and align these plans with internal stake holders and retail partners to ensure we have a collaborative plan at retail.
  • Determine appropriate model for evaluating item level forecasts and analysis, considering information such as total end consumer consumption forecasts, brand/product history, history of similar comparable brands/products, inventory levels and marketing programs.
  • Consumption analysis - Determine a weekly shipping plan by item, by channel, to support POS plans, retailer in-stock and future order needs.
  • Create product flow pattern based on criteria such as seasonality profiles, planned promotions, distribution and price point.
  • Attend internal consensus meetings to present and share understanding of POS demand forecasts, provide key data findings to cross-functional S&OP teams to reach a consensus forecast on a month to month basis.
  • Actively participate alongside Mattel sales team in key collaborative forecasting meetings with Buyers and Replenishment Managers. Present business findings and recommend action plan for the season.
  • Deliver 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.
  • Direct the execution of our Direct Import business out of Asia, partnering closely with the Customer Service team in our Hong Kong office.


Qualifications

What We're Looking For:
  • Key Characteristics
    • Strong Analytical Skills - ability to coordinate diverse information, identify relevant data, recommend and implement corrective actions
    • Solid Interpersonal and Communication Skills - ability to communicate effectively across all organizational levels and all functional areas, ability to understand, assess and present the viewpoints of others
    • Sound Business Judgment - ability to interpret issues and recommend actions to best support group, division and corporate goals
    • Process Oriented - Ability to identify and address process improvements and share expertise with others
  • Basic Qualifications
    • Proficient in MS Office, Excel Power User
    • Direct forecasting experience planning in a highly seasonal environment with long lead times
    • Extensive experience in analyzing large data sets, blending data from a variety of sources, conducting own analysis and compiling into an effective actionable summarized report to facilitate decision making & strategic planning.
    • Knowledge of demand forecasting tools and cross functional forecasting processes (JDA, SAP, Demantra, Anaplan etc.)
    • Have at least 5+ years relevant experience in sales analysis or merchandise buying/planning
  • Preferred Qualifications
    • Experience in CPG or retail
    • Experience with PowerBI, Alteryx, BigQuery or other database programs
    • Experience with statistical forecasting techniques, systems applications and model building


Additional Information

Don't meet every single requirement? At Mattel, we are dedicated to an inclusive workplace and a culture of belonging. If you're excited about this role but your past experience doesn't align perfectly with every qualification in the job description, we still encourage you to apply. You may be just the right candidate for this or other roles. Join Mattel's Talent Community and start receiving exciting updates about our company, our employees, and our culture. Also, interested in signing up for job alerts? Do so here!

How We Work:
We are a purpose driven company aiming to empower generations to explore the wonder of childhood and reach their full potential. We live up to our purpose employing the following behaviors:
  • We collaborate: Being a part of Mattel means being part of one team with shared values and common goals. Every person counts and working closely together always brings better results. Partnership is our process and our collective capabilities is our superpower.
  • We innovate: At Mattel we always aim to find new and better ways to create innovative products and experiences. No matter where you work in the organization, you can always make a difference and have real impact. We welcome new ideas and value new initiatives that challenge conventional thinking.
  • We execute: We are a performance-driven company. We strive for excellence and are focused on pursuing best-in-class outcomes. We believe in accountability and ownership and know that our people are at their best when they are empowered to create and deliver results.

Our Approach to Flexible Work:
This role is an in-office role Monday-Thursday, and work from home on Fridays. We embrace a flexible work model designed to empower a culture of growth, optimism, and wellbeing, where every employee can reach their full potential. Combining purposeful in-person collaboration with flexibility, our focus is to optimize performance and drive connection for moments that matter.

The pay range for this position is between $94000 and $118000 annual. The pay range is indicative of projected hiring range, however base pay will be determined based on a candidate's work location, skills and experience. Mattel offers competitive total pay programs, comprehensive benefits, and resources to help empower a culture where every employee can reach their full potential.

Videos to watch:
The Culture at Mattel
Corporate Philanthropy

Videos To Watch
https://youtu.be/gWyvtJNrMno

About Mattel

Mattel, Inc. is a global toy company that designs, manufactures, and markets a wide range of toys and games. The company's brands include Barbie, Hot Wheels, Fisher-Price, American Girl, and more. Mattel's products are sold in over 150 countries and the company has manufacturing facilities in 10 countries. Mattel is committed to sustainability and has set a goal to achieve 100% recycled, recyclable, or bio-based plastic materials in all products and packaging by 2030. The company is also committed to diversity and inclusion and has been recognized for its efforts in this area.
Learn more about Mattel
Size
36,300 employees
Market Cap
$5.9 billion
Industry
Net Income
$126.6 million
Founded
1945
5 Year Trend
-4.3%
Revenue
$4.5 billion
NASDAQ

Similar Jobs

More Jobs at Mattel

More Retail & Consumer Goods Jobs

Find similar Forecasting Specialist - Walmart jobs: