Benefits Data Remediation Analyst

Position: Benefits Data Remediation Analyst

Location: Washington, DC (Remote/Hybrid, depending on business needs; confirming)

Duration: 6–12 Months

Interview: Virtual

STATE CLIENT

Job Description:

We are seeking a Benefits Data Remediation Analyst to support employee benefits data integrity initiatives, including pension data validation, reconciliation, cleanup, and correction across multiple systems. The consultant will collaborate with Benefits, Payroll, HR, Legal, and external vendors to resolve discrepancies and support pension administration, compliance, and missing participant research.

Key Responsibilities:

• Review, validate, and correct employee, retiree, and pension participant records.
• Reconcile data across HRIS, payroll, benefits, and pension administration systems.
• Analyze large datasets and prepare reports using Microsoft Excel.
• Research data discrepancies, identify root causes, and document corrections for audit purposes.
• Coordinate with vendors to locate missing participants, former employees, retirees, and beneficiaries.
• Support pension certification, pension termination, and benefits data remediation projects.
• Track remediation activities, project deliverables, and outstanding data issues.
• Maintain confidentiality and comply with data privacy and record-retention requirements.

Required Skills:

• 3+ years of experience in employee benefits administration, retirement plans, payroll, HR operations, data management, or a related field.
• Strong Microsoft Excel skills, including VLOOKUP/XLOOKUP, sorting, filtering, data validation, and reconciliation.
• Experience working with large and complex employee or participant datasets.
• Strong data cleanup, data validation, discrepancy resolution, and research skills.
• Excellent organizational, documentation, and communication skills.
• Ability to handle sensitive and confidential information professionally.

Preferred Qualifications:

• Experience with defined benefit pension plans and pension administration.
• Knowledge of pension plan termination, pension risk transfer, and benefits data remediation.
• Understanding of ERISA and participant data requirements.
• Experience with lost participant search firms or death audit vendors.
• Familiarity with HRIS, payroll, and benefits administration systems.
• Experience supporting retiree medical, life insurance, and other legacy benefit programs.