Diagnose performance shifts across collections portfolios and channels, trace root causes through data and platform logic, and turn findings into experiments, forecasts, and actionable strategies that improve recovery outcomes.
Sr. Health Plan Operations Analyst
📜 Description
- Build and maintain dashboards, productivity trackers, and KPIs for leadership and daily operations.
- Write complex queries to support dashboards and ad hoc analysis; present findings through clear visualizations.
- Monitor quality and spend trends and incorporate industry benchmarks into reporting.
- Investigate, document, and resolve data quality issues; test data flows and audit performance and claims data.
- Source, clean, and organize data from payer portals, claims files, SFTP sites, and internal databases.
- Support team coordination, mentor junior analysts, review work, and serve as a data subject matter expert.
🛠️ Requirements
- Bachelor’s degree in a related quantitative field or equivalent professional experience.
- 4+ years of experience with data management, analysis, QA, and auditing healthcare or payer data.
- Intermediate SQL programming experience (Snowflake preferred).
- Advanced Microsoft Excel / Google Sheets skills (complex formulas, nested functions, pivot tables).
- Strong communication skills with the ability to collaborate effectively across remote teams.
- Proactive mindset with a proven ability to prioritize multiple tasks in a fast-paced environment.
- Understanding of value-based care/Alternative Payment Models, Medicare, and Non-MSSP quality measures
- Experience with statistical software, such as R or Stata
Full job description
Primary Duties
Dashboard Creation & Analytical Design
Design, build and maintain dashboards, productivity trackers, and KPIs utilized by leadership to improve market performance and daily operations.
Build high-complexity queries of back-end data to power dashboards and custom ad-hoc projects.
Present data findings clearly through visualization tools to ensure understanding among diverse stakeholders and colleagues.
Incorporate industry benchmarks into visual metrics (charts, graphs, pivot tables) to show baseline and current states.
Identify, monitor, and communicate changes or trends in quality and spend metrics.
Auditing & Quality Assurance
Act as the first line of defense investigating, triaging, documenting, and resolving internal and external data quality issues.
Create and apply testing algorithms to evaluate large data streams throughout the system data flow.
Audit year-end performance and claims data for discrepancies, reporting errors to payer teams for swift resolution.
Day-to-Day Operations
Source, clean, and organize data from multiple streams (payer portals, Rx claims files, SFTP sites, and internal databases).
Execute advanced SQL queries in Snowflake to supplement payer data for analysis and reporting QA.
Develop complex formulas and templates in Google Sheets and Excel to streamline repetitive data tasks.
Maintain comprehensive documentation regarding operational analytics, source-of-truth architectures, and peer cross-coverage plans.
Leadership Support
Assist the manager with work coordination, mentoring junior analysts, developing training plans, and reviewing team work products.
Serve as a data subject matter expert (SME); attend meetings in the manager's absence.
Facilitate clear intradepartmental and cross-functional communication among key stakeholders.
Other duties as assigned
Minimum Qualifications
-
Bachelor’s degree in a related quantitative field or equivalent professional experience.
-
4+ years of experience with data management, analysis, QA, and auditing healthcare or payer data.
-
Intermediate SQL programming experience (Snowflake preferred).
-
Advanced Microsoft Excel / Google Sheets skills (complex formulas, nested functions, pivot tables).
-
Strong communication skills with the ability to collaborate effectively across remote teams.
-
Proactive mindset with a proven ability to prioritize multiple tasks in a fast-paced environment.
Preferred Qualifications
Understanding of value-based care/Alternative Payment Models, Medicare, and Non-MSSP quality measures
Experience with statistical software, such as R or Stata
Physical Requirements
Prolonged periods of sitting at a desk and working on a computer.
Similar jobs
Search more Data Analyst jobsOwn analytics as a product for key business functions, turning ambiguous questions into self-serve data solutions, executive-ready insights, and recommendations that guide decisions across the organization.
As a Senior Data Analyst, you will leverage data assets and advanced analytics to drive product and business value, enhancing member experience and supporting revenue growth.
Leads reporting, dashboarding, and performance analysis, translating business questions into reliable analytics and actionable insights for internal and client stakeholders while improving metric consistency and delivery.
Відповідаєш за продуктову аналітику end-to-end: знаходиш точки зростання, оцінюєш експерименти й монетизацію та перетворюєш дані на рекомендації, моделі й рішення для продуктових команд.
