Sales Planning & Analytics Analyst

Mattel•El Segundo, CA

5d•Onsite

About The Position

Mattel is seeking a Sales Planning and Analytics Analyst, Growth Channel, based in El Segundo, CA. This position will be instrumental in supporting both the Sales team and the Growth Channels’ Inventory and Planning teams in the areas of forecasting, order fulfillment and planning. This role will report to the Sr. Manager, Sales Planning and Analytics.

Requirements

3 years in retailer facing role, inventory management or demand planning preferred (CPG experience a plus)
Proven analytical capability and attention to detail in identifying demand trends, seasonality, promotional impact and other demand factors.
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.
Solid interpersonal and communication skills – ability to communicate effectively across all organization levels and all functional areas, ability to understand, assess and present viewpoints of others.
Sound business judgment – ability to interpret issues and recommend actions to best support Mattel and Customers goals.
Demonstrated a growth mindset by staying curious and continuously learning, embracing challenges, and improving themselves
Power user in MS Excel required

Nice To Haves

Preferred knowledge of demand forecasting tools and cross functional forecasting processes, specifically, Anaplan.

Responsibilities

Partner with the Sales team to analyze sales trends to improve item level POS projections, inventory projections and order recommendations.
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.
Create sound POS projections based on criteria such as seasonality, planned promotions, distribution and price point.
Improve forecast accuracy by measuring key metrics and different levels and sharing the data with cross functional teams, identifying root cause and implementing next action steps.
Routinely examine their own methodologies to find ways of improving predictive accuracy.
Ability to execute process improvements to drive efficiencies across the business and team.
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 lead and participate alongside Mattel sales team in key collaborative forecasting meetings with Customers Planners and Inventory Analysts.
Present business findings and recommend action plans for the season.
Standard reporting and ad hoc analysis as requested to support the GC Sales team, customer and other business needs