Logo of Huzzle

Trade Sales Planning Analyst

image

Red Bull

1mo ago

  • Job
    Full-time
    Mid Level
  • Sales & Business Development
    Data
  • Santa Monica

AI generated summary

  • You need 3+ years in CPG forecasting, strong trade planning skills, problem-solving abilities, effective communication, and proficiency in Microsoft Office, especially Excel.
  • You will support the sales team with data analysis, forecast accuracy, promo evaluations, volume recommendations, and ad hoc reports while maintaining oversight of volume calls and tools.

Requirements

  • 3+ years of experience working for CPG companies managing forecasting for key accounts. Experience in forecasting beverage businesses highly desired
  • Strong business acumen in trade promotional planning, sales forecasting concepts baseline, lift, cannibalization, new product Introductions, limited time offers, promotional pre-dip and post-dip, business seasonality, organic growth.
  • Self-motivated and resourceful, able to creatively problem solve as issues and questions arise
  • Communicate effectively with parties both internal and external and across many levels of the organization
  • Must be proficient with Microsoft Office suite (including power point and excel) and advanced data analysis

Responsibilities

  • Collaborate and support Sales team with actionable data to improve sales forecast accuracy.
  • Provide leading edge forecasting solutions, utilizing and understanding Circana and Nielsen syndicated data, customer offtake data, and Trade Sales data.
  • Deliver Promotion evaluation (volume uplift / cannibalization) and guidelines to support sales teams forecast.
  • Advise and support Sales Teams with volume recommendations.
  • Follow up with teams to adjust volumes in CPM after monthly volume calls, including utilization of SKU Level Planning Tool.
  • Familiarize and utilize Red Bull's internal tools and processes to aid in resolving issues and answering questions quick and efficiently.
  • Establish and promote best practices across all supported accounts.
  • Deliver ad hoc analysis against tight deadlines to support the S&OP monthly process.
  • Create, develop, and deliver monthly forecasting reviews with sales teams.
  • Diligently review and maintain oversight over the Monthly Volume Call File for the respective channel responsibilities.
  • Utilize Forecast Accuracy Dashboard to monitor and improve upon forecast accuracy in alignment with company accuracy targets.
  • Responsible for updated and timely Sales team data input into the Monthly Volume Call File.
  • Responsible for SKU forecasting accuracy of supported accounts.

FAQs

What are the main responsibilities of the Trade Sales Planning Analyst?

The main responsibilities include supporting the Sales team with actionable data to improve forecast accuracy, delivering promotion evaluations, conducting ad hoc analyses for the S&OP monthly process, creating monthly forecasting reviews, and ensuring SKU forecasting accuracy for supported accounts.

What qualifications are required for this role?

The role requires 3+ years of experience working for CPG companies managing forecasting for key accounts, strong business acumen in trade promotional planning, and proficiency in Microsoft Office suite, particularly Excel and PowerPoint.

What tools or data sources will I need to use in this role?

You will utilize Circana and Nielsen syndicated data, customer offtake data, Trade Sales data, and Red Bull's internal tools, including the SKU Level Planning Tool and Forecast Accuracy Dashboard.

Is field experience with customer teams or DSD distribution networks necessary?

While field experience working with customer teams or DSD distribution networks is preferred, it is not a requirement.

What kind of training will be provided for this position?

The company will provide training to familiarize you with Red Bull's internal tools and processes to aid in resolving issues and provide the necessary support for your role.

What is the expected compensation range for this position?

The compensation range for this position is between $64,000 and $102,000, with actual offers varying based on experience and other factors.

What benefits does Red Bull offer to employees?

Benefits include comprehensive medical, dental, and vision plans, 401k match, family leave, PTO & paid holiday schedule, pet, legal, and life insurance, and tuition reimbursement.

Does Red Bull support remote work options for this role?

Yes, the role supports remote work but operates in a hybrid format.

Is there an emphasis on diversity and inclusion in hiring at Red Bull?

Yes, Red Bull North America, Inc. is an Equal Opportunity Employer and considers all qualified applicants regardless of various classifications protected by law.

How will I communicate and collaborate with sales teams in this role?

You will communicate effectively with both internal and external parties at many levels of the organization, providing support and insights to improve sales forecast accuracy.

Red Bull Gives Wings to People and Ideas

Retail & Consumer Goods
Industry
10,001+
Employees
1987
Founded Year

Mission & Purpose

Red Bull Gives Wings to People and Ideas. This drives us - and all we do - since 1987. Today, Red Bull operates in over 170 countries selling more than 7.9 billion cans annually and growing! Above all, our people remain the essential ingredient in bringing the Red Bull brand to life. Becoming the #1 energy drink in the world is a journey of passion and hard work. It’s about asking ourselves every day: how can we do it better? Check out our open roles to become part of the world of Red Bull.