Senior Data Analyst, Finance – Encounter Data (Hybrid)

CalOptima; Orange (CA); Hybrid; USD 84,000 - 135,000; Full time

Job summary

CalOptima is seeking a Data Analyst Sr, Finance - Encounter Data (Covered California) to support the Encounters team within Finance, ensuring accurate data submissions and efficient reporting.

The role requires 5 years of data analysis experience with SQL, 3 years in Medi-Cal/Medicare Advantage, and Covered California experience; the position offers partial telework and collaboration with vendors, providers and stakeholders.

Qualifications

• Bachelor's degree in health care administration, business administration, mathematics or related field plus 5 years of experience as a data analyst creating and maintaining SQL queries and improving reporting methods.
• 3 years of experience in Medi-Cal managed care or Medicare Advantage.
• Covered California (Commercial) experience required.

Responsibilities

• Support the Encounters team within the Finance department; maintain current Encounter tasks.
• Monitor and review 5010 837 file submissions; create and maintain SQL queries to reconcile data for new projects.
• Perform submission testing with vendors for outbound processes with DHCS and CMS; improve data acquisition and reporting methods.
• Ensure timely, complete and accurate data submissions inbound and outbound with the IT team.

Skills

SQL queries

Data reconciliation

Reporting automation

Communication

Education

Bachelor's degree in health care administration

Tools

Microsoft Office

SQL

Job description

CalOptima is seeking a Data Analyst Sr, Finance - Encounter Data (Covered California) to support the Encounters team within Finance, ensuring accurate data submissions and efficient reporting.

The role requires 5 years of data analysis experience with SQL, 3 years in Medi-Cal/Medicare Advantage, and Covered California experience; the position offers partial telework and collaboration with vendors, providers and stakeholders.