Financial Analyst II - Financial Compliance (Hybrid)

Date: Jan 18, 2023

Location: Rancho Cucamonga, CA, US

Company: Inland Empire Health Plans

Job Requisition ID: 8363 


Position Summary/Position


Under the direction of department leadership, the Financial Analyst II - Financial Compliance is responsible for analytical and reporting needs of the department. The Financial Analyst II - Finance Compliance builds reporting structures by identifying information required for the project and creates the SQL tables to extract the MediTrac data. This data is shared with the Financial Analyst I - Financial Compliance and is used for creating dashboards/reports for the various business units.

Major Functions (Duties and Responsibilities)


1. Serve as technical lead for analysis and reporting efforts to support the various units in the Financial Compliance Department.
2. Extract claims data from SQL databases and performing data validation quality checks.
3. Share data with the Financial Analyst I - Financial Compliance for creating dashboards/reports for the various business units.
4. Collaborate with Team Members to manage complex project requests and report development needs while ensuring timeliness and accuracy.
5. Document all analysis/reporting projects, following established protocols, ensuring replication of results by an independent reviewer.
6. Demonstrate a commitment to incorporate LEAN principles into daily work.
7. Establish and maintain effective working relationships with others throughout the organization.
8. Perform special projects and other duties as assigned by the department leadership team.

Major Functions (Duties and Responsibilities) Cont

Supervisory Responsibilities

Leading: Self

Experience Qualifications


Minimum of three (3) years of experience in working with financial data analysis, manipulating, and pulling large data sets, and working with complex reports required. Experience working with SQL and relational database structures. Experience in Managed Care or related industry experience required.

Preferred Experience

Education Qualifications


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

Preferred Education


Master’s degree from an accredited institution preferred.

Professional Certification

Professional Licenses

Drivers License Required


Knowledge Requirement


Knowledge of the principles and practices of the health care industry and managed care systems required.

Skills Requirement


Microsoft SQL data retrieval and manipulation skills. Proficient in Microsoft Excel and Access. Skilled in thoroughly documenting database queries, macros, etc. Excellent communication and writing skills. Strong query design abilities.

Abilities Requirement


Strong problem-solving capability. Strong attention to detail. Ability to manage multiple projects with time-sensitive deadlines. Ability to quickly adapt to changes in priorities. Ability to quickly gain an understanding of data requests (scope and purpose) and to produce accurate and useful reports.

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


Sedentary work in an office environment.

Work Model Location


Physical Requirements

Keyboarding: Traditional - FREQUENTLY
Hearing: One-on-One - FREQUENTLY
Communicate: Information/ideas verbally - FREQUENTLY
Near Visual Acuity - FREQUENTLY
Regular contacts: co-workers, supervisor - FREQUENTLY
Understand and follow direction - FREQUENTLY
Regular and reliable attendance - CONSTANTLY
Use of computer mouse - FREQUENTLY
Keyboarding: Other - FREQUENTLY
Hearing: In a group - FREQUENTLY
Hearing: Over the Telephone/Cell Phone - FREQUENTLY
Hearing: Conference Speakers/Video Calls/Radio Calls - FREQUENTLY
Turning/rotation of wrist or hand - FREQUENTLY
Alternate Sit/Stand or Walk at Will - FREQUENTLY
Perform complex and varied tasks - FREQUENTLY
Develop and maintain positive work relationships - CONSTANTLY
Decision-making - FREQUENTLY
Lead/Influence Others - FREQUENTLY
Work review - FREQUENTLY
Rapid Pace of work - FREQUENTLY
Control of work pace - FREQUENTLY
Problem Solving - FREQUENTLY

A reasonable salary expectation is between $70,012.80 and $89,273.60, based upon experience and internal equity.

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, designated as “Great Place to Work.” With a provider network of more than 5,000 and a team of more than 3,000 employees, IEHP provides quality, accessible healthcare services to more than 1.5 million members. And our Mission, Vision, and 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 stellar benefit package with a value estimated at 35% of the annual salary, including medical, dental, vision, team bonus, and state pension plan.

Nearest Major Market: Riverside
Nearest Secondary Market: Los Angeles