Treasury and Reporting Analyst

Ayvens Group; Bristol; On-site; GBP 40,000 - GBP 50,000; Full time

Job summary

A leading automotive leasing company in Bristol seeks a Treasury and Reporting Analyst. The role involves monitoring cashflows, managing funding schemes, and producing reports using advanced Excel, Power BI, SAS, and SQL. Candidates should possess strong communication skills, attention to detail, and a commitment to process improvements. The position offers a competitive salary, generous pension scheme, and various employee benefits including 25 days holiday and sustainability initiatives.

Benefits

Generous contributory pension scheme

25 days holiday plus bank holidays

Volunteering days

Sustainability initiatives

Employee Referral Scheme

Subsidised onsite catering

Qualifications

• Proven experience in financial reporting within a finance team.
• Advanced proficiency in Excel with large datasets.
• Strong attention to detail and excellent organizational skills.

Responsibilities

• Monitor and update the daily cashflow spreadsheet.
• Assist in the management of all funding schemes.
• Produce monthly and quarterly reports on funding schemes.
• Provide expert support through development of reports using SAS, VBA, and SQL.

Skills

Financial reporting

Advanced Excel

Power BI

Problem-solving

SAS

VBA

SQL

Organizational skills

Job description

Treasury and Reporting Analyst page is loaded## Treasury and Reporting Analystlocations: Bristol CECtime type: Full timeposted on: Posted Todayjob requisition id: JR\_10037583**At Ayvens, progress starts with you.**Our ambitions to shape the future of sustainable mobility are powered by our talent. Join us, and get better with every move.We have an exciting opportunity for a Treasury and Reporting Analyst to join our finance team located in Lyde Green, Bristol (BS16 7LB). The Finance team is responsible for supporting the achievement of Ayvens strategic objectives through accurate financial reporting, transactional accounting and treasury management. We are specifically keen to hear from applicants who have experience in financial reporting, are an advanced excel user and have strong Power BI skill set.The key responsibilities of the role are as follows:* Monitor and update the daily cashflow spreadsheet.* Monitor cashflow levels and correct as appropriate.* Assist in the management and administration of all funding schemes.* Enter new loans on to the relevant reporting tools.* Produce monthly and quarterly reports on the funding schemes.* Assist with the management of the Interest Ratecharts mailbox.* Ensure interest rates are set and maintained at appropriate levels.* 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 the various finance systems.* Assist with the development and upkeep of the finance sharepoint site.* Assist in the creation and improvement of the monthly reporting to UK and International stakeholders.* Assist in the production of the Treasury Committee Pack.Skills and experience required* Proven ability in taking ownership for resolving problems and queries.* Proficient in Microsoft Office i.e. Excel to advanced level with experience of working with large datasets.* Excellent communication, written, verbal and strong numeracy skills.* Experience in Power BI, SAS , Visual Basic, VBA, SQL.* Strong attention to detail with excellent organisational skills, with the ability to prioritise, multitask and work to tight deadlines.* Ability to identify and deliver process improvements.* Highly competent in Microsoft office with particular focus on Word and Excel.* Experience of financial reporting in within a finance team is preferred.What we offer* Generous contributory pension scheme* 25\* days holiday, in addition to bank holidays(pro rata)* Volunteering days to assist in charity work* Sustainability Initiatives* Holiday buy / sell (subject to conditions)* Employee Referral Scheme* Subsidised onsite catering* EV charging points (cost associated), bike storage, shower & changing facilities and car parkingWith over 3.4 million vehicles managed across more than 42 countries, we provide full-service leasing, flexible subscription services, fleet management services and multi-mobility solutions to customers of all sizes, including large corporates, SMEs, professionals, and private individuals. By leveraging our unique position to lead the way to net zero and further shape the digital transformation of the industry, we are well-positioned to meet the evolving mobility needs of our clients and provide them with the solutions they need to thrive.At Ayvens, we believe that our success is driven by our commitment to customer satisfaction. Our team is dedicated to delivering innovative solutions and technology-enabled services that help our customers focus on their everyday business. We’re committed to sustainable mobility and have made it a core part of our strategy. In everything we do, we’re guided by the principles of authenticity, curiosity, commitment and collaboration. We aim to foster an organisation that's diverse in people and ideas, where everyone can thrive and be themselves, no matter who they are.Join us on this exciting journey as we continue to enable the transformation towards large scale adoption of sustainable mobility and provide our customers with the solutions they need to succeed. Follow our page for the latest updates, news, and insights.\*ALD Automotive | LeasePlan are rebranding to Ayvens across all 42 countries by 2025.