Data Analyst (Tech Insurance Operations)

Data Analyst (Tech Insurance Operations)

Role Overview

We are seeking a highly analytical and technically capable Data Analyst to support the development of a data-driven claims function. This role will report directly to the Head of Claims and will work closely with TPAs and Vaves Underwriting Operations and Technology teams.

The Data Analyst will be responsible for extracting analysing reconciling and interpreting claims data to support operational oversight reserving discipline TPA performance underwriting feedback and portfolio profitability. The ideal candidate will have strong experience with SQL Excel data validation reporting and claims analysis

This is a hands-on role for someone who can transform data into insight and help the business make better claims underwriting and financial decisions.

Key responsibilities

Data Analysis

• Analyse claims data from internal systems TPAs data feeds bordereaux reports and data warehouses.
• Use SQL to query claims databases validate data quality build recurring extracts and support ad hoc analysis.
• Work within an Azure Databricks environment utilising SQL and Python skills to automate claims analysis and oversight reporting.
• Operational reporting severity analysis reserving reviews claims feedback for underwriting.
• Identify and investigate data quality concerns.
• Translate claims data into clear insights trends exceptions and recommended actions.

Claims MI Reporting & Dashboards

• Shape recurring claims management information dashboards KPI packs and executive reporting.
• Track and report on key claim metrics.
• Support the creation of board capacity partner underwriting and actuarial reporting packs.

Actuarial & Underwriting Support

• Support reserve reviews loss development analysis large loss monitoring data reconciliations and claims trend analysis.
• Partner with Underwriting to provide claim insights that inform risk selection pricing appetite policy wording exclusions endorsement and portfolio strategy.
• Support development of claims feedback loops that connect loss experience back to underwriting action.

Rules Engine Scoring & Claims Intelligence

• Support the build-out of claims rules escalation triggers severity scoring models and exception reporting.
• Participate in UAT for claims systems rules engines dashboards portals data feeds and workflow tools.
• Translate business requirements from Claims into technical data logic SQL predicates reporting rules and test cases.

Required experience

• 3 years of experience in data analytics within the financial/insurance sector
• Ability to work with incomplete inconsistent or complex data sources.
• Strong SQL querying and data manipulation skills.
• Advanced Excel and data reconciliation skills.
• Preferred knowledge of any of the following: laims analytics insurance data analysis claims operations actuarial support underwriting analytics TPA oversight or related insurance analytics roles.
• Experience working within Azure Databricks (preferred) using notebooks to analyse and transform data and leveraging Azure data services such as Azure SQL Data Lake Storage and cloud-based data platforms.
• Experience extracting and analysing data from systems or reporting platforms including Lloyds/delegated authority bordereaux.
• Demonstrated ability to analyse complex datasets and present findings in a clear concise business-relevant manner.

Preferred experience

• Prior experience with a TPA MGA MGU insurance carrier or reinsurer within a delegated authority business.
• Experience working with Actuarial and Underwriting teams.
• Familiarity with claims bordereaux delegated authority reporting capacity partner reporting or reinsurance reporting.
• Experience with Databricks Synapse or similar analytics tools.
• Understanding of claims leakage severity management reserve adequacy litigation trends fraud indicators subrogation and vendor performance.