Ecommerce Planning Analyst

Mattel Inc.El Segundo, CA
50d

About The Position

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.

Requirements

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

Responsibilities

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

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume

What This Job Offers

Job Type

Full-time

Career Level

Mid Level

Industry

Miscellaneous Manufacturing

Number of Employees

5,001-10,000 employees

© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service