Healthcare Data Analyst II - Data Quality & Reporting

Date: Jan 14, 2022

Location: Rancho Cucamonga, CA, US

Company: Inland Empire Health Plans

Job Requisition ID: 5705 


Position Summary/Position


Under the direction of the department leadership team, the Healthcare Data Analyst II – Data Quality & Reporting (HDA II – DQ & R) is responsible for leading various data and analysis efforts for the Data Quality & Reporting Department that help drive company key initiatives.
The HDA II – DQ & R must have working experience in designing relational databases, complex query logic, and data modeling. In addition to technical data concepts, the HDA II – DQ & R must have experience in complex data analysis or healthcare data analysis in a health plan setting (or equivalent healthcare organization). 

The HDA II – DQ & R presents study/analysis results to various audiences throughout the organization, including the leadership team.

Major Functions (Duties and Responsibilities)


1. Develops and prepares reports to support IEHP’s clinical and provider units utilizing available analytics and data mining tools, including but not limited to: Microsoft Applications (including MS Access), SAS, SPSS, Crystal Reports, system-specific reporting tools (e.g., MedHOK, CRM,) or other related reporting software.
2. Exercises timely and accurate data mining techniques and develops new or modifies existing reports that ensure consistent conclusions to data analysis.
3. Use analytical skills to determine solutions and resolve problems.
4. Design and enhance databases to support reporting and analysis needs, including testing, validating, and maintaining data integrity and accuracy, across multiple databases. 
5. Responsible for evaluating report requests to determine requestor’s needs and objectives, identifying correct methodology for extracting data including data sources and criteria, and ensuring the delivered report is accurate, timely, and formatted appropriately.
6. Responsible for understanding the various data sources available within IEHP for reporting and analysis, as well as a clear understanding of IEHP business operations to be able to appropriately guide the development of quality program activities, including analysis and reporting.
7. Significant participation in analysis, interpretation, and translating of complex health plan data, issues, trends, and relationships into effective strategies and action plans.
8. Responsible for managing assigned projects and effectively communicating with the QS leadership team any project deadlines that may be in jeopardy of being met, well in advance of the due date.  
9. Document all analysis / reporting projects following established protocols, ensuring replication of results by an independent reviewer.
10. Present findings of analyses to various staff levels including executive team, leadership team and staff levels.  Present results in formats that are easy to understand and appropriate to the audience.
11. Demonstrate a commitment to incorporate LEAN principles into daily work.
12. Establish and maintain effective working relationships with others throughout the organization.

Experience Qualifications


Minimum of five (5) years of experience programming with Structured Query Language (SQL), database development, analysis, and design, using Microsoft Power BI; or similar PC based relational database application, analysis, design, and implementation -  including database management techniques.

Preferred Experience


Experience in a healthcare setting, especially working with government programs such as Medicaid/Medicare is preferred. Participated in the implementation and/or migration of a core claims system preferred.

Education Qualifications


Bachelor’s Degree from an accredited institution required.

Preferred Education


Master’s Degree from an accredited institution preferred.

Knowledge Requirement


Data analysis, data presentation, spread sheet and database capabilities.  Working knowledge of data analysis, study methodology, and preparing professional documents.  Basic understanding of statistical methods. Extensive knowledge of Microsoft Access, SAS, SSRS or other statistical applications are essential.  Proficiency in Microsoft Excel, Word.  

Skills Requirement


Proficient in Microsoft Office Applications such as MS Word, Excel, Power BI, and PowerPoint. Strong written and oral communication skills. Strong organizational skills. Strong project management skills.

Abilities Requirement


Must be detail oriented. Ability to work little supervision, balances multiple projects, and deadline driven. Exceptional follow-through abilities to track all outstanding tasks and coordinate with assigned owners to ensure tasks are completed timely. Ability to handle multiple projects.  

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


Makes necessary adjustments to work shift to ensure completion of projects and to meet deadlines, e.g. Go-Live, system releases, Core Implementation Critical Path Milestones. 


Starting Salary: $85,841.60  - $109,449.60  

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