Insight & Reporting Analyst

Role overview

Key purpose and responsibilities

• Produce, maintain and enhance Asset Risk reports and dashboards, ensuring accuracy, relevance and timely delivery.
• Support reporting, visualisation and automation solutions using Power BI, SAS and other tools.
• Analyse data and provide insight to help identify trends, risks and opportunities.
• Develop Power BI dashboards, reporting solutions and datasets for visibility of business metrics and risks.
• Deliver regular and ad hoc Asset Risk reporting and analysis for decisions, projects and stakeholder requirements.
• Analyse industry, fleet, residual value, maintenance and pricing data, identifying risks and recommending actions.
• Improve data quality, reporting accuracy and controls through analysis, process development and automation.
• Collaborate with Asset Risk and Finance teams on reporting needs and shared data solutions.
• Support pricing system testing, implementation and user training for enhancements.
• Comply with internal governance, control and audit requirements in reporting and data management.

Skills and experience

• Advanced Excel proficiency, including pivot tables, complex formulas and macros.
• Experience developing data visualisations and dashboards using Power BI.
• Strong analytical skills and experience using SQL, VBA, SAS or similar tools for data manipulation, reporting and automation.
• Ability to produce useful regular and ad hoc reports for technical and non-technical stakeholders.
• Understanding of data governance, data quality and effective controls.
• Clear written and verbal communication and presentation skills.
• Strong organisation and time management to handle multiple priorities and deadlines.
• Experience identifying, implementing and supporting process improvements and automation.

Rewards and financial benefits

• Competitive pension scheme, annual salary review and bonus scheme.
• Give As You Earn scheme, employee referral scheme, retail discounts and GymFlex membership options.
• Cycle-to-Work scheme.

Time off and work-life balance

• 25 days of annual leave plus an additional Celebration Day.
• 37.5-hour week, holiday buy-and-sell scheme and volunteer days.
• Time for personal development and study support where applicable.

Workplace facilities

• Facilities include EV charging points, bike storage and showers, complimentary breakfast, and staff and social events.

About Ayvens