Finance Analyst (6-month FTC / Graduate Opportunity)

Rutherford Cross; Glasgow; On-site; GBP 30,000 - 40,000; Full time

Job summary

A prominent financial recruitment firm seeks an Interim Finance Analyst in Glasgow for a 6-month contract, potentially permanent. Ideal candidates are recent accountancy graduates or early career finance professionals. Responsibilities include managing financial reports, handling aged debts, and maintaining SAP data integrity. Candidates must possess highly developed Excel skills and analytical abilities to provide meaningful insights. Contact Euan Bodie for more information at the provided email.

Qualifications

• Recent accountancy graduate or early career finance professional.
• Strong analytical skills with the ability to create meaningful reports.
• Proficient in Excel for large data handling.

Responsibilities

• Monitor aged debts and perform credit checks.
• Manage inbox and address queries.
• Create and maintain various financial reports.

Skills

Highly developed Excel skills

Ability to manipulate large data sets

Analytical interpretation of data

Organizational skills under tight deadlines

Flexibility and adaptability

Education

Recent accountancy graduate

Tools

SAP

Job description

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

• 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

• 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

• 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 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: [e-mail]

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.