Role Overview

We are seeking an experienced Senior Data & Business Analyst to take end-to-end ownership of a large and complex insurance policy data migration programme.

The role will be responsible for analysing, mapping, validating and reconciling commercial insurance policy data as it moves from legacy platforms through multiple integration and staging layers into a modern Policy Administration System.

This is a highly analytical, delivery-focused role requiring a combination of business analysis, data analysis, insurance domain knowledge, data migration and integration experience.

The successful candidate must be comfortable operating at the intersection of underwriting, business, data, integration and technology, translating complex insurance requirements into precise and testable technical data specifications.

Key Responsibilities

Data Migration & Analysis

• Take end-to-end ownership of policy data throughout the migration lifecycle.

• Analyse data originating from legacy insurance and policy administration platforms.

• Perform detailed source-to-target data mapping between legacy and target systems.

• Analyse and validate structured data payloads, including JSON-based interfaces.

• Develop and maintain detailed:

  • Source-to-target mapping matrices

  • Data dictionaries

  • Data specifications

  • Validation rules

  • Requirements traceability matrices

• Identify transformation requirements between legacy and modern system structures.

• Analyse large and complex datasets to identify data anomalies, inconsistencies and migration risks.

• Ensure appropriate data lineage, data integrity and semantic alignment across systems.

Insurance & Underwriting Analysis

• Interpret detailed underwriting specifications and translate them into technical data requirements.

• Analyse complex commercial insurance structures including:

  • Policy schedules

  • Policy sections

  • Cover information

  • Endorsements

  • Product structures

  • Validation rules

  • Underwriting business rules

• Ensure migrated data accurately represents the underlying insurance product and underwriting intent.

• Work closely with underwriting and business stakeholders to clarify policy and product requirements.

Data Quality & Migration Readiness

• Define and perform pre-migration data validation.

• Identify and resolve data-quality issues before migration execution.

• Validate field formats, mandatory information, relationships and referential integrity.

• Establish migration readiness criteria.

• Identify policy records that do not meet migration requirements and coordinate remediation.

• Support automated migration and ingestion processes by ensuring that data meets required quality and format standards.

Reconciliation, Testing & Defect Management

• Perform detailed end-to-end reconciliation between source systems, integration payloads, staging environments and target Policy Administration Systems.

• Validate migrated policy records against original source information.

• Investigate rejected or failed migration records.

• Perform root-cause analysis of data and migration defects.

• Manage defect and exception triage with technical and business teams.

• Support:

  • Migration testing

  • Data-quality testing

  • System integration testing

  • User acceptance testing

  • Migration dress rehearsals

  • Production migration validation

• Produce migration reconciliation and exception reports.

Integration & Technical Analysis

• Work across complex integration landscapes involving:

  • Legacy systems

  • APIs

  • JSON interfaces

  • Staging platforms

  • Workflow platforms

  • RPA solutions

  • Policy Administration Systems

  • Third-party vendor platforms

• Analyse interface specifications and identify mapping or integration inconsistencies.

• Work closely with developers and integration teams to resolve technical data issues.

• Support configuration of migration control and validation platforms.

• Assist with the design of automated validation, exception reporting and migration-control processes.

Stakeholder & Vendor Management

• Engage with internal business and technology stakeholders including:

  • Underwriters

  • Business Analysts

  • Data teams

  • Developers

  • Integration specialists

  • Test teams

  • Programme and Project Managers

• Work directly with external stakeholders including:

  • Binder Holders

  • Brokers

  • Third-party software providers

  • Technology vendors

• Facilitate workshops to investigate data, mapping and migration issues.

• Coordinate resolution of dependencies and defects across multiple teams.

• Provide clear reporting on migration readiness, data quality, risks and outstanding issues.

Essential Experience

• Strong experience as a Senior Business Analyst, Data Business Analyst, Technical Business Analyst or Data Migration Analyst.

• Significant experience working on large-scale data migration or system transformation programmes.

• Strong experience with:

  • Data analysis

  • Data mapping

  • Source-to-target mapping

  • Data reconciliation

  • Data-quality analysis

  • Data validation

  • Data migration testing

  • Defect management

• Experience working with large and complex datasets.

• Experience translating business requirements into detailed technical and data specifications.

• Experience analysing structured integration payloads such as JSON.

• Experience working across multiple systems, interfaces and integration layers.

• Strong understanding of legacy-to-modern system migration principles.

• Experience creating technical mapping matrices, data dictionaries and validation specifications.

• Strong root-cause analysis and exception-management capability.

• Experience working within Agile technology delivery environments.

Insurance Experience

Strong experience within short-term/general insurance is highly desirable.

Candidates should ideally understand:

• Commercial insurance products

• Policy administration

• Policy schedules

• Policy sections and covers

• Endorsements

• Underwriting rules

• Policy validation rules

• Insurance product structures

• Broker and Binder Holder environments

Highly Advantageous Technology Experience

Exposure to any of the following would be advantageous:

• Guidewire PolicyCenter

• Guidewire platforms

• Appian

• RPA / Robotic Process Automation

• JSON APIs and interfaces

• Insurance policy migration platforms

• Mainframe-to-modern platform migrations

• Migration control or staging platforms

Core Skills

• Data Migration

• Business Analysis

• Data Analysis

• Source-to-Target Mapping

• Data Mapping

• Data Modelling

• Data Reconciliation

• Data Validation

• Data Quality

• Data Lineage

• Data Governance

• Requirements Analysis

• Technical Business Analysis

• Integration Analysis

• JSON

• APIs

• Interface Analysis

• Data Transformation

• Migration Testing

• Defect Management

• Root Cause Analysis

• Exception Management

• Requirements Traceability

• Insurance Policy Administration

• Commercial Insurance

• Short-Term Insurance

• Underwriting

• PolicyCenter

• Appian

• RPA

Personal Attributes

The successful candidate will demonstrate:

• Exceptional analytical and problem-solving ability

• Very strong attention to detail

• Ability to identify subtle data anomalies

• Strong written documentation skills

• Ability to translate complex concepts into precise specifications

• Strong stakeholder engagement and facilitation skills

• Confidence working with both senior business stakeholders and highly technical teams

• Strong ownership and delivery orientation

• Ability to work independently

• Ability to manage multiple dependencies and competing priorities

• Strong communication and issue-resolution skills

Ideal Candidate Profile

The ideal candidate is a senior-level hybrid Data and Business Analyst with strong insurance data migration experience.

They will have previously worked on projects involving the migration of policy or financial-services data between legacy and modern platforms and will be comfortable moving between detailed field-level data analysis, insurance business rules, system integration requirements, migration testing and senior stakeholder engagement.

Experience with commercial insurance, Guidewire PolicyCenter, Appian, JSON integrations or RPA-enabled migration processes would provide a significant advantage.