Clinical Data Analyst III (Tableau, SQL)

Salary Range:  $88,854.00 (Min.) - $115,509.00 (Mid.) - $142,166.00 (Max.)

 

Established in 1997, L.A. Care Health Plan is an independent public agency created by the state of California to provide health coverage to low-income Los Angeles County residents. We are the nation’s largest publicly operated health plan. Serving more than 2 million members, we make sure our members get the right care at the right place at the right time.

Mission: L.A. Care’s mission is to provide access to quality health care for Los Angeles County's vulnerable and low-income communities and residents and to support the safety net required to achieve that purpose.
 

Job Summary

The Clinical Data Analyst III supports Healthcare metrics, quality and process improvement activities by producing healthcare outcome measurements that are used for internal and external reporting, the tasks including data quality assurance, process programming, specification documentation and report developing.

 

The Clinical Data Analyst III designs, develops, and generates production and similar reports that may evolve into complex data analysis/data integration projects that this individual may be responsible for maintaining. The complex data analysis/integration projects are those, which may require periodic maintenance on a weekly, monthly, quarterly, biannual, or annual basis. This position works with Information Systems analysts when ongoing reports can be accurately transferred for production.

 

The Clinical Data Analyst III interprets and documents both written and verbal specifications. This position takes basic instructions or specifications and interviews with the client for complete details sufficient for writing data queries based for ad hoc and ongoing health care measures. This position must comprehend the relationships between the field elements in encounters and claims, membership, and provider databases. This position supports the functions related to quality improvement activities inclusive of quarterly reports that demonstrate health care outcomes in comparison to targets or national averages/percentiles published by recognized organizations such as National Committee for Quality Assurance (NCQA) and Center for Disease Control (CDC).  Acts as a Subject Matter Expert, serves as a resource and mentor for other staff.

Duties

Design, develop and maintain complex ongoing data projects. Design, develop, and generate ad hoc/production reports. Produce automatic, robust, timely and accurate results based on client specifications and as allowed by available resources. Produce complete documentation, QC reports and periodic results as scheduled. Identify and create work-around to generate valid results that meet the intent of the client's specifications.  

 

Investigate and document organizational data flow and sources. Provide thorough documentation regarding current 1) data sources 2) data flow 3) current process and procedures to code, group, QC, link and seed the data. Develop automatic, robust and sharable Statistical Analysis System (SAS) or Structured Query Language (SQL) procedures and programs towards building a comprehensive clinical data repository.

 

Develop analytical programs, databases, routine procedures using SAS or SQL programming language. Create work tools that facilitate tasks by reducing paperwork and errors. Document assumptions, specification in a clear and sharable fashion.

 

Applies subject expertise in evaluating business operations and processes. Identifies areas where technical solutions would improve business performance. Consults across business operations, providing mentorship, and contributing specialized knowledge. Ensures that the facts and details are correct so that the project’s/program's deliverable meets the needs of the department, organization and legislation's policies, standards, and best practices. Provides training, recommends process improvements, and mentors junior level staff, department interns, etc. as needed.  Educate/Tutor clients/junior staff on maintenance/usage of database/solutions designed. Educate/Tutor junior staff on data/business knowledge and technical skills.

 

Communicate with stakeholders/clients/collaborators regarding project details and plans.

 

Perform other duties as assigned.

Duties Continued

Education Required

Bachelor's DegreeIn lieu of degree, equivalent education and/or experience may be considered.

Education Preferred

Master's Degree in Public Health or Related Field

Experience

Required: