Inventory Analyst - 6 Month FTC

IMPACT EVOLVECheltenhamJob.boveröffentlicht 18.11.2026
Muss:DataHybrid

Job Description Role: Inventory Analyst Location: College Farm, Cheltenham, GL54 2HN / Hybrid Contract:*6-month fixed-term contract Start date: Immediate. Please only apply if you can start within the next two weeks. Reporting to:** Logistics Manager

Role Purpose Hawkstone is one of the fastest growing premium beer and cider brands in the UK, operating across retail, hospitality, direct to consumer and merchandise channels. As the business scales, the volume and complexity of stock movements, inventory records, production inputs and fulfilment activity continue to increase.

The Inventory Analyst plays a critical role in making sure the stock figures the business relies on are accurate. Over a six-month fixed-term contract, the role owns the reconciliation and analysis of stock across Hawkstone sites and third-party locations, ensuring that physical stock, system stock and financial records remain aligned.

Working closely with supply chain, logistics, finance, production partners and site teams, the Inventory Analyst will reconcile stock positions, analyse and explain variances, clear historic discrepancies and put in place a reconciliation and reporting routine the team can run going forward.

This role requires an analytical and detail focused individual with strong Excel skills, who is comfortable working with large data sets from multiple systems, can trace a variance back to its source transaction, and can explain findings clearly to operational and finance teams.

Key Responsibilities Stock Reconciliation Reconcile system stock against physical counts and third-party warehouse reports across all Hawkstone and partner locations. Own stock count and month end reconciliations, ensuring system, physical and finance positions agree.

Transaction Reconciliation Reconcile stock movements against purchase orders, goods receipts, production records, transfers and invoices. Identify unprocessed or incorrectly booked transactions and agree corrections with the relevant teams.

Variance Analysis Analyse stock variances by product, batch, location and transaction type, and quantify their value. Present clear, evidenced explanations of variances to the Logistics Manager and Finance.

Stock Accuracy Investigations Investigate and resolve stock discrepancies, missed deliveries, booking errors, incorrect locations and unexplained inventory movements. Identify root causes, coordinate corrective action and maintain clear action logs until issues are closed.

Historic Discrepancy Clean-Up Review aged and open purchase orders, batches, transfers and adjustments, and close or correct them. Clear the backlog of unresolved discrepancies within the contract period.

Returns, Damages & Quarantine Reconcile returned, damaged, rejected and quarantined stock, ensuring system status and stock value are correct. Track stock through investigation, credit, rework, release, disposal or approved write off.

Stock Reporting & Analysis Build and maintain Excel reporting on stock accuracy, variances, adjustments, aged transactions and stock value by location. Provide stock data and analysis to support month end and finance reporting.

Process Improvement & Handover Recommend controls to prevent repeat variances and improve inventory processes as the business grows. Document the reconciliation routine and reporting templates so the team can run them after the contract ends.

Key Stakeholders Internal

  • Supply Chain & Logistics
  • Finance
  • Production Teams
  • Quality and Compliance
  • Site and Warehouse Teams

External

  • Production partners and breweries
  • Third party warehouses and logistics providers

Skills & Experience Essential

  • Experience in a stock analyst, inventory analyst, stock control or stock reconciliation role.
  • Proven experience of stock reconciliations, including system to physical and stock to finance at month end.
  • Advanced Excel skills, including pivot tables, XLOOKUP or VLOOKUP, SUMIFS and reconciling large data sets from multiple sources.
  • Experience analysing stock variances and tracing them back to the transactions that caused them.
  • Confident extracting and working with data from ERP, WMS or inventory systems.
  • High attention to detail and accuracy, particularly when working with product codes, batches, quantities, locations and stock values.
  • Clear communication skills, with the ability to report findings to operational and finance teams.
  • Available to start within the next two weeks.

Desirable

  • Experience with Power Query, Power BI or SQL.
  • Experience within FMCG, alcoholic beverages, brewing, food manufacturing or another fast-moving stock environment.
  • Experience reconciling inventory across multiple sites or third-party logistics locations.
  • Exposure to duty suspended or traceability sensitive inventory.
  • Experience supporting month end stock valuation with a finance team.

Personal Attributes

  • Analytical, with a strong instinct for identifying information that does not reconcile.
  • Methodical and accurate, working each variance through to a clear, evidenced conclusion.
  • Self-directed and able to prioritise a backlog of reconciliations with limited supervision.
  • Comfortable challenging data and asking operational teams for supporting evidence.
  • Able to explain findings clearly to people without an analytical background.
  • Calm and solutions focused when working to month end and other deadlines.
  • Committed to leaving processes documented so others can carry them on.

Why This Role Is Critical As Hawkstone continues to scale, accurate stock information is essential to maintaining product availability, protecting margin, supporting compliant operations and making decisions using reliable data.

This role provides the analysis and reconciliation needed to bring physical stock, system records and financial information into line across the supply chain.

By the end of the contract, stock will be reconciled across all locations, historic discrepancies closed, and a documented reconciliation and reporting routine in place to support the next stage of Hawkstone’s growth journey.