What are the responsibilities and job description for the Clinical Data Analyst position at CCHP?
Established in 1986, Chinese Community Health Plan (CCHP) is the health plan subsidiary of Chinese Hospital. Our mission is to provide culturally competent and linguistically appropriate health care at an affordable price to community businesses and individuals who are generally not served by the broader health insurance market. CCHP also offers a Medicare Advantage HMO and Dual Eligible Special Needs Plan. If you want to help improve community health in a collaborative team-oriented environment, CCHP is the right place for you.
Requisition #20184
Brief job information:
Must reside in CA. 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
- Conducting medical cost and revenue analyses using medical and pharmacy claims and other data sources
- Analysis of medical and pharmacy claims in the appropriate assignment of code including but not limited to two CPT-4, MS-DRG, APR-DRG.
- Analysis and interpretation of RAF scores and HCC’s for both commercial and Medicare models.
- 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.
- Skilled in compiling large amounts of data into innovative presentations of information that are clear concise and actionable.
- Ensure the quality of deliverables in terms of the technical design, implementation, testing and adherence to technical compliance standards
- Develop inpatient and when applicable outpatient Episodes of Care for focused “service lines” such as gastroenterology, hematology/oncology, circulatory and other conditions.
- Develop business rules and apply to a strategic plans to recapture health plan costs from high cost providers to quality lower-cost providers.
- Utilize Microsoft Access, SQL, Crystal Reports and other tools to mine database(s) for analytic data.
- Create presentations used by the Medical Management Department, Medical Directors, CEO, CFO and internal and external customers.
- Create and manage all required reporting and analysis that contribute to the overall management and success of the health plan.
- Document analytical approaches and methodology applied.
- 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
Job Type: Full-time
Benefits:
- 401(k)
- Dental insurance
- Employee assistance program
- Flexible spending account
- Health insurance
- Life insurance
- Paid time off
- Tuition reimbursement
- Vision insurance
Schedule:
- 8 hour shift
- Monday to Friday
Experience:
- ETL: 2 years (Preferred)
- SSIS: 2 years (Preferred)
- Crystal Reports: 2 years (Preferred)
- Managed care: 2 years (Preferred)
Work Location: One location