Data QA

REQUIRED SKILLS: (Need All) • 5 years’ experience in quality inspection, auditing, and testing. • Benefits administration, eligibility and enrollment operations, insurance operations, or a closely related field. • Data analysis. NICE TO HAVE SKILLS: • Ability to automate test scripts for a data management platform supporting ETL, MDM, data quality, and business intelligence. • Advanced Microsoft Excel skills, including use of formulas, pivot tables, lookup functions, filtering, and sorting to analyze and compare large or complex data sets. • Experience performing data reconciliation and file comparison across multiple systems to identify discrepancies and support data integrity and issue resolution. • Knowledge of eligibility, enrollment, and benefits administration processes, including understanding of data exchange between employers, vendors, and internal systems. • Strong analytical and problem-solving skills, including the ability to investigate data issues, identify root causes, and support resolution in collaboration with technical and business partners. • Strong communication, organization, and documentation skills, including the ability to clearly convey complex information, manage multiple priorities, and document findings and resolutions. INTERVIEW PROCESS: • MS Teams interviews, starting 07/06/2026. DESCRIPTION OF ROLE: The client is looking for a Quality Assurance Analyst II to support OSHP enrollment, eligibility, vendor file discrepancy, reconciliation, validation, and issue-resolution wor k.This is a true new need. The role will support program managers, case managers, technical staff, vendors, and business teams in researching, validating, documenting, and resolving eligibility, enrollment, billing, vendor file, and data integrity issue s.Qualified applicants will have a minimum of three years of professional experience in benefits administration, eligibility and enrollment operations, insurance operations, or a closely related field, including interpretation and application of statutes, administrative code, policies, procedures, and business rule s.Qualified applicants will also have experience with data analysis, reconciliation, and validation across files, reports, and systems to identify discrepancies, inconsistencies, and trends, including use of Microsoft Excel for comparison and analysi s.The role involves research and resolution of eligibility, enrollment, billing, or vendor file discrepancies, including root cause identification, corrective action coordination, and documentation of findings and outcome s.The selected candidate will serve as a liaison between internal staff, technical teams, vendors, and stakeholders to communicate issues, exchange information, and support resolution of complex eligibility and enrollment issue s.Job Dutie • s:Support OSHP program managers and EIU case managers in addressing vendor queries related to historical member benefits enrollment and eligibility informatio • n.Support the OSHP life insurance program manager and Benefits Initiation Section 3 staff in administering life insurance enrollment and eligibility, including handling escalated eligibility and enrollment questions resulting from discrepancies between My Insurance Benefits system, Securian Financial billing system, and employer record • s.Support the Life Insurance Premium Waiver interim proces • s.Assist in the development and documentation of new procedures related to eligibility and enrollment administration for the life insurance progra • m.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 error • s.Support the vendor file discrepancy process following MIBs implementation, including reviewing error reports returned from Benefitfocus and determining updates needed in the system, from employers, or by plan • s.Conduct full-file comparisons and data reconciliation activities between vendor, employer, and internal systems to identify discrepancies and ensure data integrit • y.Research, analyze, and troubleshoot eligibility and enrollment discrepancies, coordinating with technical staff, vendors, and business teams to identify root causes and implement corrective action • s.Assist with monitoring and resolving vendor file transmission issues, including 834 file processing and SFTP connectivity concern • s.Support testing and validation activities related to eligibility, enrollment, vendor file changes, and system update s.Additional Candidate Qualification • s:Ability to research, interpret, and apply relevant WI Statutes, Admin Code, policies, and procedure • s.Ability to analyze and compare large data sets and files to identify discrepancies, inconsistencies, and trend • s.Ability to investigate and determine root causes of data or file discrepancies in collaboration with technical staff, vendors, and business team • s.Working knowledge of data exchange processes, file layouts, and/or eligibility and enrollment dat • a.Experience troubleshooting data issues and documenting findings, resolutions, and procedure • s.Intermediate proficiency in Microsoft Excel, including formulas, filtering, sorting, pivot tables, and lookup function • s.Ability to understand and communicate complex data and information to both technical and non-technical audience • s.Capacity to learn new tools, systems, and applications, and ability to document procedures to assist others in using the m.