DE&A, GWDM

About the Role

This role involves data extraction, transformation, and loading processes, particularly for Guidewire data management initiatives.

Key Responsibilities

Data Extraction

• Analyse and understand legacy mainframe claims data structures and relationships.
• Design and implement repeatable, auditable data extraction processes.
• Extract mainframe data into flat-file formats and securely transfer datasets via SFTP for downstream processing.
• Identify data dependencies, historical data requirements, and migration scope boundaries.

Data Transformation

• Design and develop ETL transformation processes aligned to Guidewire target-state data requirements.
• Define and implement data mapping, conversion rules, and business transformation logic.
• Perform data cleansing, standardisation, enrichment, and validation activities.
• Identify, manage, and resolve data quality issues throughout migration cycles.

Data Loading

• Develop, execute, and optimise data load processes into Guidewire and associated target platforms.
• Support multiple migration rehearsals and production migration events.
• Optimise ETL processes for performance, ensuring processes are scalable, efficient, and reliable.
• Deliver migration activities in line with agreed cutover and deployment timelines.

Data Quality and Reconciliation

• Design and implement automated reconciliation and validation controls.
• Develop exception reporting and migration monitoring dashboards.
• Investigate, analyse, and resolve data discrepancies and reconciliation variances.
• Support business validation, data verification, and migration sign-off activities.

Testing and Migration Support

• Support system, integration, user acceptance, and migration testing activities.
• Troubleshoot ETL defects, data issues, and migration failures.
• Provide production cutover and post-migration support to ensure a stable transition.

Documentation and Governance

• Produce and maintain ETL design documentation, technical specifications, and operational procedures.
• Maintain comprehensive source-to-target mapping and data lineage documentation.
• Ensure compliance with Santam governance, security, risk, and audit requirements.
• Adhere to migration standards, controls, and best practices throughout the programme.

Qualifications

Preferred Experience

• Proven experience delivering large-scale data migration and ETL initiatives.
• Strong understanding of insurance data domains, particularly Claims and Policy administration.
• Hands-on experience with Guidewire data migration, integration, and data conversion activities.
• Experience working with legacy mainframe environments, flat-file processing, and secure data transfer mechanisms.
• Strong analytical, troubleshooting, and stakeholder engagement skills.