Healthcare Data Analyst

Requisition #20342

Employment Type

Full-time

Experience

4+ years of proven analysis experience highly preferred, or 2+ years of proven analysis experience in a healthcare/managed care environment

Required Degree

Bachelors Degree or combination of education and experience

Location

445 Grant Avenue, San Francisco, CA 94108

Region
Bay Area San Francisco
Application Email
Apply Now

Brief job information:

Works under the general supervision of the technical lead to investigate business questions and identify improvement opportunities by designing appropriate studies, conducting statistical analysis, and developing reports with healthcare data in areas including utilization, risk management, risk assessment, risk adjustment, Quality Improvement, and cost. Design and maintenance of tools needed for the specific needs of departments.

ESSENTIAL DUTIES AND RESPONSIBILITIES

  1. Conducting medical cost and revenue analyses using medical and pharmacy claims and other data sources
  2. Analysis of medical and pharmacy claims in the appropriate assignment of code including but not limited to two CPT-4, MS-DRG, APR-DRG.
  3. Analysis and interpretation of RAF scores and HCC’s for both commercial and Medicare models.
  4. Develop reports and conduct quantitative analysis to understand the trend or issues and to identify the opportunity to improve the quality of care and to manage cost and utilization.
  5. Skilled in compiling large amounts of data into innovative presentations of information that are clear concise and actionable.
  6. Ensure the quality of deliverables in terms of the technical design, implementation, testing and adherence to technical compliance standards
  7. Develop inpatient and when applicable outpatient Episodes of Care for focused “service lines” such as gastroenterology, hematology/oncology, circulatory and other conditions.
  8. Develop business rules and apply to a strategic plans to recapture health plan costs from high cost providers to quality lower-cost providers.
  9. Utilize Microsoft Access, SQL, Crystal Reports and other tools to mine database(s) for analytic data.
  10. Create presentations used by the Medical Management Department, Medical Directors, CEO, CFO and internal and external customers.
  11. Create and manage all required reporting and analysis that contribute to the overall management and success of the health plan.
  12. Document analytical approaches and methodology applied.
  13. Accepts and performs other duties as assigned.

 

QUALIFICATIONS

  • Bachelor’s Degree or equivalent experience required
  • 4+ years of proven analysis experience highly preferred, or 2+ years of proven analysis experience in a healthcare/managed care environment

Skills and Abilities

  • Possess the ability to effectively interact with, and present findings to customers at all levels of the organization including operational managers, medical directors and executives required
  • Proficiency with MS Access highly preferred
  • Proficiency with MS SQL (queries) highly preferred
  • Proficiency with MS SQL Server Reporting Services highly preferred
  • Proficiency with Crystal Reports highly preferred
  • Proficiency with C# programming and design highly preferred
  • Clinical code knowledge related to claims/utilization highly preferred
  • Experience with managed care contract terms/analysis a plus
  • Experience in a Medicare Advantage environment a plus
  • Experience in Covered California or other similar exchange environments
  • Experience with MS BI products a plus
  • Expert skills in MS Office productivity software, especially MS Excel
  • Excellent technical, interpersonal, written and oral communication skills required
  • Superior analytical skills required

 

In our efforts to control the spread of COVID-19 and its variants, CCHP requires that its employees be fully vaccinated as of their start date. If you require a medical or religious accommodation we will engage in the interactive process with you. Proof of vaccination will be required prior to start. If we make you an offer and you are not yet vaccinated, we will accommodate a delay in start date. CCHP may also mandate that its employees receive vaccine boosters, and all accommodation laws will be followed.