Sales Planning and Analytics Analyst, Growth Channel

Mattelinc; El Segundo (CA); On-site; USD 80,000 - 110,000; Full time

Job summary

Mattel is seeking a Sales Planning and Analytics Analyst, Growth Channel, based in El Segundo, CA. You will support Sales and Growth Channels' Inventory and Planning teams in forecasting, order fulfillment and planning, reporting to the Sr.

Manager, Sales Planning and Analytics. The role requires 3 years in a retailer-facing or demand planning environment, strong Excel skills and experience with data blending and forecasting.

Qualifications

• 3 years in retailer facing role, inventory management or demand planning preferred.
• Proven analytical capability and attention to detail in identifying demand trends, seasonality and promotional impact.
• Experience in analyzing large data sets and blending data from multiple sources for actionable reports.
• Preferred knowledge of demand forecasting tools and cross-functional forecasting processes, specifically Anaplan.
• Power user in MS Excel required.

Responsibilities

• Partner with the Sales team to analyze sales trends and improve item-level POS projections, inventory projections and order recommendations.
• Determine appropriate models for evaluating item-level forecasts, considering consumption forecasts, history, inventory levels and promotions.
• Create POS projections based on seasonality, planned promotions, distribution and price point.
• Improve forecast accuracy by measuring metrics and sharing data with cross-functional teams, identifying root causes and next actions.
• Lead and participate in consensus forecasting meetings with Customers Planners and Inventory Analysts to reach monthly forecasts.
• Prepare standard reporting and ad hoc analyses to support GC Sales and other business needs.

Skills

Analytical capability

Attention to detail

Communication skills

Growth mindset

Tools

MS Excel

Anaplan

Job description

The Opportunity:

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.

What Your Impact Will Be:

• 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

What We're Looking For:

• Years of related professional experience: 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.
• Preferred knowledge of demand forecasting tools and cross functional forecasting processes, specifically, Anaplan.
• 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
• Some travel may be required (approximately 0-15%)
• Power user in MS Excel required
• *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.

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

At Mattel, we are dedicated to an inclusive workplace and a culture of belonging.