Commercial Data Analyst

Fast-growing beer brand

  • Location : All London, Central London, North London
  • Salary : £32,000 - £35,000 + bonus
  • Contract : Full Time
  • Nearest Station : Liverpool Street
  • Application Closing Date : 11 February 2022
  • Placement : Graduate Job ( permanent )
  • APPLY
  • SAVE
    • All London, Central London, North London
    • £32,000 - £35,000 + bonus
    • Full Time
    • Liverpool Street
    • 11 February 2022
    • Graduate Job ( permanent )

    Company Description

    This high-flying craft beer brand are looking for a Finance Assistant to play a key role in the day to day financial operations of the brewery. 

    You will be responsible for all data insights for the sales business and will become an ERP Super User within the business. Ideally you will have some sort of work experience business partnering and working in FP&A (not wholly essential), what is more important is your advanced knowledge of Excel e.g. Power Pivot, Power Query & VBA macros, also experience and good knowledge of SQL.

    The role would be ideal for a candidate with a degree in Finance or some kind of background in Data Analytics.
     

    Job Description

    This pivotal role is responsible for all the data insights & intelligence within the commercial team, while at the same time leading the development & knowledge of SAP within the commercial team on a day to day basis. The role is recognised as an ERP Super User within the business & therefore maybe required on an ad hoc basis to support broader business ERP initiatives outside of the Commercial team  
     
    What are the role responsibilities?
     
    - Converting both internal & external data into a legible format for the business that is easy to understand and focussed around our business & brands.
    - Add value every day through taking raw data (insights) and turning them in actionable information for the Commercial team to use in the market.  
    - Track and report against overall business targets i.e. Volume / Rev per Hl / Channel performances vs budget etc etc. on a weekly/monthly basis
    - Track and report against all sales territory targets, i.e.
       - Journey plan adherence
       - Volume vs target
       - Net POCs pouring (gains & losses)
       - Single/Double/Triple tap pouring customers
       - Individual and collective performance vs targets
       - Ongoing tracking of all POC execution standards
    - Update territory journey planning cycles as further new business comes on board
    - Track all font placement & contracts
    - File all customer commercial contracts
    - Lead ad hoc projects as required e.g.
    - Lead the weekly/monthly volume forecasting
       - New for Old keg destruction
       - Hold all meeting action logs centrally
    - To be the ERP Super User for the Commercial Team.  Triage ERP (including OBeer & SAP queries) from Users and Expert Users within the Commercial team, solving issues where possible or escalating on to the IT department (who will either resolve with Finance or with Vision 33 Support team).
    - The Super User will assist the other Super Users and IT team to implement any upgrades or new functionality that affect the Commercial team, for example EDI, EMCS, Third Party Logistics etc.
     
    Skills & Experience:
     
    Previous experience business partnering, business support and working in FP&A essential 
    Proficient with SQL essential
    Advanced knowledge of Excel essential (including Power Pivot, Power Query & VBA macros)
    Finance qualification – desired not essential
    Previous experience in Data Analytics essential
    Strong analytical capability to interpret data & turn the insight into actions
    Ability to work under pressure and manage a lot of differing tasks
    Strong organisational skills 
    Impeccable time management skills 
    A proven inclusive way of working that brings people together.
    Strong personal drive & focus on results 
    Demonstrated diligence and ability to follow through on all commitments (internal and external stakeholders)
  • APPLY
  • SAVE