Business Analyst (Reach & On Premise) in City of London

Business Analyst (Reach & On Premise) in City of London

City of London Full-Time 63000 - 77000 £ / year (est.) Hybrid
Red Bull GmbH

At a Glance

  • Tasks: Organise and analyse On Premise data to drive strategic decisions and improve reporting.
  • Company: Join Red Bull UK, a dynamic leader in the beverage industry.
  • Benefits: Competitive salary, flexible working, and opportunities for professional growth.
  • Other info: Collaborate with diverse teams and gain exposure to international stakeholders.
  • Why this job: Make an impact by transforming data into actionable insights for a global brand.
  • Qualifications: Strong SQL skills, analytical mindset, and experience with BI tools.

The predicted salary is between 63000 - 77000 £ per year.

Red Bull UK is currently recruiting for a Business Analyst (Reach & On Premise) to be based in London, UK.

The core purpose of this role is to organise and structure our On Premise data assets so that the channel can be reported, analysed, automated and prepared for AI.

  • On Premise data is far more fragmented than the
  • Off

Premise: there is no single measurement provider covering the full outlet universe, and coverage is thinnest in exactly the channels we are trying to grow into.

This role builds the data foundations that close that gap, creating structured, scalable datasets and automated reporting that make On Premise decision-making faster and better evidenced.

This role also owns the market read behind REACH, our programme to drive horizontal distribution and put Red Bull in outlets where we have never been listed.

Sizing the outlet universe channel by channel, establishing where we are and are not present, and tracking horizontal distribution monthly with a methodology that stands up to scrutiny.

This groundwork will lead to collaboration with the Reach Strategy Manager, translating commercial questions into structured analytical requirements and taking ownership of delivering a clear and actionable answer.

Alongside the REACH requirements, the role will provide hand‑on analytical and reporting support across the Commercial business, investigating performance to answer business questions and continually improve the quality and efficiency of commercial reporting.

This role has a large part to play in both driving strategic business decisions in the long term and tracking performance short term.

It has high exposure to multiple departments both locally and at our HQ in Austria, so developing excellent relationships with our internal stakeholders is key.

Responsibilities Areas that play to your strengths

All the responsibilities we’ll trust you with

  • REACH UNIVERSE SIZING AND TRACKING
  • STAKEHOLDER COLLABORATION
  • DATA ANALYSIS & MODELLING
  • REPORTING, AUTOMATION & AI
  • Travel 0-10%
  • REACH UNIVERSE SIZING AND TRACKING
  • Build and own the total GB outlet universe: define what counts as an outlet in each channel, then size and segment it by combining licensed premises data, food business registers, points of interest data, wholesaler and distributor records, and our own field sales data.
  • Work with Data Science at HQ to design methodologies for estimating the universe and our distribution in channels where no single provider covers the market, including sampling approaches, extrapolation, weighting and stated confidence levels.
  • Working closely with the REACH Strategy Manager, establish and run a monthly tracking cycle for horizontal distribution: numeric distribution by channel and account type, with clear rules on versioning, restatement and when the universe is re-based.
  • Validate modelled estimates against ground truth from field audits, wholesaler and distributor sell‑out data and customer data, and document known gaps, biases and margins of error openly.
  • Turn the market read into action: prioritised outlet target lists, white space maps and channel opportunity sizing that field sales and channel teams can work from directly.
  • STAKEHOLDER COLLABORATION
  • Translate business questions into data requirements and ensure data assets meet these needs.
  • Act as a liaison between business users and technical teams (i. e. IT, Data Science at HQ, external data providers).
  • Work with the Performance Insights team and with On Premise sales, field and channel teams to define key performance indicators (KPIs) and keep metrics and reporting consistent across the channel.
  • Proactively challenge requests and assumptions where a different analytical approach would better answer the business question.

Establish agreement where teams have different definitions, requirements or interpretations of performance.

  • Communicate complex analysis clearly to both technical and non-technical audiences.
  • DATA ANALYSIS & MODELLING
  • Analyse large volumes of structured and unstructured data from various sources: internal and external market data.
  • Use SQL, Power BI and Excel to independently interrogate, combine and analyse complex commercial datasets.
  • Design and document appropriate quantitative methods for incomplete data, including sampling, estimation, extrapolation and sensitivity analysis.
  • Develop and maintain robust approaches to entity matching and de‑duplication.
  • Use SQL and other programming tools (e. g., Python) to clean, transform, reconcile and prepare data for analysis, including messy outlet names, addresses and geospatial data, selecting the most efficient tool for the job.
  • Identify and resolve data quality issues affecting analysis and reporting.
  • REPORTING, AUTOMATION & AI
  • Leverage tools such as Snowflake, Power BI, or other BI platforms to develop and maintain On Premise reporting and data visualisation needs.
  • Automate recurring reporting and manual data preparation so that the team spends its time interpreting numbers rather than assembling them.
  • Prepare On Premise data assets for AI‑enabled use cases through clear definitions, documented lineage and structured context, so that AI tools return answers the business can trust.
  • Stay informed about emerging technologies and methods in automation, data analytics, and FMCG business processes.

Experience

