Insight & Reporting Analyst

Leaseplan; Bristol; On-site; GBP 42,000 - 62,000; Full time

Benefits offered by this job

Competitive pension scheme

Annual salary review and bonus scheme

Employee referral scheme (£1,000)

Retail discounts programme

GymFlex membership options

Cycle to Work scheme

Time Off & Work-Life Balance 25 days'+

37.5 hour week

Holiday buy & sell scheme

Volunteer days

Time allocated for personal developmen

Study support (where applicable)

Workplace & On‑Site Facilities

EV charging points

Bike storage & shower facilities

Complimentary breakfast

Staff and social events

Job summary

Ayvens is seeking a skilled Asset Risk Reporting Analyst in Bristol to develop and maintain Power BI dashboards and reporting datasets. You will produce regular Asset Risk analyses and collaborate with Finance to deliver data solutions, improving data quality and governance.

Proficiency in Excel, SQL, VBA and SAS, plus experience with Power BI dashboards, will support insights for business decisions and risk management across the fleet and pricing data.

Qualifications

• Advanced proficiency in Microsoft Excel, including pivot tables, complex formulas and macros, with strong data analysis and reporting capabilities.
• Experience developing data visualisations and dashboards using Power BI to support business decision‑making.
• Strong analytical skills with experience using SQL, VBA, SAS or similar tools for data manipulation, reporting and automation.

Responsibilities

• Develop, maintain and enhance Power BI dashboards, reporting solutions and datasets to provide accurate, timely insights and improve visibility of key business metrics and risks.
• Produce regular and ad hoc Asset Risk reporting and analysis to support business decision‑making, projects and stakeholder requirements.
• Analyse industry, fleet, residual value, maintenance and pricing data, identifying risks and recommending appropriate actions.
• Improve data quality, reporting accuracy and controls through advanced data analysis, process development and automation.
• Collaborate with Asset Risk and wider Finance teams to deliver reporting requirements and common data solutions.
• Support pricing system testing, implementation and user training for system enhancements.
• Ensure reporting, analysis and data management activities comply with internal governance, control and audit requirements.

Skills

Analytical thinking

Communication skills

Time management

Tools

Power BI

SQL

VBA

SAS

Excel

Job description

• Produce, maintain and enhance Asset Risk reporting and dashboards, ensuring accuracy, relevance and timely delivery.


• Support the development of reporting, visualisation and automation solutions using Power BI, SAS and other reporting tools.


• Provide meaningful analysis and insight through reporting and data interrogation, supporting the Asset Risk team in identifying trends, risks and opportunities.


• Identify, investigate and resolve data quality issues to improve confidence in reporting and decision‑making.

Responsibilities

• Develop, maintain and enhance Power BI dashboards, reporting solutions and datasets to provide accurate, timely insights and improve visibility of key business metrics and risks.


• Produce regular and ad hoc Asset Risk reporting and analysis to support business decision‑making, projects and stakeholder requirements.


• Analyse industry, fleet, residual value, maintenance and pricing data, identifying risks and recommending appropriate actions.


• Improve data quality, reporting accuracy and controls through advanced data analysis, process development and automation.


• Collaborate with Asset Risk and wider Finance teams to deliver reporting requirements and common data solutions.


• Support pricing system testing, implementation and user training for system enhancements.


• Ensure reporting, analysis and data management activities comply with internal governance, control and audit requirements. Advanced proficiency in Microsoft Excel, including pivot tables, complex formulas and macros, with strong data analysis and reporting capabilities.


• Experience developing data visualisations and dashboards using Power BI to support business decision‑making.


• Strong analytical skills with experience using SQL, VBA, SAS or similar tools for data manipulation, reporting and automation.


• Ability to produce regular and ad hoc reports that provide meaningful insights to technical and non‑technical stakeholders.


• Understanding of data governance, data quality principles and the importance of maintaining effective controls.


• Excellent written and verbal communication skills, with the ability to present complex information clearly to a range of audiences.


• Strong organisational and time management skills, with the ability to manage multiple priorities and deadlines.


• Experience identifying, implementing and supporting process improvements and automation initiatives.

Why Ayvens?

With over 3.1 million vehicles managed across more than 40 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.

• Competitive 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


• Time Off & Work-Life Balance 25 days' annual leave + an additional Celebration Day


• 37.5 hour week


• Holiday buy & sell scheme


• Volunteer days


• Time allocated for personal development


• Study support (where applicable)


• Workplace & On‑Site Facilities


• EV charging points


• Bike storage & shower facilities


• Complimentary breakfast


• Staff and social events