Data Analyst – Insurance Analytics

Our client, a well-established and actively expanding Lloyd's Syndicated Insurance firm, is seeking a bright and ambitious Data Analyst to work closely with multiple differing business teams from a Data Analytics perspective. Previous Insurance Industry experience is NOT required. 50% of the role will involve creating and presenting meaningful MI Report via Power BI Dashboard with data extracting from SQL with the other 50% focused on project based work to improve existing processes and systems with the end goal of enhancing service delivered to your internal stakeholders.

This is a fantastic opportunity to join a an actively expanding blue chip Insurance firm that is poised for further growth and can offer genuine career progression as consequence. The organsiation has invested significantly in a modern and up to date tech stack (Which sets it apart from most Insurance firms) and is leveraging the latest data science and machine learning techniques to maintain its competitive edge in the market.

As discussed above previous Insurance industry experience is NOT required (Albeit beneficial). What is essential is that you have demonstrable experience of interacting with senior business stakeholders to elicit their needs/requirements from a data visualisation perspective and the ability to extract/manipulate SQL data and present it in a Business Intelligence Dashboards (e.g. Power BI, Tableau etc.)

Ideally, you will have a numerical and/or computer science related background & an interest in Financial Modelling and Forecasting. Furthermore, you will have the desire to build a career where you interact regularly with business users and assist them by presenting data in a meaningful way.

THE ROLE:

This role plays a key part in supporting the organisation’s strategic goals by harnessing data to improve operational efficiency, enhance service quality, and contribute to profitability. By turning internal and external data into actionable insights, the position helps shape business decisions and support meaningful change across various functions.

You'll be at the heart of the team’s data capabilities, working with diverse data sources to uncover insights and trends that inform claims performance and wider business activity. This will involve developing regular reporting dashboards and datasets to support in-depth analysis and decision-making. Your duties will include…

• Collecting and preparing data from various systems to create robust, analysis-ready datasets.
  
  
• Creating impactful data narratives that connect the dots and explain performance shifts in a clear and actionable way.
  
  
• Defining the requirements for additional data sources to help answer critical operational and strategic questions.
  
  
• Taking a proactive approach to monitoring trends in claims data—investigating anomalies, identifying root causes, and clearly communicating your findings to key stakeholders.
  
  The successful applicant will demonstrate the ability to turn complexity into clarity—someone who can use data to tell compelling stories and drive action. You’ll collaborate closely with multiple teams so strong communication skills and the ability to manage your own work and relationships are essential.
  
  RESPONSIBILITIES:
  
  
• Partner with Finance Business Partners and FP&A to deliver timely executive dashboards and detailed performance/exception packs for individual business units.
  
  
• Work hand‑in‑hand with the wider Business MI and Finance Systems (Decision Support) teams, balancing resources and priorities to meet demand.
  
  
• Design, build and automate clear, insightful reports that address evolving finance and business requirements.
  
  
• Gather, validate and blend financial and operational data to enable deeper analysis.
  
  
• Coordinate stakeholder input, adding narrative and actionable commentary to each report.
  
  
• Spot emerging trends, risks and opportunities, and flag them to finance and business leaders.
  
  
• Handle ad‑hoc data requests, budget and forecasting support, providing concise analysis and recommendations.
  
  
• Source and incorporate third‑party data where it enhances insight.
  
  
• Create, maintain and continuously improve MI dashboards in Excel, Power BI, PowerPoint and (where needed) SQL.
  
  
• Safeguard accuracy, consistency and integrity across all reporting outputs.
  
  
• Troubleshoot reporting issues and implement process or automation improvements.
  
  
• Upskill colleagues and business users through informal training on MI tools and best practice.
  
  
• Recommend ways to improve data quality and granularity to strengthen analytical capability.
  
  
• Play an active role in monitoring and improving overall financial and operational performance.
  
  SKILLS / EXPERIENCE REQUIRED:
  
  
• Highly numerate, demonstrating precision and a sharp eye for detail.
  
  
• Confident in working with data to explore and resolve business challenges, including gathering, shaping, and presenting insights through dashboards.
  
  
• Skilled in data analysis tools such as Excel (Ideally to Macro level), with familiarity in programming-based methods using SQL
  
  
• Able to communicate findings clearly and effectively, both in writing and when speaking with stakeholders.
  
  
• Excellent at building productive and professional relationships across teams.
  
  
• Works well in collaborative environments, helping to elevate team performance.
  
  
• Well-organised and capable of managing priorities to meet deadlines and deliver assigned responsibilities