Business Data Analyst

Datonomy Solutions (Pty) Ltd; Cape Town; Hybrid; ZAR 900,000 - 1,300,000; Full time

Job summary

Datonomy Solutions (Pty) Ltd hires a Senior Data & Business Analyst to own a large-scale insurance data migration programme end-to-end. You will translate underwriting and policy data requirements into precise data specifications and drive cross-functional collaboration across business, data, and IT teams.

You will map, validate and reconcile data from legacy systems to a modern Policy Administration System, ensuring data integrity, lineage and quality throughout the migration lifecycle,

Qualifications

• Strong experience in large-scale data migration projects.
• Ability to translate business requirements into detailed technical specifications.
• Experience with data mapping, data modelling and data quality controls.
• Proficient in analysing structured integration payloads such as JSON.
• Demonstrated ability to perform root-cause analysis and manage defects.

Responsibilities

• Take end-to-end ownership of policy data throughout the migration lifecycle.
• Analyse data from legacy insurance and policy administration platforms.
• Perform source-to-target data mapping between systems.
• Validate structured data payloads and JSON interfaces.
• Develop data dictionaries, mapping matrices and validation rules.
• Coordinate migration readiness and remediation with multiple teams.
• Support migration testing, data-quality testing and UAT.

Skills

Data migration

Data mapping

JSON interfaces

Data validation

Data reconciliation

Stakeholder management

Agile delivery

Underwriting knowledge

Root cause analysis

Problem solving

Tools

SQL

Guidewire PolicyCenter

Appian

JSON APIs

Job description

Role Overview

We are seeking an experiencedSenior Data & Business Analystto take end-to-end ownership of a large and complexinsurance 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 ofbusiness analysis, data analysis, insurance domain knowledge, data migration and integration experience.

The successful candidate must be comfortable operating at the intersection ofunderwriting, 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 detailedsource-to-target data mappingbetween legacy and target systems.

• Analyse and validate structured data payloads, includingJSON-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 appropriatedata lineage, data integrity and semantic alignmentacross 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.

• Performroot-cause analysisof 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 aSenior Business Analyst, Data Business Analyst, Technical Business Analyst or Data Migration Analyst.

• Significant experience working onlarge-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 asJSON.

• 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 withinshort-term/general insuranceis 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 asenior-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 withcommercial insurance, Guidewire PolicyCenter, Appian, JSON integrations or RPA-enabled migration processeswould provide a significant advantage.