Senior Health Care Financial Analyst

Santa Clara County Health Plan; San Jose (CA); On-site; USD 111,168 - 172,310; Full time

Job summary

Santa Clara County Health Plan is seeking a Senior Health Care Financial Analyst to perform finance responsibilities and analyze health plan data. You will aggregate large datasets, run database queries, and perform business and financial calculations.

The role requires three years of health care finance experience, strong analytical skills, and proficiency with SQL/SAS and Microsoft Office. Exempt and reporting to the Director of Health Care Economics. The position is based in California.

Qualifications

• Bachelor's degree required; Master’s preferred.
• Experience: minimum three years in health care finance duties.
• Strong analytical skills and ability to handle large data sets.
• Relational database skills with various tools.
• Proficient with Excel, Access, PowerPoint, Word.

Responsibilities

• Reconcile revenue and costs using capitation invoices, eligibility, claims, and expense data.
• Design and prepare reports analyzing financial outcomes and make recommendations.
• Track regulatory reporting requirements and ensure compliance.
• Prepare regulatory reports and ensure accuracy of materials.
• Develop executive-level reporting on financial, utilization, and operational impacts.
• Analyze data to generate dashboards for senior management (MLR, costs, trends, provider profiles).
• Create queries and outputs in databases to support finance and contracting needs.
• Retrieve and compile information from internal and external sources.
• Support HEDIS and medical management analytics and reporting.
• Collaborate with IT to validate report portals and data marts.
• Provide encounter data reconciliation between regulators and claims data.
• Perform complex analyses to uncover root causes and trends and propose solutions.

Skills

SQL

SAS

Excel

Access

Financial Analysis

Communication

Education

Bachelor's Degree in Accounting/Finance/Related Field

Master's Degree in Accounting/Finance/Health Care Administration

Tools

Microsoft Office

Job description

Senior Health Care Financial Analyst

Salary Range: $111,168 - $172,310
The expected pay range is based on many factors, such as experience, education, and the market. The range is subject to change.

FLSA Status:Exempt
Department:Finance
Reports To:Director of Health Care Economics

GENERAL DESCRIPTION OF POSITION

The Senior Health Financial Analyst is responsible for performing finance responsibilities and analyzing a variety of health plan data. The incumbent aggregates large datasets, carries out functions in databases, and performs business and financial calculations.

ESSENTIAL DUTIES AND RESPONSIBILITIES

To perform this job successfully, an individual must be able to satisfactorily perform each essential duty listed below.

1. Responsible for revenue and cost reconciliation activities using capitation invoices, eligibility files, claims and expense data and other relevant reports.
2. Design and prepare reports that analyze the financial outcome of programs and make recommendations based on that analysis.
3. Understand and track applicable regulatory and reporting requirements.
4. Prepare reports required by regulatory agencies and ensure compliance with reporting requirements. Ensure accuracy and regulatory compliance for all materials or documents.
5. Develop executive level reporting summarizing the financial, utilization and operational impacts of organizational initiatives.
6. Analyze data to generate dashboard metrics and reports at required intervals (e.g., monthly/quarterly) for senior management, including medical loss ratios, medical costs, medical trends, and provider profiles.
7. Use database skills to create queries, reports, and other output to produce analytics to support SCFHP's business needs (e.g., financial, medical management, contracting).
8. Retrieve and compile information, databases, and/or reports from internal and external sources.
9. Support HEDIS and medical management analytical and reporting needs.
10. Collaborate with Information Technology to validate report portal and data marts.
11. Collaborate with Information Technology to provide encounter data reconciliation between regulatory agencies and health plan claims detail to ensure accurate and complete data.
12. Support organizational needs by performing complex analyses on a wide range of organizational data; investigate and uncover root causes, identify trends, and propose solutions.
13. Ensure understanding of customer needs by proactively clarifying scope and requirements and keep customers apprised of project status through effective communication.
14. Perform data acquisition, data quality and validation, data analysis, data reporting, and present findings and recommendations to end users.
15. Create and maintain documentation for all reporting and analyses.
16. Perform other related duties as required or assigned.

REQUIREMENTS - Required (R) Desired (D)

The requirements listed below are representative of the knowledge, skill, and/or ability required or desired.

1. Bachelor\'s Degree in Accounting, Finance, Business Administration, or related field; or equivalent experience, training, or coursework. (R)
2. Master\'s Degree in Accounting, Finance, Business Administration, Health Care Administration. (D)
3. Minimum three years of experience with the duties and responsibilities described above in health care. (R)
4. Superior analytical and qualitative skills and the ability to deal with complex problems/issues and large data sets. (R)
5. Relational database skills using various database tools. (R)
6. Strong working knowledge and proficient with Microsoft Office applications, particularly Access, Excel, PowerPoint, and Word. (R)
7. Knowledge of health care delivery and financing, especially with public programs. (R)
8. Strong oral and written communication skills, including the ability to express oneself clearly and concisely; and the ability to effectively interact with and present findings to customers at all levels of the organization. (R)
9. Ability to gather and analyze a wide variety of data, organize and write reports, and organize work efficiently. (R)
10. Ability to achieve high quality deliverables by assuring accuracy and thoroughness in executing projects.
11. Ability to understand, interpret, and apply applicable rules, regulations, and establish and evaluate priorities. (R)
12. Self-directed with proven ability to assume responsibility, work independently, meet deadlines, prioritize, and move projects/deliverables to completion with accuracy and minimum supervision. (R)
13. Ability to take initiative and exercise good judgment when making decisions within the scope of the position. (R)
14. Ability to think and work effectively under pressure and under ambiguity. (R)
15. Ability to maintain confidentiality. (R)
16. Ability to comply with all SCFHP policies and procedures. (R)
17. Ability to perform the job safely with respect to others, to property, and to individual safety. (R)
18. Prior experience in a managed care business environment, particularly with Medi-Cal, Medicare Advantage or Medicare Prescription Drug programs. (D)
19. Prior experience and knowledge related to medical claims/utilization. (D)
20. Experience using SQL, SAS, or other database applications, including skills in SQL to enhance data manipulation/analysis. (D)

WORKING CONDITIONS

Generally, duties are primarily performed in an office environment while sitting or standing at a desk. Incumbents are subject to regular contact with co-workers, managers, external partners, and vendors in person, by telephone and via work-related electronic communications.

PHYSICAL REQUIREMENTS

Incumbents must be able to perform the essential functions of this job, with or without reasonable accommodation:

1. Mobility Requirements: regular bending at the waist, and reaching overhead, above the shoulders and horizontally, to retrieve and store files and supplies; and sit or stand for extended periods of time. (R)
2. Lifting Requirements: regularly lift and carry files, notebooks, and office supplies that may weigh up to 5 pounds. (R)
3. Visual Requirements: ability to read information in printed materials and on a computer screen; perform close-up work; clarity of vision is required at 20 inches or less. (R)
4. Dexterity Requirements: regular use of hands, wrists, and finger movements; ability to perform repetitive motion (keyboard); writing (note-taking); ability to operate a computer keyboard and other office equipment. (R)
5. Hearing/Talking Requirements: ability to hear normal speech, hear and talk to exchange information in person and on telephone. (R)
6. Reasoning Requirements: ability to think and work effectively under pressure; ability to effectively serve customers; decision making, maintain a concentrated level of attention to information communicated in person, by telephone, and electronically throughout a typical workday; attention to detail. (R)

ENVIRONMENTAL CONDITIONS

General office conditions. May be exposed to moderate noise levels

EOE