Your areas of knowledge and expertise What matters most for this role

  • Curiosity: Continuously eager to learn, improve systems, processes, and tools, while uncovering unexpected connections between data points that lead to valuable insights.
  • Quantitative

Methods: comfortable with sampling, estimation and extrapolation, and able to explain the confidence and the limitations of a modelled number to a non-technical audience.

  • SQL: Strong SQL skills, with the ability to independently interrogate and analyse complex datasets.
  • BI & Excel: Strong Power BI and Excel skills, covering reporting, modelling and ad‑hoc commercial analysis.

Understanding of how to tailor reported outputs for a range of audiences.

  • Programming: Experience of applying Python or R to analysis or automation challenges is a strong plus. Snowflake experience is a plus.
  • Working with
  • Incomplete

Data: experience building a usable view of a market from fragmented or imperfect sources, including entity matching and de‑duplication, rather than only working with clean measured data.

  • Data

Literacy: Ability to prepare high‑quality datasets that preserve the core meaning of the data, enabling quick understanding of its relevance and implications for the problem at hand.

  • Communication: a great communicator at all levels, capable of managing stakeholders' expectations and defending a methodology under challenge.
  • FMCG Knowledge: prior experience working at an FMCG company in a data or analytics focused role is a plus.

Experience of On Premise, foodservice or wholesale channels is a strong plus.

Business Analyst (Reach & On Premise) in City of London employer: Red Bull GmbH

At RedBull Media House, we pride ourselves on being an exceptional employer that fosters a dynamic and inclusive work culture. As a Broadcast Automation Engineer in Wals, you will not only have the opportunity to work on high-profile productions like the FIFA World Cup and Formula 1 but also benefit from a supportive environment that encourages personal growth and innovation. Our commitment to diversity and employee development ensures that every team member can thrive and contribute to our mission of delivering flawless broadcast experiences.

Red Bull GmbH

Contact Details:

Red Bull GmbH Recruitment Team

StudySmarter Expert Advice🤫

We think this is how you could land Business Analyst (Reach & On Premise) in City of London

✨Get to Grips with Data Visualisation Tools

If you're aiming for a full-time role in business intelligence, brush up on your skills with popular data visualisation tools like Tableau or Power BI. Showcasing projects where you've transformed raw data into clear visual insights can give you a real edge.

✨Join Local Business Intelligence Meetups

Look for local business intelligence meetups or analytics conferences in your area. These events are not just great for learning but also for networking with industry professionals who could lead you to opportunities at companies like Red Bull GmbH!

✨Engage with Online BI Communities

Join online forums or communities focused on business intelligence—think LinkedIn groups, Reddit threads, or even dedicated Slack channels. Engage actively by sharing your insights and asking questions; this can help you build visibility and connect with potential employers.

✨Leverage Your University’s Career Support

If you're a recent graduate, definitely tap into your university's career services. Many have connections with companies in need of full-time BI specialists, and they can guide you on how to pitch yourself effectively—don't miss out on that!

We think you need these skills to ace Business Analyst (Reach & On Premise) in City of London

Data Analysis
SQL
Power BI
Excel
Python
Data Modelling
Stakeholder Collaboration

Some tips for your application 🫡

Highlight Your Analytical Skills:In the business intelligence field, showcasing your analytical skills is a must. Make sure your CV includes relevant experience with data analysis tools, programming languages like SQL or Python, and any projects where you've interpreted complex data sets to drive business decisions.

Showcase Your Business Acumen:Don't just focus on data; show us how you can apply your insights to real-world business problems. Highlight projects where you made a tangible impact on company performance, and be prepared to explain your thought process in your cover letter.

Tailor Your Documents for Us:When applying for a full-time role at Red Bull GmbH, tailor your CV and cover letter to reflect our organisational goals and strategies. Mention specific tools and methodologies that align with what we do—this shows you’ve done your homework and are genuinely interested in our mission!

Include Relevant Certifications:Certifications like Google Data Analytics or similar qualifications can really make you stand out in business intelligence. Include these in your application, as they demonstrate your commitment to the field and your willingness to stay current with industry standards.

How to prepare for a job interview at Red Bull GmbH

✨Show off your analytical skills

In a business intelligence role, you're going to need to demonstrate your analytical prowess. Be prepared to discuss specific tools you've used, like SQL, Tableau, or Power BI. Have real-world examples ready where you’ve turned data into actionable insights – this is what makes us shine in interviews!

✨Practice your technical know-how

Expect some technical questions during the interview that dive deep into your understanding of data modelling and analytics frameworks. Brush up on your knowledge of data warehousing concepts and be ready to tackle any real case scenarios they might present. They’ll want to see how you approach problems using your BI toolkit.

✨Portfolio of Projects

Since it's a full-time role, having a strong portfolio is key! Compile case studies demonstrating your previous projects, preferably showing how your insights led to business improvements. This can help us display how you think through complex datasets and your problem-solving process, which is what employers are keen on seeing.

✨Know their business model

Get familiar with Red Bull GmbH’s business model and recent data-driven decisions. Be prepared to discuss how your skills can specifically support their objectives or challenges. Understanding their landscape shows that you’re not just a data buff, but you’re also genuinely interested in how BI can impact their bottom line.