Logo of Huzzle

On Premise Analyst

image

Red Bull

3mo ago

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

AI generated summary

  • You need 1+ years of analytical experience, strong communication and organizational skills, proficiency in Excel, SQL, Python, and data visualization tools like Tableau or Power BI.
  • You will analyze data for Key Accounts, develop reports and scorecards, track performance, provide insights, maintain customer lists, and train users while enhancing reporting capabilities.

Requirements

  • 1 or more years of analytical experience. Experience in the Consumer Packaged Goods (CPG) industry is a plus.
  • Excellent communication skills: ability to translate raw data to insights and recommendations to both internal and external stakeholders.
  • Strong organizational skills are a must: ability to prioritize, multitask, and adapt in a fast-paced environment.
  • High proficiency in Microsoft Excel and PowerPoint.
  • Experience using programming languages (SQL, Python).
  • Experience using data visualization tools such as Tableau and Power BI.
  • Experience using data manipulation tools to aggregate unstructured data from multiple sources.

Responsibilities

  • Analyze monthly data for Key Accounts to determine drivers and detractors in distribution and volume. Work with Key Accounts leadership to provide qualitative and quantitative analytic recommendations for external business reviews and partnership meetings. Contribute to the development of long-term segment strategy through data analytics. Assist Key Accounts teams to understand trends and opportunities across the business. Facilitate Key Account customer list maintenance to ensure clean and accurate reporting. Refresh monthly reports to provide insights and state of the business updates to the Key Accounts Team. Build top line scorecards and monthly highlights to share with Key Accounts stakeholders. Develop templates to track performance of new Key Account business partnerships. Provide quarterly business updates on top partners to cross-functional counterparts in the On Premise. Maintain reporting standards established by Santa Monica On Premise Analytics team, while providing feedback to apply insights and enhance tracking and reporting capabilities. Provide training to end-users on use of reports. Identify ways to simplify and improve reporting.

FAQs

What is the primary responsibility of the On Premise Analyst?

The primary responsibility of the On Premise Analyst is to perform analyses and provide recommendations to support the On Premise Key Accounts teams, while also developing and streamlining KPIs, dashboards, scorecards, and reporting.

What kind of experience is required for this role?

The role requires 1 or more years of analytical experience, and experience in the Consumer Packaged Goods (CPG) industry is a plus.

What skills are essential for this position?

Essential skills include excellent communication skills, strong organizational skills, high proficiency in Microsoft Excel and PowerPoint, and experience using programming languages such as SQL and Python.

Is experience with data visualization tools required?

Yes, experience with data visualization tools such as Tableau and Power BI is required for this position.

What are the expectations for tracking and reporting?

The expectations include refreshing monthly reports, building top line scorecards, developing templates to track performance of new Key Account partnerships, and maintaining reporting standards while identifying ways to simplify and improve reporting.

What is the salary range for this role?

The base salary range for this position is $72,000 - $108,000, plus cash incentives.

What benefits are offered to employees in this role?

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

Is this position eligible for consideration if the applicant has a criminal history?

Yes, all qualified applicants, including those with criminal histories, will be considered for employment in a manner consistent with applicable state and local laws.

Who does the On Premise Analyst report to?

The On Premise Analyst reports to the Sales Planning & Reporting Manager of On Premise Analytics.

Will there be opportunities for training in this role?

Yes, there will be opportunities to provide training to end-users on the use of reports.

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.