Note: The job is a remote job and is open to candidates in USA. Idexcel is seeking a Benefits Data Remediation Analyst to provide project-based support to a client’s Benefits Department. The role researches, validates, reconciles, and corrects participant data across systems and vendors, while supporting data integrity initiatives, participant outreach, and regulatory compliance.
Responsibilities
- Support pension plan certification activities through comprehensive review, validation, and cleanup of participant demographic, employment, compensation, and benefit records
- Research and resolve data discrepancies by analyzing information across benefits, payroll, HRIS, pension administration, and historical recordkeeping systems
- Prepare, reconcile, and validate participant data files provided to actuaries, recordkeepers, auditors, legal counsel, and other project stakeholders
- Document data corrections, research findings, assumptions, and supporting materials to ensure a complete audit trail for all remediation activities
- Coordinate with lost and missing participant search vendors to locate former employees, retirees, beneficiaries, and alternate payees
- Review vendors search results and update participant records as appropriate while maintaining documentation supporting fiduciary and regulatory requirements
- Assist with participant outreach initiatives related to pension, retiree medical, life insurance, and other legacy benefit programs
- Conduct quality assurance reviews to verify the accuracy and completeness of participant data and benefit records
- Track and manage open data issues, remediation activities, and project deliverables to ensure timely completion of project milestones
- Develop and maintain reports, spreadsheets, and dashboards to support project management and status reporting
- Collaborate with internal and external business partners to identify root causes of data issues and recommend corrective actions
- Ensure compliance with applicable plan provisions, company policies, data privacy standards, and record retention requirements
- Support special projects and other benefits administration activities as assigned
Skills
- 3+ years of experience in employee benefits administration, retirement plans, payroll, HR operations, data management, or a related field
- Strong proficiency in Microsoft Excel, including data analysis, reconciliation, lookup functions, sorting, filtering, and validation techniques
- Experience working with large and complex employees or participant datasets
- Demonstrated ability to investigate issues, perform detailed research, and resolve discrepancies with a high degree of accuracy
- Strong organizational and project management skills with the ability to prioritize multiple assignments
- Excellent written and verbal communication skills
- Ability to handle confidential information with discretion and professionalism
- Experience supporting qualified defined benefit pension plans
- Experience with pension plan termination, pension risk transfer, or benefits data remediation projects
- Knowledge of ERISA, pension administration, and participant data requirements
- Experience working with lost participant search firms and death audit vendors
- Familiarity with benefits administration systems, HRIS platforms, and payroll systems
- Experience supporting retiree medical, life insurance, and other legacy benefit programs
Company Overview