People are the most important asset of Imperial, for this reason the difference and plurality of people, equality of opportunities, non-discrimination and inclusion in the workplace are priority and strategic factors in the Organization. Imperial maintains a strong will to promote Diversity, Equity, and Inclusion, through inclusive leadership as a lever change and business sustainability.

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.

Our Mission: To deliver valuable care so that members are healthy in body, mind, and spirit to achieve their inherent potential.

Our Vision: To deliver value based care that is clinically effective, sustainable, and achieves exceptional outcome.

THIS IS IN-OFFICE - NO REMOTE IS AVAILABLE

JOB SUMMARY: Responsible for providing moderate level technical, analytical, and reporting support for the Claims, Provider, Finance, Enrollment, and Utilization Management departments programs and reporting needs. Manages 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.

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
• Employee assistance program
• Employee discount
• Flexible spending account
• Health insurance
• Life insurance
• Paid time off
• Referral program
• Vision insurance

Schedule:

• 8 hour shift
• Day shift
• Monday to Friday

Ability to commute/relocate:

• Pasadena, CA 91106: Reliably commute or planning to relocate before starting work (Required)

Experience:

• SQL: 3 years (Required)

Work Location: One location

Please Note :
bankofmontserrat.ms is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, bankofmontserrat.ms provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.