[Remote] Benefits Analyst

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