Data Specialist

Job Summary

The Data Specialist role is primarily to lead and execute the extraction, transformation, and loading (ETL) of customer data into our platform. This role is responsible for ensuring data accuracy, integrity, and completeness, working closely with customers and product teams. The role also requires leading data transformations or updates for other initiatives, including projects beyond standard customer data migrations.

Essential Functions

• Analyse source data from customer systems to understand structure, quality, and dependencies
• Map source data fields to the target system, documenting transformation rules and assumptions
• Write, test, and maintain scripts to extract, transform, and load data (ETL)
• Validate migrated data for accuracy, completeness, and consistency using relevant methods such as regulatory submission comparisons, actuary report comparisons, etc. 
• Troubleshoot and resolve data issues dur...