Ecommerce Planning Analyst

Mattel Sales Corp. is seeking an
** Ecommerce Planning Analyst
** to support our Direct to Consumer (DTC) business in El Segundo, California.

In this role you will shape demand forecasts, identify trends, and deliver insights that enable smarter decision‑making across supply chain, marketing, and finance. You will own pre‑season assortment planning and manage in‑season insight‑to‑action partnerships with DTC merchandisers, brand partners, and supply chain.

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

• 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 the ability to communicate 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.

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, and many others. Our products are sold in collaboration with the world's leading retail and ecommerce companies.

Mattel is an Equal Opportunity Employer. All applicants will receive consideration for employment without regard to race, ethnicity, color, national origin, religion, sex, gender identity or expression, sexual orientation, veteran and protected veteran status, disability status, or any other basis protected by applicable federal, state or local law.