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