Business Data Analyst at Datonomy Solutions

Datonomy Solutions (Cape Town) · Cape Town, Western Cape · R90,000 - R100,000 per month

Stop applying one at a time.

JobAlertsZA auto-applies to South African jobs like this one for you, overnight. Upload your CV once — we do the applying.

Start free — we apply for you →

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 mo

Auto-apply to this jobView original posting ↗