Insight & Reporting Analyst

Ayvens; West of England; On-site; GBP 42,000 - 54,000; Full time

Benefits offered by this job

Pension scheme

Annual salary review and bonus scheme

GAYE scheme

Employee referral scheme

Retail discounts programme

GymFlex membership options

Cycle to Work scheme

Job summary

Ayvens is seeking an Insight & Reporting Analyst to join the Finance Team. You will transform complex data into meaningful insight, support decisions with reporting, visualization and analytical recommendations across Asset Risk and Finance.

Develop and enhance Power BI dashboards, perform regular Asset Risk reporting, and collaborate with Finance to improve data quality and automate processes.

Qualifications

• Advanced proficiency in Microsoft Excel, including pivot tables, complex formulas and macros.
• Experience developing data visualisations and dashboards using Power BI.
• Strong analytical skills with SQL, VBA, SAS or similar tools for data manipulation.
• Ability to produce regular and ad hoc reports for technical and non-technical audiences.
• Understanding of data governance and data quality controls.
• Excellent written and verbal communication skills.
• Strong organisational skills and ability to manage multiple priorities.
• Experience identifying and supporting process improvements and automation.

Responsibilities

• Develop, maintain and enhance Power BI dashboards, reporting solutions and datasets.
• Produce regular and ad hoc Asset Risk reporting and analysis to support decisions.
• Analyse industry and pricing data to identify risks and actions.
• Improve data quality and controls through analysis and automation.
• Collaborate with Asset Risk and Finance teams to deliver reporting requirements.
• Support pricing system testing, implementation and user training.
• Ensure reporting and data management comply with governance and audit requirements.

Skills

Advanced Excel skills

Data analysis

Excellent communication

Time management

Stakeholder engagement

Data governance understanding

Tools

Power BI

SQL

VBA

SAS

Job description

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 are currently seeking an Insight & Reporting Analyst to join the Finance Team at Ayvens. This is an exciting opportunity for a data-driven analyst who enjoys transforming complex data into meaningful insight. The role will play a key part in supporting business decisions through reporting, visualisation and analytical recommendations across Asset Risk and Finance.

Key Purpose

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

Skills, Experience & Background

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

_ What we offer _

Rewards & Financial Benefits

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

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 or current hours don’t exactly align, we would encourage you to apply regardless! What’s the worst that can happen?!

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.

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.