Data Analyst (Tech Insurance Operations)

Acrisure, LLC; Greater London; On-site; GBP 45,000 - 65,000; Full time

Job summary

Acrisure, LLC in the United Kingdom is seeking a Data Analyst to support the development of a data-driven claims function within Tech Insurance Operations. The role focuses on extracting, analysing, reconciling, and interpreting claims data to inform operational oversight, reserving, TPA performance, underwriting feedback, and portfolio profitability.

You will work with TPAs and internal teams, using SQL, Excel, Python, and Azure Databricks to transform data into actionable insights that drive

Qualifications

• 3+ years of data analytics experience in insurance or finance.
• Strong SQL querying and data manipulation skills.
• Advanced Excel and data reconciliation skills.

Responsibilities

• Analyse claims data from internal systems, TPAs data feeds, bordereaux reports, and data warehouses.
• Use SQL to query claims databases, validate data quality, and support ad hoc analysis.
• Build recurring extracts and automate claims analysis in Azure Databricks with Python.
• Create and refine claims MI, dashboards, KPI packs, and executive reporting.
• Support reserve reviews, loss development analysis, and underwriting feedback.
• Translate business requirements into technical data logic, SQL predicates, reporting rules, and test cases.

Skills

SQL

Excel

Python

Data analysis

Data validation

Reporting

Tools

Azure Databricks

Job description

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 Vave’s 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

Preferred knowledge of any of the following: claims 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 Lloyd’s/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.

There are amazing opportunities for talented people in every part of our business. We invite you to find your next great opportunity with us.