DE&A - GWDM - Guidewire Data Management Professional

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

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.

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