Clinical Data Analyst III (Tableau, SQL)

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

Education Preferred

Experience

Required:

At least 4 years of experience in designing, developing, generating and analyzing ad hoc/production reports in Healthcare/Managed Care setting.

Preferred:

Experience as a Clinical Data Analyst.

Skills

Required:

Must be able to apply and/or develop technical specifications for health care measures such as those used by National Committee for Quality Assurance (NCQA), HEDIS, Centers for Medicare and Medicaid Services (CMS), and State.

Must demonstrate advanced SQL and/or SAS skills in developing programs and procedures for analytics and quality assurance.

Must be able to present data in a format that is appropriate for analysis. This includes the ability to determine select the correct information for calculating basic rates, table configuration, and graphical presentations.

Must demonstrate an aptitude in learning and expanding abilities to use new applications with basic training.

Must be a self-starter and can multi-task and can take charge of assigned projects.

Must be able to make recommendations to the clients that demonstrate strengths and limitations of the organization's ability to meet the request.

Preferred:

Working knowledge of SAS Proc SQL, SAS Macro and database related SAS skills are highly preferred.

Licenses/Certifications Required

Licenses/Certifications Preferred

Required Training

Physical Requirements

Additional Information

Dept Specific:

Health Equity: 

This position is located in the Health Equity department. It supports the short and long term operational and L.A. Care’s Health Equity and Disparities Mitigation initiatives. This role will develop, enhance, and health and social service needs (food, housing, care management) information and models that will have an impact on vulnerable communities. Through the application of data analytics and analyzing various data sources, this role will work to deliver valuable insights and recommendations to improve health equity and reduce health disparities.