At a Glance
- Tasks: Organise and structure data for analysis, reporting, and AI preparation.
- Company: Join Red Bull, a dynamic company that values creativity and innovation.
- Benefits: Competitive salary, flexible working options, and opportunities for professional growth.
- Other info: Collaborate with diverse teams and gain exposure to multiple departments.
- Why this job: Make a real impact by driving strategic decisions through data insights.
- Qualifications: Strong analytical skills, experience with SQL, Power BI, and a passion for data.
The predicted salary is between 63000 - 77000 £ per year.
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.
Every application is reviewed by a member of our recruitment team.
We take a people-first approach to hiring, ensuring that every application receives thoughtful consideration Responsibilities Areas that play to your strengths,
RESPONSIBILITIES
- 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.
- 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.
JOIN THE TEAM
Got what it takes? In your application we want to see your personal style - what makes you tick and why you think your next opportunity is here with us.
PERFORMANCE GOALS
Deliver a documented On Premise universe methodology covering all priority channels in the first six months.
Validate against an independent field audit sample each quarter, with modelled outlet status matching audit findings within an agreed tolerance.
In the first eight weeks, baseline the recurring reporting and data preparation effort across the On Premise team.
By year end, remove an agreed number of hours per month, with each solution documented, handed over, and running for three consecutive cycles without manual intervention.
Prepare the core On Premise datasets for AI use: clear definitions, documented lineage and appropriate data quality controls, covering the agreed priority domains.
Contribute subject matter expertise, business definitions and test scenarios to AI initiatives led by the wider Data & AI team.
At Red Bull, we exist to give people wiiings.
To achieve that, we recognise the value that comes from having a highly diverse workforce that has the freedom and responsibility to realise their ideas and seize opportunities.
We make recruiting decisions based on experience, skills, potential and talent: everyone is welcome here.
RELATED OPPORTUNITIES
Looking for something else? Select your location.
What drives us
Chasing our potential Since the early days of Red Bull, an entrepreneurial mindset has always guided our approach to work and the environment we create.
Meaning Find your meaning and use your strengths to achieve it. Freedom & Responsibility Take real responsibility for yourself and your work. Mastery
Business Analyst in City of Westminster employer: Red Bull Company Limited
Red Bull is an exceptional employer that fosters a vibrant and innovative work culture, perfect for those passionate about the hospitality and gastronomy scene. With ample opportunities for personal and professional growth, employees are encouraged to unleash their creativity while building meaningful relationships in trendsetting venues. Located in a dynamic region, working with Red Bull means being part of a brand that values unforgettable experiences and empowers its team to make a significant impact.
StudySmarter Expert Advice🤫
We think this is how you could land Business Analyst in City of Westminster
✨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 Company Limited!
✨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 in City of Westminster
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 Company Limited, 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 Company Limited
✨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 Company Limited’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.