Health Benefits TPA Reporting and Quality Analyst

**Company Overview:** ASR Health Benefits, based in Grand Rapids, MI, is a fast\-growing third\-party administrator of health plans, including medical, dental, vision, short\-term disability, Section 125 plans, and consumer\-directed health plans. We administer these health plans through dedicated client service teams, consisting of staff members from each department at ASR who work together to meet our clients’ needs. **Position Summary:** The TPA Reporting \& Quality Analyst acts as the operational reporting anchor for our Analytics team. This position is responsible for the end\-to\-end execution, rigorous quality assurance, and timely delivery of plan performance reporting to our self\-funded client accounts, broker partners, and internal operations. The primary mission of this role is to absorb and own day\-to\-day reporting workflows—including our current platform migration from CedarGate to Artemis—ensuring absolute data integrity and strict adherence to turnaround timelines. By managing these daily operational and quality control demands, the analyst enables analytics leadership to focus on strategic platform architecture, building infrastructure, and driving organizational training initiatives. **Key Responsibilities:** * **SLA \& Timeline Management:** Maintain, automate, and own the distribution schedule for all standard client packages, ensuring all monthly and quarterly reporting packages are finalized and delivered within 5 to 10 business days of month\-end data availability. * **Rigorous Quality Control (QA):** Develop and execute strict data validation and quality check protocols to audit and cross\-check all report outputs before delivery; ensure zero variance between underlying data and customer\-facing reports. * **Migration Execution \& Audit:** Support the technical migration from CedarGate to Artemis by mapping and validating underlying healthcare data models, replicating historic client reporting structures, and performing backend data verification in SSMS to guarantee perfect data parity between systems. * **Database Querying (SSMS):** Write and utilize optimized SQL queries within SQL Server Management Studio (SSMS) to navigate complex relational databases, joining and manipulating diverse schemas across medical, pharmacy, and eligibility datasets. * **Cross\-Functional Collaboration:** Partner directly with the Account Management team, client services, and brokers to capture ad\-hoc data requests, manage expectations, and clearly communicate reporting delivery timelines. * Other duties as assigned **Required Skills and Qualifications:** * **Education:** Bachelor’s degree in Business Analytics, Finance, Healthcare Administration, Computer Science, or a related quantitative field. * **Industry Experience:** 2\+ years of healthcare data analytics or reporting experience, specifically within a TPA, health insurance carrier, or benefit brokerage environment. * **Technical Stack \& Data Competency:** * Proficient SQL skills with hands\-on experience using SQL Server Management Studio (SSMS) for data verification and querying. * Solid understanding of relational data models and healthcare schemas, specifically the relationship between membership eligibility tables, claims headers/lines, provider networks, and third\-party data feeds. * Experience with, or the technical agility to rapidly adopt, Artemis and legacy platforms like CedarGate. * Advanced Microsoft Excel capabilities (VLOOKUPs, pivot tables, data auditing). * **Core Competencies:** * High attention to detail with a proven track record in data validation and quality assurance. * Exceptional time management and organization skills necessary to meet strict 5–10 business day turnarounds under monthly operational pressure. * Strong collaborative communication style to interface effectively with client\-facing account teams. * Agreement that your likeness (e.g., name, image, voice, and/or video) may be used in internal and external materials with customers or prospective customers **Work Environment:** This position follows a remote work structure, allowing employees to work from home, based on specific tasks or personal work preferences. There may be times when working in the office will be required. **Essential Functions:** This role may require extended sitting, regular computer and office equipment use, clear communication, and occasional lifting of up to 10–15 pounds. Reasonable accommodations for individuals with disabilities will be provided as needed. **Confidentiality:** This position involves access to protected health information (PHI) and other sensitive data. Employees are expected to maintain strict confidentiality in accordance with HIPAA, company privacy policies, and all applicable federal and state regulations. Pay: $73,735\.46 \- $88,799\.70 per year Benefits: * 401(k) matching * AD\&D insurance * Dental insurance * Flexible spending account * Health insurance * Health savings account * Life insurance * Paid holidays * Paid time off * Prescription drug insurance * Vision insurance * Work from home Work Location: Remote