Claims Operations & Data Analyst, Senior

Health Plan of San Joaquin/Mountain Valley Health Plan; French Camp (CA); Remote; USD 120,000 - 150,000; Full time

Benefits offered by this job

Remote work contingent on business & G

Tuition reimbursement

Health coverage options

Paid time off

Retirement plan

EAP

FSAs for healthcare

Annual wellness program

Job summary

Health Plan of San Joaquin is seeking a Senior Claims Operations & Data Analyst to lead advanced data analysis, workflow redesign, and system logic improvements for claims processing. The role blends responsibilities of data and business analysis with a focus on operational scalability and cross-functional impact.

The position supports executive-level diagnostics and performance dashboards, requires strong SQL, Excel, and BI tool skills, and offers remote work within California, with preference

Qualifications

• Bachelor’s degree required.
• Five years of progressively responsible healthcare claims/BA work.
• At least three years SQL-based analysis.

Responsibilities

• Perform advanced SQL queries to analyze claims data and identify trends.
• Redesign workflows, routing logic, and system rules to improve accuracy and efficiency.
• Prepare operational diagnostics and executive-ready materials for leadership.

Skills

Claims operations

SQL

Excel

Visio/Lucidchart

Analytical thinking

Communication

BI tools

Education

Bachelor’s Degree in Healthcare/Related Field

Tools

QNXT

Jiva

Power BI

Tableau

Job description

The expected pay range is based on many factors such as geography, experience, education, and the market. The range is subject to change.

This is a remote position. Must reside in California, preferably in our service area.

What You Will Be Doing:

Under limited direction, Claims Operations & Data Analyst, Senior, provides advanced business analysis, workflow redesign, claims data analytics, and system logic support to strengthen Claims Operations. This role integrates responsibilities traditionally split across data analysts and senior business analysts, serving as the department’s expert in workflow optimization, business rule development, operational diagnostics, and claims reporting. The position evaluates operational gaps, redesigns workflows, develops routing logic, produces advanced analytical reporting, and supports alignment of system configuration with business needs. The analyst serves as functional lead for Claims Operations transformation activities, creates executive-level materials, and ensures operational scalability and performance improvements across claims, adjustments, PDR, recovery, QA, and auto-adjust processes. This is a senior independent contributor role with high complexity, broad cross-functional influence, and significant operational impact.

Essential Functions:

• Operational & Workflow Analysis
• Conduct end-to-end assessments of Claims Operations workflows, including claims processing, adjustments, PDR, QA, recovery, pend logic, routing, and auto-adjust logic.
• Identify operational gaps, bottlenecks, missed handoffs, and areas requiring process clarification or redesign.
• Redesign workflows, routing rules, and logic models to improve accuracy, efficiency, inventory management, and first-pass outcomes.
• Create detailed workflow maps, decision trees, logic models, and operational documentation.
• Business Rules & System Logic
• Design and recommend updates to business rules, routing criteria, assessment logic, pend logic, auto-adjust behavior, and worklist assignment rules.
• Support alignment of operational rules with QNXT, Jiva, Symplr Payor, and related systems.
• Develop specifications for configuration improvements and support readiness for system changes.
• Runs auto-adjust process.
• Advanced Claims Data Analysis
• Perform complex SQL queries to analyze claims data, identify trends, assess routing behavior, and evaluate operational outcomes.
• Build advanced Excel models, pivot tables, simulations, and logic-driven tools.
• Develop performance dashboards and claims analytics for leadership.
• Executive-Level Operational Support
• Prepare operational diagnostics, workflow assessments, and cross-functional impact analyses for Director-level and Executive review.
• Summarize complex issues into concise, actionable recommendations.
• Serve as functional lead for transformation initiatives, providing analytical and workflow expertise.
• Transformation & Operational Enablement
• Support inventory governance, operational readiness checks, and workflow standardization.
• Document operational gaps and propose mitigation strategies.
• Partner with leadership to establish sustainable practices and governance structures.

What You Bring:

Knowledge, Skills, Abilities and Competencies

Required

• In-depth knowledge of claims operations, business rules, routing logic, pend logic, adjustments, PDR, QA, recovery, auto-adjust logic, and related workflows.
• Intermediate SQL skills and advanced Excel capabilities.
• Ability to design workflows using Visio/Lucidchart.
• Strong analytical and problem-solving skills.
• Ability to synthesize complex issues and communicate clearly with leadership.
• Ability to influence without authority and act as functional lead for transformation.
• Strong written and verbal communication skills.
• Knowledge of BI tools (Power BI/Tableau preferred).
• Ability to handle confidential information with appropriate discretion.

What You Have:

Education and Experience

Required

• Bachelor’s Degree; and
• At least five years progressively responsible experience in healthcare claims, business analysis, workflow redesign, or managed care operations; and
• At least three years performing SQL-based analysis; or
• Equivalent combination of education and experience.

Preferred

• Experience with QNXT (strongly preferred).
• Experience with Jiva.
• Experience creating executive-level materials and operational diagnostics.
• Experience in Medi-Cal claims environments.

Licenses, Certifications

Required

• None.

What You Will Get:

HPSJ Perks:

• Robust and affordable medical coverage including HMO and PPO plan options
• Employee Wellness Program promoting physical, mental, and financial well-being
• Dental and vision plan with multiple provider choices
• Generous paid time off (accrue up to 3 weeks of PTO, 4 paid floating holidays, and 9 paid holidays)
• CalPERS retirement pension program, automatic employer-paid retirements contributions, plus a voluntary defined contribution plan
• Two flexible spending accounts (FSAs)for healthcare and dependent care expenses
• Employer-Paid Term Life and AD&D Insurance
• Employer-Paid Disability Insurance
• Employer-Paid Assistance Program (EAP)
• Health Advocacy to help you navigate medical care and benefits
• Voluntary supplemental benefits including medical, legal, identity theft protection
• Online discount mall
• Tuition reimbursement
• Remote work contingent on business needs and company guidelines
• A chance to work for an organization that is mission-driven – our members and community are at the core of everything we do

At this time, the Health Plan does not sponsor visa. Candidates must have legal and valid work authorization, Green Card, or U.S. citizenship.

Physical Demands

Work may require frequent sitting, standing, and walking, constant repetitive motion, frequent talking and listening, closeup and distance vision requirements. Some work may require occasional travel based on the responsibilities of the position and business needs and occasional handling materials up to 50 pounds.

Emotional/Psychological Demands

Ability to cope with a fast-paced work environment, working under pressure, dynamic priorities and deadlines, constant decision making, working irregular hours, emotional and sensitive situations.

Work Environment

Work may be performed in a remote, hybrid, or onsite setting depending on the requirements of the position and business needs. For roles performed remotely, employees are expected to maintain a secure, distraction-free workspace, and reliable internet connectivity consistent with company standards.

Important Notice : The duties, qualifications, and physical and emotional requirements listed in this job description are not exhaustive. Health Plan of San Joaquin reserves the right to revise this job description at any time.