Clinical Data Analyst III (HEDIS, Tableau, SQL)

About the position

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.

Responsibilities

• 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 data sources, data flow, 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.

Requirements

• Bachelor's Degree in a related field.
• At least 4 years of experience in designing, developing, generating and analyzing ad hoc/production reports in Healthcare/Managed Care setting.

Nice-to-haves

• Master's Degree in Public Health or Related Field.
• Experience as a Clinical Data Analyst.
• Working knowledge of SAS Proc SQL, SAS Macro and database related SAS skills.

Benefits

• Paid Time Off (PTO)
• Tuition Reimbursement
• Retirement Plans
• Medical, Dental and Vision
• Wellness Program
• Volunteer Time Off (VTO)