Data Analyst benefits enrollment and Excel

Position: Data Analyst with benefits enrollment and Excel
· Support OSHP program managers and EIU case managers in addressing vendor queries related to historical member benefits enrollment and eligibility information.
· Support OSHP life insurance program manager and Benefits Initiation Section 3 staff in administering life insurance enrollment and eligibility, handling escalated eligibility and enrollment questions resulting from discrepancies between My Insurance Benefits system, Securian Financial billing system, and employer records.
· Support the Life Insurance Premium Waiver interim process.
· Assist in the development and documentation of new ETF procedures related to eligibility and enrollment administration for the life insurance program.
· Conduct the life insurance salary audit, verifying consistency between employer reported salary information and current on file information; work with EIU case managers to resolve errors.
· Support the vendor file discrepancy process following MIBs implementation—reviewing error reports returned from Benefitfocus, determining updates needed in system, from employers, or by plans.
· Conduct full-file comparisons and data reconciliation activities between vendor, employer, and ETF systems to identify discrepancies and ensure data integrity.
· Research, analyze, and troubleshoot eligibility and enrollment discrepancies, coordinating with ETF technical staff, vendors, and business teams to identify root causes and implement corrective actions.
· Assist with monitoring and resolving vendor file transmission issues, including 834 file processing and SFTP connectivity concerns.
· Support testing and validation activities related to eligibility, enrollment, and vendor file changes or system updates.