Finance Analyst (6-month FTC / Graduate Opportunity)
New Today
Interested in learning more about this job Scroll down and find out what skills, experience and educational qualifications are needed.
Rutherford Cross is delighted to be working in partnership with one of Scotland's most iconic FMCG brands based in Glasgow City Centre to appoint an Interim Finance Analyst for a 6-month period. This is a 6-month contract that will have the potential to be made permanent. This role will suit a recent accountancy graduate or someone in the infancy of their finance career.
Role & Responsibilities:
Daily Tasks
Monitoring aged debts and carrying out customer credit checks (now mostly handled by Kath, but still required occasionally)
Managing inbox and actioning queries
Raising POs
Processing and reviewing bank statements
Maintaining SAP (clearing Shopify receipts, tidying accounts, resolving system issues)
Enforcing the purchasing approval matrix
Handling supplier and invoice queries
Supporting colleagues with SAP issues (posting errors, invoice blocks, PO matching problems, stock issues)
Creation and maintenance of Statement of Processes – for both reporting and month-end tasks
Creation of Private Cask invoices
Training colleagues on Excel re data manipulation, formulas, pivots, logic
Reconciling filling, disgorging, cask sales and spirit quantity data in Cask Management, Spirit Cost and SAP
Month-End Tasks
(completed jointly with Finance Manager)
Upload Supplier Invoices to SAP
Run Receivables and Payables Reports
Reconcile Bank Balances to SAP
Run Shopify Sales Report, clear balances and upload fees report
Process Bank Statement Imports
Post Month-End Journals
Manage Clearing Processes (Depreciation, WIP, GR/IR)
Process VAT Returns
Produce various Analysis spreadsheets required for reporting purposes
Aged Debtors / Aged Creditors Reconciliation
Balance Sheet Reconciliations
Open New Accounting Periods in SAP
Reporting Responsibilities:
(This is the largest portion of time spent)
Creating bespoke financial reports and data models for colleagues
Cleansing and restructuring large data dumps (Sales Data, BD Data, Duty Reports, P&L extracts)
Standardising reporting structures (consistent column names, corrected product families, corrected customer groupings)
Improving workflows to reduce manual work (e.g., dynamic formulas, automation logic, templates)
Fixing incorrect mappings and coding in datasets used by Sales, Marketing, and Operations
Weekly updates of Shopify, SAP, and Volumes YTD spreadsheets
Maintaining and developing:
Regional Sales Report
Performance Analysis Report
2026 Sales Forecasting tools
Developing spreadsheet reporting for specific projects e.g.:
Regional Sales Report
Performance Overview Report
Providing Business Development cost analysis v budget & forecast for Commercial and Sales & Marketing teams
Product pricing and discount analysis
Production of planned procurement spend to support production and sales budgets/forecasts
Support the reporting of alcohol duty and required spreadsheet work
Maintaining the integrity of the cask management and cost spreadsheets, ongoing reconciliation with SAP xcunqrw and supporting the production and maturation team as regards data input and maintenance
Maintaining the product master data set
Maintaining the integrity of the monthly stock reports and periodic stock take data
Fault-finding and spreadsheet troubleshooting across the business
Key Skills Required:
Highly developed Excel skills, including the ability to manipulate large data sets downloaded from SAP and other sources
Personal Profile:
Analytical, capable of interpreting data outputs into meaningful reporting, analysis and insight
Highly organised, capable of working to tight timescales
Flexibility and adaptability, capable of multi-tasking depending on business priorities
For more information, please contact Euan Bodie at Rutherford Cross
Our client is an equal opportunities employer and positively encourages applications from suitably qualified and eligible candidates regardless of sex, race, disability, age, sexual orientation, gender reassignment, religion or belief, marital status or pregnancy and maternity.
- Location:
- Glasgow
- Job Type:
- FullTime
- Category:
- Banking And Financial Services