At a Glance
- Tasks: Transform data into impactful insights and create stunning dashboards using Power BI.
- Company: Join Stonegate Group, the UK's largest pub and bar operator with a vibrant culture.
- Benefits: Enjoy 25 days annual leave, healthcare perks, and discounts across our venues.
- Other info: Work in a bright office with free parking and enjoy social events at our onsite pub.
- Why this job: Be part of a dynamic team that values creativity and collaboration in data storytelling.
- Qualifications: A degree in a numerical field and proficiency in Power BI and SQL are essential.
The predicted salary is between 28800 - 43200 £ per year.
What You’ll Be Doing
- Creating dynamic, interactive Power BI dashboards and reports that support key business functions
- Using SQL to extract and transform large datasets in Snowflake, ensuring data is optimised and accurate
- Improving data models and driving automation to enhance reporting efficiency and scalability
- Developing KPIs and performance metrics across finance, operations, sales, and other business units
- Conducting deep‑dive analysis, spotting trends, and presenting clear insights to senior stakeholders
- Collaborating with cross‑functional teams to understand business needs and deliver tailored data solutions
- Ensuring data integrity through robust modelling and validation
- Providing written and verbal commentary on performance and opportunities
- Staying ahead of emerging BI tools, technologies, and industry trends
- Turning data into compelling stories that drive real business impact, building powerful dashboards, uncovering insights, and partnering with stakeholders to solve complex problems
- A degree in a numerical, analytical, or computer science discipline
Qualifications
- Strong Power BI skills – including data modelling, DAX, and visualisation
- Solid experience with SQL and data extraction from data warehouses
- Excellent communication and data‑storytelling abilities
- Highly organised with exceptional attention to detail
- A track record of delivering scalable, advanced BI solutions
- Strong grasp of data transformation and visualisation best practices
- Comfortable working with large datasets and generating meaningful insights
- Ability to engage effectively with stakeholders and translate business needs into analytical outputs
Desirable
- Understanding of financial terminology
- Experience with large‑scale cloud data warehousing
- Background in Hospitality or Retail environments
About Stonegate Group
Stonegate Group is the UK’s largest operator of pubs, bars, and late‑night venues, including Slug & Lettuce, Be At One, and Popworld, to name a few. We’re proud of our diverse portfolio and deeply committed to creating an inclusive culture that embraces individuality in all its forms – including neurodiversity. By fostering an environment where everyone feels welcome, valued, and supported, we reflect the vibrant communities we serve and empower our people to thrive.
Why Join Us
At Stonegate, we believe that when you feel your best, you do your best. That’s why we’re committed to supporting the health, happiness, and overall wellbeing of every team member. From lifestyle perks and flexible support to mental health resources, our benefits are designed to help you thrive, both in and out of work.
Salary and Benefits
£35,000.00 to £40,000.00 per year plus benefits package. Salary dependent on experience.
- 25 days of annual leave, plus 8 bank holidays, with the option to purchase up to 5 additional days of leave each year
- Bonus Scheme
- Access to discounted Private Medical Insurance through Vitality
- Exclusive discounts on Dental Insurance
- Reward Card via the MiXR app, giving you and your friends 25% off food and drinks as well as VIP entry across our Managed Estate
- Life Assurance which gives access to Help @ Hand
- Access to your pay early via Stream
- The Stonegate Xtra portal with access to a wide range of high street discounts and offers
- Discounted access to David Lloyd membership
- Award‑winning Learning & Development programmes to drive your career
BI Analyst employer: Stonegate Group
At Stonegate Group, we pride ourselves on fostering a vibrant and inclusive work culture that empowers our employees to thrive. As a BI Analyst in our Solihull office, you'll enjoy a range of benefits including 25 days of annual leave, a subsidised canteen, and opportunities for professional growth within the UK's largest operator of pubs and bars. Join us to turn your passion for data into impactful insights while enjoying a supportive environment that values collaboration and innovation.
StudySmarter Expert Advice🤫
We think this is how you could land BI Analyst
✨Tip Number 1
Familiarise yourself with Power BI and its features, especially DAX and data modelling. Consider creating a portfolio of sample dashboards that showcase your ability to turn complex data into visual stories, as this will demonstrate your skills effectively during interviews.
✨Tip Number 2
Network with professionals in the hospitality and retail industries, as having insights from these sectors can give you an edge. Attend industry meetups or webinars to connect with potential colleagues and learn about current trends in business intelligence.
✨Tip Number 3
Brush up on your SQL skills, as extracting data from data warehouses is crucial for this role. You might want to practice writing queries that can help you analyse data effectively, which will be beneficial when discussing your technical abilities in interviews.
✨Tip Number 4
Prepare to discuss how you've previously collaborated with stakeholders to gather requirements and deliver insights. Think of specific examples where your data analysis led to impactful decisions, as this will highlight your communication skills and problem-solving abilities.
We think you need these skills to ace BI Analyst
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your experience with Power BI, SQL, and any relevant data analysis projects. Use specific examples that demonstrate your ability to turn data into actionable insights.
Craft a Compelling Cover Letter:In your cover letter, express your enthusiasm for the role and the company. Mention how your skills align with the job requirements, particularly your experience in creating dashboards and collaborating with stakeholders.
Showcase Your Data Skills:If possible, include links to any dashboards or reports you've created in Power BI. This will give the hiring team a tangible sense of your capabilities and style.
Prepare for Potential Questions:Think about how you would explain complex data concepts in simple terms. Be ready to discuss your problem-solving approach and how you ensure data accuracy and integrity in your work.
How to prepare for a job interview at Stonegate Group
✨Showcase Your Power BI Skills
Make sure to highlight your proficiency in Power BI during the interview. Be prepared to discuss specific projects where you've created dashboards or reports, and explain how you used DAX and data modelling to achieve your goals.
✨Understand the Business Context
Familiarise yourself with the hospitality and retail industries, as well as the specific challenges they face. This will help you demonstrate how your analytical skills can provide valuable insights that drive business decisions.
✨Prepare for Scenario-Based Questions
Expect questions that ask you to solve hypothetical problems or analyse data sets. Practise explaining your thought process clearly and concisely, as this will showcase your ability to communicate complex data effectively.
✨Emphasise Collaboration Skills
Since the role involves working closely with various teams, be ready to discuss your experience in cross-functional collaboration. Share examples of how you've gathered requirements from stakeholders and delivered actionable insights based on their needs.
