Data and Insights Analyst

The Opportunity

As Data and Insights Analyst, you will join our Data, MI & Automation team at an exciting point in our transformation journey. As the business continues to grow and our data capabilities evolve, you will have the opportunity to contribute to how reporting and insight are delivered across the organisation.

You will support the production of established, business-critical Management Information while helping to shape its future. This includes learning to challenge existing ways of working, simplifying and automating manual processes, and helping transition our reporting estate towards modern, scalable solutions using Power BI, Power Platform, and emerging data, AI & automation capabilities.

Working within a collaborative team of eight and reporting to the Head of Data, MI & Automation, you will gain broad exposure across the business. You will also be closely involved in data governance, helping to log, investigate and close down data issues alongside Data Governance, IT and Operations colleagues.

This role is a great opportunity for someone who enjoys making things better, wants to build their experience with modern reporting and automation tools, and is excited to help shape the future of reporting and insight within a growing business.

Key Responsibilities

• Produce and deliver accurate, timely recurring MI and business-critical reporting to stakeholders, including running and maintaining established legacy Excel and VBA-based reporting processes.
• Support the continuity and reliability of existing reporting while contributing to its progressive improvement and modernisation.
• Help assess manual and spreadsheet-based reporting to identify opportunities for automation, simplification and migration to governed BI solutions, reducing manual effort and operational risk.
• Build, enhance and maintain Power BI reports, datasets and data models aligned with enterprise standards, with a focus on clear, effective and user-friendly reporting.
• Use Power Query and Power Automate, alongside appropriate reporting tools, to automate data preparation, refresh and report distribution where this delivers business value.
• Handle ad hoc reporting and data requests, translating business questions into appropriate reporting solutions and balancing these with recurring BAU delivery.
• Work with stakeholders across the business to understand reporting requirements, ask constructive questions, and help recommend solutions that improve decision-making and user experience.
• Take an active role in data governance and quality control by raising, logging and investigating data issues and reconciliation discrepancies, and working with Data Governance, IT and Operations teams to help drive closure of data issues
• Maintain clear documentation of report definitions, data sources, calculations, refresh schedules and source-to-report lineage, applying relevant data governance and metadata standards.
• Contribute to report rationalisation by identifying duplicate, redundant or low-value reports and supporting their controlled retirement or consolidation.
• Support self-service reporting capability by helping to create reusable, governed BI assets and assisting users in making effective use of Power BI and related tools.
• Bring forward practical ideas for process improvement and better use of data, and share knowledge and good practice with colleagues.

Required Qualifications

• Experience in MI, reporting or Business Intelligence, with the ability to deliver reporting accurately and to deadline with appropriate guidance.
• Strong Excel skills, with experience supporting spreadsheet-based reporting; exposure to legacy or macro/VBA-based reporting processes is advantageous.
• Working Power BI capability, including building reports and data models, writing DAX measures, and publishing to workspaces; willingness to develop further.
• Working knowledge of Power Query and an interest in automating reporting or data preparation processes; experience with Power Automate is desirable.
• Working knowledge of SQL, including the ability to query, join and validate data from multiple sources.
• Strong data quality mindset, with experience checking and reconciling outputs and investigating data discrepancies, and identifying opportunities to automate or improve manual processes.
• Understanding of data governance principles, including issue management, documentation standards and controlled change.
• Good analytical and problem-solving skills with strong attention to detail.
• Good stakeholder and communication skills, with the ability to understand business needs and explain technical concepts clearly to non-technical audiences.
• Self-motivated and proactive, with a desire to identify improvement opportunities and see them through to delivery.
• Ability to manage your own workload across recurring reporting commitments, transformation activity and ad hoc requests.
• Awareness of emerging AI capabilities relevant to data and reporting, with curiosity about how they can be applied appropriately across reporting and automation activities.

Preferred Qualifications

• 1-3 years of relevant experience in BI, MI, reporting or analytics, with experience of delivering reports and dashboards.
• Degree in a quantitative or business discipline, or equivalent practical experience.
• Awareness of data warehousing, data platforms and source-to-report data flows.
• Experience with insurance or financial services data, including claims, policy administration or customer data.
• Awareness of version control and controlled deployment practices for BI solutions. Confidence using AI-assisted productivity tools responsibly for reporting and BI development, with appropriate validation of outputs.
• Experience with agile methodology and familiarity with Python is an advantage.