Treasury & Reporting Analyst

LPUK LeasePlan UK Ltd; Bristol; On-site; GBP 42,000 - 55,000; Full time

Benefits offered by this job

Contributory pension

Annual salary review

Bonus scheme

GAYE scheme

Employee referral bonus

Discount programme

GymFlex

Cycle to Work

Health & wellbeing benefits

25 days leave

Job summary

Ayvens UK seeking a Treasury & Reporting Analyst to support a Bristol-based finance team. You will monitor daily cash and assist in monthly funding processes, producing management information for internal and external stakeholders.

The role requires strong Excel and data skills, with experience in SAS/SQL/VBA preferred. You’ll work with velocity in a fast-paced environment and contribute to improving financial reporting and controls.

Qualifications

• Experience working with large datasets in Excel.
• Experience with SAS, SQL, VBA or Visual Basic is preferred.
• Self-starter with initiative and proactive problem solving.
• Ability to communicate financial concepts to non-finance stakeholders.

Responsibilities

• Monitor cash position and manage monthly funding streams.
• Oversee production of MI for internal and external stakeholders.
• Assist in monthly processes for funding sources.
• Use funding and markets insight to help set interest rates.
• Develop and maintain reports and spreadsheets for finance.

Skills

Advanced Excel

Analytical skills

Communication skills

Collaborative

Numerical ability

Tools

SAS

Visual Basic

VBA

SQL

Job description

Job Overview

Treasury & Reporting within Ayvens UK is responsible for managing funding and interest rate risks, banking and cashflows, and providing MI across the business and into the Ayvens group. We’re currently seeking a Treasury & Reporting Analyst to support the team, based within our Bristol based finance team, reporting to the Treasury & Reporting Manager.

Key Purpose

Monitor Cash Position and use this to help manage monthly funding streams. Oversee production of MI for internal and external stakeholders and assist in monthly processes for the various funding sources. Use funding and markets insight to help set and maintain interest rates at appropriate levels.

Key Accountabilities

• Cashflow: Upkeep of the daily cashflow spreadsheet. Monitor cashflow levels and correct as appropriate.
• Funding: Assist in the management and administration of all funding schemes. Enter new loans into the relevant reporting tools and ensure cashflows are posted correctly in finance systems.
• Produce monthly and quarterly reports on the Funding schemes.
• Interest Rates: Ensure interest rates are set and maintained at appropriate levels. Assist with the management of the Interest Rate charts and COBF tables.

Projects

• Provide expert support to various Finance functions through development and upkeep of existing reports and spreadsheets using SAS, VBA and SQL.
• Ad hoc modelling and analysis of large data sets to inform ALD strategy.
• Development of reports and processes to improve and ensure data integrity within Finance.
• Assist with the development and upkeep of the Finance SharePoint site.
• Assist in the creation and improvement of the monthly Fleet and Orderbank reporting to UK and International stakeholders.
• Assist in the production of the Treasury Committee Pack.
• Banking: Administration of current bank accounts and finance payment and DD solutions, and development of banking systems/processes.

Skills, Experience & Background

• Proficient in Microsoft Office, especially Excel to an advanced level with experience of working with large datasets.
• Experience in SAS, Visual Basic, VBA or SQL preferred.
• Self‑starter with the ability to take initiative and work proactively; ideally with experience of process improvement.
• Experience of financial reporting and/or experience working in a finance department preferred.
• Strong numeric and analytical skills with the ability to interpret complex financial data and trends.
• Proactive attitude with proven ability to take ownership for resolving problems and queries.
• Excellent communication and interpersonal skills; ability to effectively communicate financial concepts to non‑finance stakeholders.
• Proven ability to work collaboratively in a fast‑paced environment and effectively manage multiple priorities.
• Planning, prioritising and meeting deadlines in a fast‑paced and complex environment.

What we offer

• Competitive remuneration package incl. contributory pension scheme, annual salary review and bonus scheme, Give As You Earn (GAYE) scheme, employee referral scheme (£1,000).
• Retail discounts programme, GymFlex membership options, Cycle to Work scheme.
• Health & wellbeing: life assurance, health assessment options, travel insurance, dental insurance, critical illness cover, personal accident insurance.
• 25 days’ annual leave + an additional Celebration Day, 37.5 hour week, Monday to Friday, no weekends, holiday buy & sell scheme, volunteer days, time allocated for personal development, study support (where applicable).
• Workplace & On‑Site Facilities: free parking, EV charging points, bike storage & shower facilities, complimentary breakfast, staff and social events.

EEO Statement

Studies have shown that women and people of colour are less likely to apply for an opportunity unless they exactly meet the criteria specified. At Ayvens we are committed to building a diverse, inclusive, enjoyable and authentic workplace so if you are excited by this, or any role at Ayvens but your experience doesn’t exactly align, we would encourage you to apply regardless! What’s the worst that can happen?!