BI Analyst - West Midlands This role is based in our Head Office in Monkspath, near Solihull, in the West Midlands. It is essential you live within a reasonable commute to our offices. About Us 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 Are you passionate about turning data into compelling stories that drive real business impact? Do you enjoy building powerful dashboards, uncovering insights, and partnering with stakeholders to solve complex problems? If so, we’d love to hear from you. We’re looking for a talented BI Analyst to join our growing team. In this role, you’ll design and deliver high-quality dashboards and reports that shape strategic decisions across the organisation. You’ll work closely with teams at every level, transforming large and complex datasets into meaningful, actionable insights. 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 What You’ll Bring Essential A degree in a numerical, analytical, or computer science discipline Strong Power BI skills – including data modelling, DAX, and visualisation Solid experience with SQL and data extraction from data warehouses Skills 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 What makes Stonegate a great place to work? 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. 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 If you have a disability as outlined by the Equality Act 2010 and require reasonable adjustments to be made during the recruitment process, please let us know in advance so that any support, aids or adaptations can be put in place to assist you. You can contact us on hrsupport@stonegategroup.co.uk. LI-HR1