Senior Forecasting Analyst

SGS Consulting; Sacramento (CA); On-site; USD 85,000 - 110,000; Full time

Job summary

SGS Consulting is seeking a Demand Forecasting and Planning specialist in California to join our retailer-facing team. You will build models for item-level forecasts using consumption data, brand history, and marketing inputs, and create product flow patterns based on seasonality and promotions.

You will lead CPFR meetings with Mattel sales teams, present findings, and drive action plans for seasonal strategies.

Qualifications

• Bachelor's degree in Mathematics, Finance, Data Analytics or related field.
• ,
• 3-4 years of retailer-facing experience in inventory management or demand planning.
• CPG experience is a plus.

Responsibilities

• Determine model for evaluating item-level forecasts considering multiple data factors.
• Create product flow patterns based on seasonality, promotions, distribution and pricing.
• Lead and participate in CPFR forecasting meetings with retailer; present findings and action plans.
• Collaborate daily/weekly with sales and retail teams for in-season execution and order reviews.
• Present POS demand forecasts to S&OP teams to reach monthly consensus.
• Provide PO recommendations for domestic and import; maximize fill rates.
• Liaison between customer service and supply planning to optimize PO fill.
• Produce reports to support sales, customers and business needs.

Skills

Demand forecasting

Data analysis

Excel

Tableau

Cross-functional collaboration

Communication

Education

Bachelor's degree in Mathematics/Finance/Data Analytics or related field

Tools

JDA

SAP

Demantra

Anaplan

Job description

Job Responsibilities

• 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 product flow pattern based on criteria such as seasonality profiles, planned promotions, distribution and price point.
• Actively lead and participate alongside Mattel sales team in key CPFR forecasting meetings with the retailer. Present business findings and recommend action plan for the season or year. Assist in managing and prioritizing follow-ups from meetings.
• Daily/Weekly involvement with the sales team coupled with retail analysts/buying team, joint business planning related to in season execution for promotional planning and fulfillment, domestic and import order reviews and chase/cancel with retailer.
• 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.
• PO order recommendations for current and future looking domestic and direct import.
• Liaison between customer service and supply planning and allocations teams to maximize PO fill rates
• Reporting as requested to support the sales team / customer and other business needs.

Skills

• 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.
• Knowledge of demand forecasting tools and cross functional forecasting processes (JDA, SAP, Demantra, Anaplan etc.)
• 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 retailer goals.
• Power user in MS Excel required. Tableau experience a plus.

Education/Experience

• Minimum Bachelor's Degree (Mathematics, Finance, Data Analytics or other relevant fields)
• Years of related professional experience: 3-4 years in retailer facing role, inventory management or demand planning preferred (CPG experience a plus)