Ecommerce Planning Analyst

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 Opportunity: 

We are seeking a highly analytical and detail-oriented Planning Analyst to support our Direct to Consumer (DTC) business. This role will be critical in shaping demand forecasts, identifying trends, and delivering insights that enable smarter decision-making across supply chain, marketing, and finance. The ideal candidate combines strong business acumen with exceptional technical skills in Excel and data modeling. In this role, you will also own pre-season assortment planning and manage in-season insight-to-action partnership with DTC Merchandisers, Brand partners and Supply Chain.

What Your Impact Will Be: 

• Develop, maintain, and continuously improve forecasting models for the DTC channel, incorporating historical sales, marketing campaigns, seasonality, and emerging consumer trends.
• Translate large, complex datasets into actionable insights to support inventory planning, promotions, and revenue targets.
• Partner closely with cross functional teams (Supply Chain, Merchants, Brand Teams, Marketing) to align on forecasts and ensure operational readiness.
• Conduct ad hoc analysis to evaluate business performance, promotional effectiveness, and emerging risks/opportunities.
• Create automated dashboards, advanced Excel models, and scenario analyses to support leadership decision making.
• Support monthly business reviews by delivering clear, insightful reporting on DTC trends and performance.
• Assist in accurate data inputs of assortment line plans, proactively updating cross functional teams of changes.

What We’re Looking For:

• Bachelor’s degree in Business, Economics, Statistics, Finance, or a related field (Bachelor or Master’s preferred).
• 3+ years of experience in forecasting, business analytics, or financial planning, preferably in DTC, retail, or consumer products.
• Exceptional Excel expertise (advanced formulas, pivot tables, macros, Power Query, Visual Basic preferred); experience with BI tools (Tableau, Power BI, Looker) a plus.
• Strong understanding of forecasting methods and strong communicator on how trend shifts impact the business
• Excellent communication skills with the ability to synthesize data into clear business recommendations.
• Highly detail-oriented with strong problem-solving skills and the ability to manage multiple priorities.

This is the best role for:

• A strategic thinker who can see the big picture but isn’t afraid to dive deep into the data.
• A self starter who thrives in a fast paced, evolving DTC environment.
• Someone who loves Excel and can leverage it as a superpower to drive efficiency and clarity.
• A collaborative partner with multiple teams and strives for solutions as business evolves

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

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 offerings include toys, content, consumer products, digital and live experiences. 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 at https://jobs.mattel.com/ and www.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