Systems Analyst - Strategy (Hybrid Work Schedule)

Date: Jan 4, 2023

Location: Rancho Cucamonga, CA, US

Company: Inland Empire Health Plans

Job Requisition ID: 7835 


Position Summary/Position


Under the direction of the Product Manager, the Systems Analyst - Strategy must be able to work independently to produce Marketing and database documentation, to communicate with end business users, to create ad-hoc reports, databases, systems, reporting tables, and to automate complex Marketing reports. The role provides assistance to multiple Strategy units in providing technical skills in real time for system troubleshooting, reporting, etc. The Systems Analyst - Strategy 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. The Systems Analyst - Strategy develops and maintains Marketing systems, databases, and reporting tables for regular report requests and reference data. This role must be able to create, update, and modify existing systems, databases, and reporting tables from scratch based on business requirements. 

Major Functions (Duties and Responsibilities)


1. Develop and maintain Marketing systems, databases, and reporting tables for regular report requests and reference data.
2. Provide high technical skill to troubleshoot and solve most technical issues, and act as the Marketing liaison with IT to streamline, troubleshoot and resolve issues that are higher in technical complexity.
3. Develop ad-hoc report using programming logic based on business requirements in order to extract healthcare and membership data for Marketing reporting purposes.
4. Create critical reference table(s) for Marketing department analysts to use.
5. Lead data projects from development phase to final report output.
6. Pull and manipulate data requests for ad hoc analysis as required by analysts within the team(s).
7. Mentor and train analysts on how to use and pull data from the SQL database.
8. Competencies:
    a. Oracle database, SQL, PL/SQL Oracle utilities (professional skill level)
    b. MS SQL Server, ANSI SQL, SSMS / SSIS and TSQL (professional skill level)
    c. Microsoft Excel (intermediate level) and Access (intermediate level)
9. Must be able to create, up-date, and modify existing reporting tables from scratch based on business requirements.
10. Must be able to write queries and stored procedures in SQL Server efficiently in order to meet reporting requirements. In addition, automate as many standard Marketing reports as possible. 
11. Must be able to 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. Must have strong healthcare business knowledge in order to translate business needs into technical programming logic. 
13. 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.
14. Provide assistance to ten Marketing units in providing technical skills in real time for troubleshooting, reporting, etc.

Supervisory Responsibilities

Leading: Self

Experience Qualifications


The following experience may be concurrent: Four (4) years of experience in database development, including analysis and design, using Microsoft Access or similar PC based relational database application. A minimum of two (2) years in database administration and development, using Microsoft SQL Server or similar relational database application. Over three (3) years of programming experience with Structured Query Language.

Preferred Experience


Experience preferably in a health care setting.

Education Qualifications


Bachelor’s degree in Computer Science, Mathematics, Accounting, Public or Business Administration, or Healthcare from an accredited institution required.

Significant experience may be considered in lieu of degree: In lieu of a degree, a minimum of eight (8) years of relevant work experience is required.

Drivers License Required


Knowledge Requirement


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. Ability to estimate database development tasks given a set of requirements and assumptions. Must possess experience, knowledge and understanding of database development, lifecycle management, tools, and cross-functional activities.

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


Using computer keyboard and screens.

Work Model Location


Physical Requirements

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

A reasonable salary expectation is between $91,000.00  - $116,022.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