Supply Chain Analyst - Power BI Guru Needed Location Predominantly Beaverworld, Ponders End, Enfield, EN3 7SR With some travel to our site in Tottenham A Bit About Us Beavertown began life 11 years ago in a tiny BBQ joint in Haggerston, North London. In 2020 we opened BEAVERWORLD, our Out of this World brewery & mothership in Ponders End. Alongside our Lockwood Brewery in Tottenham Hale and our micro-brewery at the Tottenham Hotspur Stadium we have the capacity to brew a staggering 90 million pints a year. Now, we’re happily brewing loads of great beer - for everyone to enjoy - anywhere in the universealthough tastes best when drank on Earth. So, if you’re after some tasty beer with a difference you’ve come to the right place. The Role Fancy joining a company where you’ll collaborate with our Demand Planner and wider commercial team to achieve balanced, realistic and objective demand forecasts for the business? In this role, you’ll be responsible for providing insight that helps support the wider S&OP process, ultimately helping to ensure that forecasts are realistic and well balanced. Tracking and reporting on key metrics such as accuracy and bias will also play a part in helping to guide commercial teams towards realistic numbers. Secondary to demand planning, you’ll also partner with the team in general supply chain planning activities and analysis. This includes areas around supply planning and procurement, with a view to giving the team, and wider business stakeholders, the opportunity to make the best decisions for their functions. You’ll also be able to use your experience manipulating, analysing and interpreting data to provide valuable insights and visualising data for reports. You will have an exceptional attention to detail and will feel comfortable manipulating, analysing and interpreting data for insights, and visualising data for reports. You will be equally well-versed in negotiation and influencing skills when conversing with internal and external stakeholders. What You’ll Be Doing Leveraging your expertise in Power BI and Excel and other data visualisation tools and presenting findings and recommendations Maintenance of demand planning systems, files, and software Maintenance and development of current Demand Planning tools & to lead migrating aspects of the tools and dashboards over to ZAPP Entering and modifying data to ensure the accuracy and correctness of volume and phasing Monitoring and reporting on trends in forecast metrics Building and distributing reports for various stakeholders at various frequencies – daily, weekly and monthly Additional Incorporate various views of demand to align current thinking, including EPOS data, market data (Nielsen / CGA, etc.), Innserve data (line installs, churn), and various other sources Partnering with the Demand Planner on forecast reviews and the monthly Demand Review Maintain a base forecast incorporating history, seasonality and customer ranging Challenge assumptions, make recommendations, highlighting risks and opportunities Provide key inputs into supply and scheduling on existing items, NPD and de-lists Deliver forecast accuracy and bias improvements against defined KPI’s through collaboration with key stakeholders Collaborating with the Supply Planner to accurately maintain up-to-date production schedules using SAP - this will also involve working with production teams to address any needs for production schedule changes Increasing your understanding of the art and science of brewing through study and investigation What You’ll Bring To Us Deep expertise in Power BI, data analysis - creating dashboards using visualisation tools Practical work experience as a Supply Chain Analyst Experience using SAP Advanced Microsoft Excel Strong mathematical and statistics skills Strong organisational, communication, critical thinking, and interpersonal skills Educated to degree level or equivalent, preferably in a STEM subject Desired knowledge & experience using Power Pivot & Power Query What’s In It For You Discounts on Beavertown beer and goodies Discretionary bonus 25 days Annual Leave plus a day off to celebrate your birthday 2 days off every year for volunteering Private healthcare Company pension Team and company social events including monthly lunch If you've been successful in securing an interview, we'll contact you within 2 weeks of your application If you haven't heard from us by then, unfortunately it means that you haven't been successful.