Analyst III - Strategy (Hybrid Work Schedule)

Date: Jul 15, 2022

Location: Rancho Cucamonga, CA, US

Company: Inland Empire Health Plans

Job Requisition ID: 7671 


Position Summary/Position


Under the general supervision of the Strategy Analytics Manager, the Strategy Analyst III is responsible for modeling healthcare related problems, discovering insights and identifying opportunities using data mining, analysis, and data visualization techniques. In addition to advanced analytical skills, the Strategy Analyst III will display proficiency at integrating and preparing varied datasets, architecting analytical databases and visualization environments, and communicating results that meet or exceed business requirements.  The Strategy Analyst III 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. Projects include independently to produce Strategy technical documentation, to communicate with end business users, to create ad-hoc reports, databases, systems, reporting tables, and to automate complex Strategy reports.  This role must provide high technical skill to troubleshoot and solve most technical issues, and act as a liaison with IT for issues that are higher in technical complexity.  Incumbents are expected to exercise independent judgment in selecting study approach and analytical techniques, and in making sound recommendations. 

Major Functions (Duties and Responsibilities)


1. Be an extraordinary example and a champion in living IEHP’s Mission, Vision and Values (MVV) every day, and strongly commit to advance the organization’s strategic plan.
2. Utilize technical and analytical expertise in data design, data collection, reporting and monitoring activities for strategy enrollment initiatives. 
3. Execute enhancements on new strategies or future workflows utilizing expertise in current business processes.
4. Troubleshoot and solve most technical issues using expert technical skills, and act as the Strategy liaison with IT to streamline, troubleshoot and resolve issues that are higher in technical complexity.
5. Develop ad-hoc report using programming logic based on business requirements to extract healthcare, membership and revenue data for reporting purposes.
6. Create/maintain critical reference table(s) to import data from IEHP partners and internal department analysts to utilize.
7. Pull and manipulate data requests for ad hoc analysis as required by analysts within the team(s).
8. Mentor and train analysts on how to use and pull data from the SQL database. 
9. Create, up-date, and modify existing reporting tables from scratch based on business requirements. 
10. Write queries and stored procedures in SQL Server efficiently in order to meet reporting requirements. In addition, automate as many standard enrollment reports as possible. 
11. Perform QA testing and data validation of output to ensure that the results are fit for business needs. The requirements include developing and writing queries to verify the accuracy of the data output. 
12. Collaborate with other IEHP departments and data stewards to assess and prioritize needs, and assist with developing strategies, plans, policies and procedures related to providing effective reporting solutions.
13. Aid Strategy units in providing technical skills in real time for troubleshooting, reporting, etc.

Supervisory Responsibilities

Leading: Guides Others

Experience Qualifications


Five (5) or more years of experience database administration and development, using Microsoft SQL Server or similar relational database application. Five (5) or more years of experience of programming experience with Structured Query Language. Must possess experience, knowledge and understanding of database development, lifecycle management, tools, and cross-functional activities.

Education Qualifications


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

Drivers License Required

Yes, must have a valid California Driver's License.

Knowledge Requirement


Must possess competencies in:
- MS SQL Server, ANSI SQL, SSMS / SSIS / SSRS and TSQL (professional skill level)
- Microsoft Excel (intermediate level) and Access (intermediate level)
- Understanding Data Warehouse concepts

Techniques of relational database analysis, design, and implementation, including database management techniques, principles and practices of project control, physical and logical security techniques, experience with Microsoft SQL Server.  Must have strong healthcare business knowledge in order to translate business needs into technical programming logic. Ability to estimate database development tasks given a set of requirements and assumptions. Extensive knowledge of Microsoft SQL Server, Microsoft Reporting Services, Microsoft Visio, Power Point, Word and Excel is essential.

Skills Requirement


Communicate clearly and effectively both in speaking and in writing. Data analysis, word processing, spreadsheet, and some database capabilities. Excellent data collection and systemization abilities.

Abilities Requirement


Ability to handle multiple projects, data input, strong problem-solving capability, excellent interpersonal/communication skills. Exercising sound independent judgment within established guidelines. Establishing and maintaining effective working relationships with those contacted in the course of the work. High attention to detail and accuracy.

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. 

Work Model Location


Physical Requirements

Keyboarding: Traditional - FREQUENTLY
Keyboarding: Touch-Screen - FREQUENTLY
Keyboarding: 10-Key - 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


Starting Salary: $79,809.60  - $101,774.40  

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 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