Data Analyst

Job Summary:

This Data Analyst is responsible for collecting, cleaning, analyzing, and transforming complex clinical, financial, and operational datasets into actionable insights. The position supports reporting, analytics, evaluation and performance improvement efforts across the organization. 

Essential Responsibilities:

The following duties are not intended to serve as a comprehensive list of all duties performed by all associates in this position. The duties listed are intended to provide a representative summary of the major duties and responsibilities. The incumbent may be required to perform additional, position-specific duties as assigned by their manager and/or LRHC Leadership.

Regulatory Reporting & Compliance

• UDS Reporting: Manage the aggregation, validation, and submission of annual HRSA Uniform Data System (UDS) tables.
• PCMH Maintenance: Track, analyze, and report on electronic clinical quality measures (eCQMs) required for Patient-Centered Medical Home (PCMH) recognition.
• State & Federal Grants: Author data queries and generate structured reporting assets for federal, state, and private grant compliance (e.g., HRSA, Delaware DHSS).

Data Analysis & Business Intelligence

• Dashboard Development: Design, deploy, and maintain interactive performance dashboards using Power BI or Tableau for clinical and administrative leadership.
• EHR Optimization: Extract complex datasets from the Electronic Health Record (EHR) system (e.g., Epic/OCHIN, eClinicalWorks) utilizing SQL queries.
• Ad-Hoc Analysis: Provide timely, data-driven answers to operational and clinical inquiries from executive leadership.

Quality Improvement (QI) Support

• Clinical Metrics: Identify gaps in preventive care, chronic disease management, and social determinants of health (SDOH).
• Population Health: Stratify high-risk patient panels to support care coordination and population health management.
• Workflow Validation: Partner with clinical staff to evaluate data capture workflows and eliminate data entry errors at the point of care

Qualifications:

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or competency required. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. 

Education/Experience/Certification:

• Required: Bachelor’s degree in health informatics, Data Science, Statistics, Public Health or a related field.
• Minimum of 2–3 of Data Analysis experience in a healthcare environment

Language Skills:

Bilingual (English/Spanish) preferred

Skills and Competencies:

Technical Skills

• Knowledge of HRSA Uniform Data System reporting
• SQL: Advanced proficiency in writing SQL queries for relational databases.
• BI Tools: Strong development experience using Power BI, Tableau, or equivalent visualization platforms.
• EHR Systems: Experience extracting and interpreting data directly from health IT platforms (e.g., Epic/OCHIN, eClinicalWorks, NextGen).
• Spreadsheets: Mastery of Microsoft Excel, including complex formulas, VLOOKUPs, and pivot tables.

Knowledge & Compliance

• Regulations: Strong foundational understanding of HIPAA regulations and data security practices regarding Protected Health Information (PHI).
• Healthcare Coding: Familiarity with standard clinical coding systems, including ICD-10, CPT, HCPCS, and LOINC.

Equipment Operated:

Wide range of office equipment.

Enterprise server infrastructure, firewalls, network switches, and access control hardware.

High proficiency and daily use of enterprise software suites (e.g., Microsoft 365, Active Directory, Epic EHR, and helpdesk ticketing workflows).

Mental/Physical Requirements:

Frequent sitting or standing for long periods while using a computer