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.