Role OverviewWe 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 ResponsibilitiesData 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.
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.
Interpret detailed underwriting specifications and translate them into technical data requirements.
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.
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.
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.
Migration testing
Data-quality testing
System integration testing
User acceptance testing
Migration dress rehearsals
Production migration validation
Produce migration reconciliation and exception reports.
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.
Underwriters
Business Analysts
Data teams
Developers
Integration specialists
Test teams
Programme and Project Managers
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.
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.
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.
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
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
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
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
Desired Skills:
Senior Data Business Analyst
Senior Business Analyst
Data Business Analyst