Sr Forecasting Analyst - Walmart

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

Posting Title Sr Forecasting Analyst - Walmart

Requisition Number R238463

Company Mattel Sales Corp.

Location El Segundo, California

Address 333 Continental Blvd

Zip Code 90245

Job Category Sales

Pay Range USD $69,000 and $88,000 Yearly

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.

CREATIVITY IS OUR SUPERPOWER.

It's our heritage and it's also our future. Because we don't just make toys. We create innovative products and experiences that inspire fans, entertain audiences and develop children through play. Mattel is at its best when every member of our team feels respected, included, and heard-when everyone can show up as themselves and do their best work every day. We value and share an infinite range of ideas and voices that evolve and broaden our perspectives with a reach that extends into all our brands, partners, and suppliers.

The Team:

Mattel is currently seeking a Sr. Analyst to lead the replenishment 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 Opportunity:

The Sales & Planning Analysis (SPA) Senior Analyst will lead the day to day replenishment & execution of the business, in partnership with the Mattel commercial team and the retailer. This role spans all aspects of commercial execution including store level inventory management, order writing/analysis, internal inventory readiness, and order fulfillment, through to on shelf availability.

This role is instrumental in supporting the sales team and driving the business with our Walmart partners. The individual will report into the Walmart Forecasting Sr. Manager.

What Your Impact Will Be:

• 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.

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 replenishment experience planning in a highly seasonal environment with long lead times
• 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
• Have at least 3+ 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
• Knowledge of demand forecasting tools and cross functional forecasting processes (JDA, SAP, Demantra, Anaplan etc.
• Experience with statistical forecasting techniques, systems applications and model building

*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.

Don't meet every single requirement?At Mattel, we are dedicated to an inclusive workplace and a culture of belonging.

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.

Who We Are:

Mattel is a leading global toy and family entertainment company and owner of one of the most iconic brand portfolios in the world. We engage consumers and fans through our franchise brands, including Barbie, Hot Wheels, Fisher-Price, American Girl, Thomas & Friends, UNO, Masters of the Universe, Matchbox, Monster High, MEGA and Polly Pocket, as well as other popular properties that we own or license in partnership with global entertainment companies. Our products are sold in collaboration with the world's leading retail and ecommerce companies. Since its founding in 1945, Mattel is proud to be a trusted partner in empowering generations to explore the wonder of childhood and reach their full potential.

Mattel's award-winning workplace culture has been recognized by Forbes, Fast Company, Newsweek, Great Place to Work, TIME, and more.

Visit us athttps://jobs.mattel.com/andwww.instagram.com/MattelCareers.

Mattel is an Equal Opportunity Employer where we want you to bring your authentic self to work every day. We welcome all job seekers, and all applicants will receive consideration for employment without regard to race, ethnicity, color, national origin, religion, sex, gender, gender identity or expression, sexual orientation, veteran and protected veteran status, disability status, and or any other basis protected by applicable federal, state or local law.

Pursuant to the Los Angeles Fair Chance Ordinance and the California Fair Chance Act, qualified applicants with arrest or conviction records will be considered for employment.

Videos to watch: The Culture at Mattel

Corporate Philanthropy