Financial Analyst II - Finance Analytics (Remote Options)

Date: Jun 23, 2022

Location: Rancho Cucamonga, CA, US

Company: Inland Empire Health Plans

Job Requisition ID: 6144 


Position Summary/Position


This position will be responsible for supporting the needs of the department by performing various financial or data analyses, preparing standard and/or ad hoc healthcare financial utilization reports (such as Rate Development Template reports, Prop56 & GEMT analysis, supplemental payment reconciliation, revenue reconciliation, GL mapping of healthcare costs, and pharmacy reports, etc.). In addition, this position will also provide other support for departmental projects such as budget analysis and researching financial healthcare utilization trends and variances.  This position requires strong accounting knowledge, working knowledge of extracting data from SQL databases by running and writing queries, and experience with extracting data from large ERP accounting systems. The candidate must have excellent communication skills, proven problem solving skills, and ability to multi-task.

Major Functions (Duties and Responsibilities)


1. Assist in the preparation and completion of the Rate Development Template (RDT) reports.
2. Create standard and ad-hoc healthcare utilization reports to support the Contracting Department and Leadership for strategic decision making purposes. 
3. Prepare, analyze and reconcile financial healthcare data from organization’s operations.
4.  Use SQL Server tables to develop analytical reports, including conducting analysis, summarizing and interpretation of results.
5. Act as primary liaison with Information Technology and Healthcare Informatics departments to define and translate requirements into technical applications.
6. Perform quality assurance and peer review on financial data analysis reports and other output.

Supervisory Responsibilities

Leading: Self

Experience Qualifications


Minimum of three (3) years of financial or data analysis in a healthcare setting.

Preferred Experience

Education Qualifications


Bachelor’s degree in Finance, Business Administration, Accounting or a related field from an accredited institution required.

Preferred Education


Masters degree from an accredited institution preferred.

Professional Certification


CPA a plus

Professional Licenses

Drivers License Required


Knowledge Requirement


Principles and practices of health care industry and strategies, health care systems, capitated risk contracting, provider network structures and risk sharing arrangements a plus.

Skills Requirement


Moderate skill level in SQL and Access (or equivalent database) data manipulation.  
Must have excellent communication and writing skills.
Strong knowledge and experience utilizing Microsoft Excel, Access, Word and PowerPoint.
Skilled in thoroughly documenting database queries, macros, etc. as defined by policy.
Quickly gain an understanding of data requests (scope and purpose) and to produce accurate and useful reports.
Cross-train and back up other areas of the department.

Abilities Requirement


Strong attention to detail, with the ability to quickly adapt to changes in priorities.
Communicate effectively, both verbally and in writing, in order to develop and maintain effective working relationships with all levels of staff and management.
Work cooperatively and effectively on group projects.
Ability to multi-task.
Adhere to IEHP's policies and procedures.
Work independently or with little direction with strong initiative to meet established deadlines

Commitment to Team Culture


The IEHP Team environment requires a Team Member to participate in the IEHP Team Culture. A Team Member demonstrates support of the Culture by developing professional and effective working relationships that include elements of respect and cooperation with Team Members, Members and associates outside of our organization.

Working Conditions


Word processing involving computer keyboard and screens, filing and copying of records and/or correspondence.

Physical Requirements


Starting Salary:  $70,002.40-$89,261.33

Pay rate will commensurate with experience




Inland Empire Health Plan (IEHP) is the largest not-for-profit Medi-Cal and Medicare health plan in the Inland Empire. We are also one of the largest employers in the region. With a provider network of more than 6,000 and a team of more than 2,000 employees, IEHP provides quality, accessible healthcare services to more than 1.2 million members. And our mission and core values help guide us in the development of innovative programs and the creation of an award winning workplace. As the healthcare landscape is transformed, we’re ready to make a difference today and in the years to come. Join our Team and Make a Difference with us! IEHP offers a Competitive salary and a benefit package with a value estimated at 35% of the annual salary, including medical, dental, vision, team bonus, and retirement plan.


Nearest Major Market: Riverside
Nearest Secondary Market: Los Angeles