Finance Analyst - Stock

"As we continue our mission to make people and nature happy through chocolate, we’re looking for a Finance Analyst – Stock to join our Finance team on a full-time basis.An exciting opportunity to join our Operational Finance team supporting all things stock. You’ll play a key role in ensuring the accuracy, insight and efficiency of our stock accounting, reporting and reconciliations across the business as we continue to grow in the UK and US.This is a hands-on analytical role, ideal for someone who enjoys working with data, driving process improvements and partnering with both Finance and Operational teams to deliver meaningful insight.As well as a competitive salary and a range of company benefits, you’ll receive 50% discount on all products, and a 70% discount for you and your guests when you stay at our Rabot Estate hideaway on the paradise island of Saint Lucia.Here at Hotel Chocolat, we’ve adopted hybrid working. This means you’ll join us on site for at least 3 days per week at either; our Distribution Centre ‘Alpha’, in St. Neots, Cambridgeshire. Whether it’s a bustling event, online order or keeping our store shelves fully stocked, our team at Alpha provide the support network that makes this happen.Alpha is just off the A1 (Wyboston Interchange) and 3.4 miles from St Neots train station.Or at our Factory ‘Hadley Park’ in Huntingdon, Cambridgeshire – right in the heart of where our chocolates are made and where, each week, we produce between four to six million of the chocolates we all know and loveHadley Park is just five minutes off the A141 and 1.3 miles from Huntingdon train station, with direct rail links to London King’s Cross.What you’ll be doing…Prepare and analyse weekly stock reports (stock holding, write-offs and BBE risk)Support month-end close through reconciliations, journals and variance analysisAssist with internal and external stock audits, including store and warehouse countsReview and communicate café wastage and stock adjustment trends to stakeholdersMaintain and improve existing Excel-based stock models and reconciliationsSupport the development of automation and Power Query/Power BI reporting to improve visibility of stock movements and risksReview and enhance existing processes to drive efficiency and improve insight for budget holdersWho you are…Essential:Advanced Excel skills (e.g. SUMIFS, XLOOKUP, Pivot Tables, data modelling)Confident working with large data sets from multiple systems (D365, Enactor, Elucid, SQL)Strong analytical skills with curiosity to identify root causes and propose solutionsExperience in an accounting or finance environment, including journal postings and reconciliationsExcellent attention to detail and commitment to data accuracyStrong interpersonal skills with the ability to partner effectively across finance and operationsDesirable:Experience using Microsoft Dynamics 365 (D365) or similar ERP systemsExposure to Power Query or Power BIExperience interacting with Warehouse Management Systems (WMS) and till reporting (Elucid, Enactor or similar)Understanding of stock accounting principles and IAS 2 "