Data Analyst II

Imperial Health Plan of California, Inc. is approved by California Department of Managed Health Care to offer full-service Medicare Advantage coverage, including a Medicare Advantage Prescription Drug plan, and a Chronic Condition Special needs plan over numerous counties in California. Through its affiliate, Imperial Insurance Companies, Imperial also offers Medicare Advantage plans in Texas, New Mexico, Utah, and Arizona.

THIS IS IN-OFFICE - NO REMOTE IS AVAILABLE

ESSENTIAL JOB FUNCTIONS:

1. Perform moderate level data analysis and reporting by conducting detailed exercise timely and accurate reporting techniques and/or develops new or modifies existing reports that ensure consistent results and analysis

2. Use analytical skills to determine solutions and resolve problems and automate when appropriate.

3. Work with requestors to determine needs and objectives, document and identify the correct methodology for extracting data including data sources and criteria, and ensuring the delivered report is accurate, timely, and formatted appropriately.

4. Manage assigned projects and effectively communicate with the requestor and leadership team any project roadblocks that may jeopardize deadlines in advance of due dates.

5. Responsible for understanding the various data sources available at Imperial.

6. Document all coding/analysis/reporting projects following established protocols to ensure transparency and repeatability.

7. Collaborates and maintains effective working relationships with management, internal departments, and external vendors.

8. Work with management to prioritize business and information needs.

EDUCATION/EXPERIENCE:

· Bachelor's Degree in Computer Science, Management Information Systems, Public Health, Finance, Business, Economics, or related field required. In lieu of a Bachelor's Degree, 6 or more years of experience with reporting and analytics with data analysis, extraction, and manipulation in a healthcare setting utilizing SQL

· Experience with SQL (TSQL, PostgresSQL, MySQL etc.) is a must

· Prior experience using ETL tools (Informatica, dbt, fivetran etc.), Python, R, and BI visualization (PowerBI, Tableau, Looker etc.) tools a bonus

· EZCAP experience preferred

· 3+ years of experience with SQL reporting and analytics with data analysis, extraction, and manipulation

· 3+ years designing reports and developing executive level presentations

· 3+ years experience in a healthcare delivery or healthcare business setting preferred

SKILLS/KNOWLEDGE/ABILITY:

· Must understand relational database concepts, table design and structure, joins, data normalization, and data types

· Must be able to conduct detailed analysis and provide results

· Thorough knowledge of MS Office Suite particularly Excel

· Analytical and problem-solving skills

Job Type: Full-time

Pay: $80,000.00 - $85,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Flexible spending account
• Health insurance
• Life insurance
• Paid time off
• Vision insurance

Experience:

• EZCAP: 2 years (Required)

Location:

• Pasadena, CA 91106 (Preferred)

Work Location: In person