Data Analyst

Pioneer Search; City Of London; Hybrid; GBP 80,000 - 100,000; Full time

Job summary

A leading London Market insurer is seeking an experienced Data Analyst to support a major data platform transformation. The role involves maintaining MI and operational reporting using advanced Excel and Power BI while ensuring data integrity during the migration. Candidates must have proven experience in the London Market, strong Speciality Insurance knowledge, and excellent stakeholder engagement abilities. This position is hybrid based in London and offers a contract of 6 months.

Qualifications

• Proven Data Analyst experience within the London Market.
• Strong Speciality Insurance knowledge.
• Experienced in data reconciliation and quality assurance.

Responsibilities

• Maintain and enhance MI and operational reporting using Excel and Power BI.
• Perform detailed data reconciliation and validation.
• Build and maintain dashboards and reports.

Skills

Data analysis

Advanced Excel

Power BI

Stakeholder engagement

Data reconciliation

Job description

Overview

Data Analyst: Speciality Insurance, Power BI, Excel, Data

Location: London - Hybrid
Contract: 6 months, Inside IR35
Rate: £500 - £550 per day

A leading London Market insurer is undergoing a major data platform transformation, migrating from a legacy third-party data solution to a new enterprise data platform. During this transition period, the business requires an experienced Data Analyst to ensure continuity of business-critical reporting and data integrity.

This role will play a key part in maintaining and delivering MI using advanced Excel and Power BI, while performing detailed data reconciliation between legacy and new platforms. The successful contractor will bring strong Speciality Insurance experience and be confident engaging with multiple departments across the business.

Responsibilities

• Maintain and enhance MI, regulatory, and operational reporting using Excel and Power BI during the data platform migration.
• Perform detailed data reconciliation and validation across legacy systems and the new data platform.
• Work closely with Underwriting, Claims, Finance, and Actuarial teams to gather requirements and support reporting needs.
• Build and maintain dashboards, reports, and ad-hoc analysis to support day-to-day decision-making.
• Support the wider transformation programme by identifying data quality issues, inconsistencies, and remediation actions.

Requirements

• Proven Data Analyst experience within the London Market, with strong Speciality Insurance knowledge.
• Advanced Excel skills, including complex formulas, pivot tables, and data analysis.
• Strong hands-on experience developing dashboards and reports in Power BI.
• Demonstrable experience with data reconciliation, data quality assurance, and working across multiple data sources.
• Excellent stakeholder engagement skills, with the ability to communicate effectively across technical and non-technical teams.