Data Conversion Analyst - Health and Welfare Platform
Core
Analyze, validate, map, and cleanse legacy client data to migrate it into modern pension and benefits administration systems.
Role type
Data Conversion Analyst
Builds
Data migration projects for pension and benefits plans
Domain
Pension and benefits administration
Required skills
SQL, Microsoft Excel (formulas, lookups, pivot tables), data analysis, data validation, data mapping, data cleansing, data reconciliation, documentation, testing support
Preferred skills
Pension/benefits/group insurance administration experience, T-SQL, relational databases, requirements documentation, test case creation, data quality focus
Responsibilities
Analyze and validate legacy client data against conversion specifications and business rules; Support data mapping, cleansing, and reconciliation; Run queries and checks to identify gaps, inconsistencies, and errors; Support testing cycles by documenting results and logging issues; Prepare materials and capture notes for client data workshops; Explain data structures and business rules to client teams; Share progress updates and data issues with project managers; Work with Data Managers and subject matter experts to complete tasks accurately and on time; Contribute ideas to improve conversion checklists, documentation, and processes