Data Analyst with benefits enrollment and Excel

Govan Systems

Madison, WI

JOB DETAILS
SALARY
$37–$37.50 Per Hour
JOB TYPE
Contractor
SKILLS
Data Analysis, Employee Benefits, Analysis Skills, Billing, Case Management, Compensation and Benefits, Corrective Action, Data Quality, Documentation, File Systems, Financial Systems, Identify Issues, Life Insurance, MIBs, Project/Program Management, Reconciliation, Root Cause Analysis, Secure/SSH File Transfer Protocol (SFTP), Systems Maintenance, Validation Testing,
QUALIFICATIONS

·       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

RESPONSIBILITIES

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

LOCATION
Madison, WI
POSTED
9 days ago

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

About the Company

G

Govan Systems