Business Data Analyst

Duties & Responsibilities

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 insur