Analyst III - Data Quality & Reporting (Hybrid Work Schedule)

Date: Nov 22, 2022

Location: Rancho Cucamonga, CA, US

Company: Inland Empire Health Plans

Job Requisition ID: 7705 

 

Position Summary/Position

 

Under the general supervision of the Manager, Data Quality Reporting, the Analyst III – Data Quality & Reporting is responsible for modeling healthcare related problems, discovering insights and identifying opportunities using statistical, algorithmic, data mining, analysis, and data visualization techniques.  In addition to advanced analytical skills, the Analyst III – Data Quality & Reporting will display proficiency at integrating and preparing varied datasets, architecting analytical databases and visualization environments, and communicating results that are compliant with IEHP business rules and reporting requirements. Responsible for managing assigned reporting projects to ensure that data and analysis requests are completed timely, accurately while presented in a way that meets the needs of the requesting department.  The Analyst III – Data Quality & Reporting must be able to assess requests and solicit feedback from requestors regarding any critical decision points that are necessary to complete requests accurately and timely.  To do this effectively, the Analyst III must have knowledge of the various data sources available for reporting and must have a clear understanding of IEHP business operations in order to appropriately apply criteria and methodology to meet requestors’ needs. The Analyst III must demonstrate effective communication skills with Team Members at all levels within the organization.  It is also necessary to understand how Data Quality and Reporting deliverables - including standard reports, ad-hoc requests, studies, analyses, and recommendations - can impact business operations at IEHP.  

Major Functions (Duties and Responsibilities)

 

1. Development and design of reports and analyses to support IEHP’s Operations department needs utilizing available tools, including but not limited to: Microsoft applications – MS Access, SSRS, SAS, SPSS, PowerBI, Crystal Reports, system-specific reporting tools, or other related reporting software.
2. Responsible for analyzing report requests to determine users’ needs and objectives, working with Information Technology resources to correctly identify criteria to meet reporting request and ensure the delivered report is accurate, timely, and formatted appropriately.
3. Develop timely and accurate data mining techniques to apply to new or existing standardized and ad-hoc reports that ensure consistent conclusions to data analysis.
4. Develop reconciliation and validation processes to help ensure the accuracy of data flowing between disparate systems that consume IEHP Core data such as MedHok and MediTrac.
5. Acquire and maintain updated knowledge of the various data sources available within IEHP for reporting, as well as a clear understanding of IEHP business operations to be able to appropriately apply criteria and methodology to meet requestors’ needs.
6. Manage assigned projects and effectively communicate project deadline issues with the CORE Management team in a timely manner. Document all reporting projects and database objects within a project consistently, as instructed by the CORE Management team.  
7. Understanding of regulatory reporting requirements that are supported by the Data Quality & Reporting department and facilitate business processes to support those reporting requirements.
8. Ability to interpret data trends and data analysis to model and frame business scenarios that will have meaningful impact on critical business processes and/or decisions of DQR, CBS, and IEHP.
9. Collaborate with staff at all levels to solve analytics issues, documenting results, and methodologies.
10. Collaborate with the data steward to ensure that the information used follows the compliance, access management, and control policies and verify it meets the qualification and assurance requirements of IEHP.
11. Serve as facilitator between business units and Information Technology departments to ensure data accuracy, validity, and reliability in support of analytics and reporting needs.
12. Research and prepare clear and concise summary reports, narratives, and gap analyses on key topics, as directed.
13. Demonstrate a commitment to incorporate LEAN principles into daily work.
14. Establish and maintain effective working relationships with others throughout the organization.

Supervisory Responsibilities

Leading: Guides Others

Experience Qualifications

 

Minimum of 7 years of experience and working knowledge of large datasets, creating queries, and developing reports for end users. Well-versed in relational database structures and database design. Experience in quality-analysis environments.

Preferred Experience

 

Experience in the healthcare field is preferred.

Education Qualifications

 

Bachelor’s Degree from an accredited institution required.

Preferred Education

 

Master’s Degree from an accredited institution preferred.

Drivers License Required

No

Knowledge Requirement

 

Strong data analysis, data presentation, spread sheet and database capabilities.  Ability to understand query design and data interpretation.  Proficient in use of analytical tools such as:  MS Access, SAS, Tableau or MS Excel is essential.  Working knowledge of Medi-Cal/Medicare claims and/or eligibility strongly desired.  

Skills Requirement

 

Excellent problem-solving and time management skills. Outstanding written and oral communication skills. Excellent analytical and judgment capabilities. Strong communication and interpersonal skills.

Abilities Requirement

 

Ability to build effective working relationships, decision-making and judgment, planning and communicate effectively at all levels in verbal and written form, including technical business writing. Strong attention to detail.  Ability to work with management across the organization.

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. 

Work Model Location

Hybrid

Physical Requirements

Keyboarding: Traditional - FREQUENTLY
Keyboarding: Touch-Screen - FREQUENTLY
Keyboarding: 10-Key - FREQUENTLY
Hearing: One-on-One - FREQUENTLY
Communicate: Information/ideas verbally - FREQUENTLY
Regular contacts: co-workers, supervisor - FREQUENTLY
Sitting - CONSTANTLY
Lighting - CONSTANTLY
Indoors - FREQUENTLY
Near Visual Acuity - FREQUENTLY
Memory - FREQUENTLY
Understand and follow direction - FREQUENTLY
Regular and reliable attendance - CONSTANTLY

A reasonable salary expectation is between $79,809.60  - $101,774.40, 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. With a provider network of more than 7,000 and a team of more than 2,500 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 a 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