Data Analyst benefits enrollment, Excel

Initial 1-day per week hybrid-Madison, 6 months. rest fully remote

Minimally qualified candidates will have experience or skills in the following areas:

·       Attention to detail

·       Ability to research, interpret, and apply relevant WI Statutes, Admin Code, policies and procedures

·        Ability to analyze and compare large data sets and files to identify discrepancies, inconsistencies, and trends Ability to investigate and determine root causes of data or file discrepancies in collaboration with technical staff, vendors, and business teams

·       Working knowledge of data exchange processes, file layouts, and/or eligibility and enrollment data

·       Experience troubleshooting data issues and documenting findings, resolutions, and procedures

·       Intermediate proficiency in Microsoft Excel, including formulas, filtering, sorting, pivot tables, and lookup functions

·       Ability to understand and communicate complex data and information to both technical and non-technical audiences

·       Critical and analytical thinking for effective problem-solving

·       Working collaboratively with different teams across an organization

·       Capacity to learn new tools, systems, applications, and ability to document procedures to assist others in using

·       Sound time management and ability to manage multiple, concurrent assignments

·       Obtain relevant information without disclosing confidential information

·       Ability to interact positively with a variety of persons at different levels

·       Excellent written, oral, and interpersonal skills

Job Duties

·       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.