REQUIREMENTS:

Previous commercial analyst experience
Previous experience with SQL Basics, Macros and Power Query within Excel
Previous experience working with large datasets and Sales cubes / databases
Previous experience developing new reporting
Previous experience of working within a finance function, with the ability to demonstrate a clear understanding of Gross Margin and profit drivers
Past history of identifying and implementing process improvements
Qualified/Part Qualified Accountant desirable but not necessary
Confident, self-motivated with excellent attention to detail
Flexible, punctual, and able to meet multiple deadlines
Excellent communication skills, both written and verbal
Be commercially minded with ability to deliver a high level of customer service to your business partners within the organisation and the SLT
Highly organised with a ‘can do’ approach taking ownership for managing own workload
Able to identify problems and make decisions, taking appropriate action to resolve issues
Competent user of Microsoft packages with expert level Excel skills
Salary
40,000
Hours
37.5
Contract type
Fixed Term Contract
Location
NWF Agriculture Wardl

Reporting
Prepare and issue weekly PSA reports
Prepare and issue PSA raw material allocation and MMx %
Prepare and issue PSA offtake reporting
Prepare and issue weekly Sales and Margin Reporting for C&B
Prepare and issue all month end Sales and Margin Reporting
Prepare and issue all month end PSA information
Prepare and issue all in month reporting for Traded Products revenue streams
Automate reporting wherever possible
Design new suites of reporting to aid strategic decision making and track results against these decisions.
Create new reporting/analysis for any new ad hoc commercial queries.
Budgeting and Forecasting
Provide key information and insight around volume and margin trends on C&B and liaise with the FD/SLT to reforecast sales on a monthly basis.
Using analysis and discussion with Traded product heads, produce a monthly reforecast for all traded product revenue streams.
Management and support of the annual budget process for all revenue streams using a bottom up approach by Sales Rep.
PSA New Contract monitoring
Monitor new contracts put on ensuring they are at an appropriate margin, challenging anything below expected margin levels
Perform control checks on raw material prices used and margin approved on new PSA’s entered
Challenge back to Customer Service Desk (CSD) any Compound contracts that look to be incorrectly entered when doing weekly reporting
Challenge back to Blends admin any Blend contracts that look to be incorrectly entered when doing weekly reporting
PSA Offtake monitoring
Throughout the month review usage of PSA against contract quantity
Work with Financial reporting accountant to resolve any price queries identified when weekly sales reports are run
Ensure customers take full contract (ie don’t under or over order) where this improves profitability
Work with sales reps, CSD, blends team and group owners to manage anyone taking too much / too little against their contract.
Review and monitor CSD / Blends team / customers taking same / similar products using PSA price but not allocating them to contract. Ensure everything priced at contract levels is transacted against a PSA.
Close out unused PSA’s with the business and adjust PSA’s being under used.
PSA Raw Material allocation
Work with procurement team to find better ways to allocate, monitor and report the raw materials forward bought for PSA’s, separating them from raw materials bought for in month ‘spot’ (non-contractual) business
Work with procurement and formulations team to help them improve the process around the recording of group/wholesale/merchant PSA’s in the system as their accuracy in terms of raw materials needs improvement
Proactive contract management
Work with CSD & Blends team to introduce new process to proactively call and manage customers and book in orders in advance, instead of just taking orders when customer rings.
Work with CSD / Blends / Technical / Operations / Transport to make PSA process work as efficiently as possible for the business
Work with CSD / Blends to develop clear process to finalise / close out PSA’s once the month has finished / products have been taken.
Relationship / business management
Develop strong relationships with key role stakeholders
SLT – especially MD, FD and Sales Directors
Sales Managers and Sales Reps
CSD team leader and CSD team
Blends admin team leader and Blends admin team
Finance team
Procurement team
Technical team
Operations & Transport teams
Must be able to clearly and concisely present information to the above people, to quickly action new reporting as and when required and discussed, to influence their decision making, improve the process and profitability around aspect of commercial sales reporting and margin and be strong enough to challenge business on its current ways of working and drive through suggested changes and improvements.