Analytics Data Engineer

Saint Francis Health System
  • New Haven, CT
    4 days ago

    Job Description

    Current Saint Francis Employees - Please click HERE to login and apply.

    Full Time

    Days

    Job Summary: The Analytics Data Engineer queries, builds and supports the data infrastructure that powers innovative neuroscience and mental health research. This role works with investigators, clinicians, data scientists, Data Architects, Developers, Integrators, and research teams to transform healthcare data into secure, high-quality research datasets, develop scalable data pipelines, optimize databases, and advance clinical research using Epic (Cosmos) and similar enterprise healthcare data platforms.

    Minimum Education: Bachelor's degree in related field.

    Licensure, Registration and/or Certification: Epic Cosmos, Cogito or Epic Caboodle Certification. One data model certification, preferred.

    Work Experience: Minimum 3 years related experience. The ideal candidate will have strong SQL experience, preferably within healthcare, along with experience using Epic Clarity or Caboodle. Experience with Epic Cosmos is an additional plus.

    Knowledge, Skills and Abilities: Knowledge of Microsoft 365 and other applicable software. Advanced knowledge of structured query language (SQL). Knowledge of healthcare data standards (ICD-10 (International Classification of Diseases, 10th Revision), CPT (Current Procedural Terminology), SNOMED CT (Systematized Nomenclature of Medicine Clinical Terms), LOINC (Logical Observation Identifiers Names and Codes), and RxNorm (a standardized nomenclature for clinical drugs and drug delivery devices), while HIPAA (Health Insurance Portability and Accountability Act). Proven knowledge of data management to understand integrity issues and facilitate their resolution. Excellent communication skills, both written and verbal that present clear and concise information. Strong analytical skills.

    Ability to work independently and collaboratively in a fast-paced environment, managing multiple priorities with competing deadlines.

    Essential Functions and Responsibilities: Designs and maintains Extract, Load, Transform (ELT) pipelines for clinical and research data. Develops and optimizes complex Structured Query Language (SQL) queries, databases, and analytics-ready datasets. Extracts, cleans, and integrates data from Epic, Cosmos, or similar Electronic Health Record (EHR) Platforms, Research Electronic Data Capture (REDCap), and other research systems. Collaborates with researchers to translate research questions into technical data solutions.

    Ensures data quality, security, Health Insurance Portability and Accountability Act (HIPAA) compliance, and reproducible workflows. Documents data pipeline and support continuous improvement of research data infrastructure.

    Decision Making: Independent judgment in making decisions involving non-routine problems under general supervision.

    Working Relationships: Works with other healthcare professionals and staff. Works frequently with individuals at Director level or above.

    Special Job Dimensions: None.

    Supplemental Information: This document generally describes the essential functions of the job and the physical demands required to perform the job. This compilation of essential functions and physical demands is not all inclusive nor does it prohibit the assignment of additional duties.

    Information Technology Enterprise Data Analytics - Yale Campus

    Location:

    Tulsa, Oklahoma 74136

    EOE Protected Veterans/Disability

    Numbers & Facts

    LocationNew Haven, CT

    Skills

    • Analysis Skillsunmatched
    • Clinical Dataunmatched
    • Clinical Medicineunmatched
    • Clinical Researchunmatched
    • Communication Skillsunmatched
    • Continuous Improvementunmatched
    • Current Procedural Terminology (CPT)unmatched
    • Data Cleaningunmatched
    • Data Managementunmatched
    • Data Modelingunmatched
    • Data Qualityunmatched
    • Data Scienceunmatched
    • Data Setsunmatched
    • Database Analysisunmatched
    • Database Optimizationunmatched
    • Drug Delivery Devicesunmatched
    • Electronic Data Capture (EDC)unmatched
    • Epic Caboodleunmatched
    • Epic Clarityunmatched
    • Epic Systemsunmatched
    • HIPAA (Health Insurance Portability and Accountability Act)unmatched
    • Healthcareunmatched
    • ICD-10unmatched
    • Information/Data Security (InfoSec)unmatched
    • International Classification of Diseases (ICD)unmatched
    • Medical Record Systemunmatched
    • Microsoft Product Familyunmatched
    • Multitaskingunmatched
    • Neuroscienceunmatched
    • Physical Demandsunmatched
    • Presentation/Verbal Skillsunmatched
    • Psychiatry and Mental Healthunmatched
    • Query Analysisunmatched
    • Query Optimizationunmatched
    • SQL (Structured Query Language)unmatched
    • Scalable System Developmentunmatched
    • Technical Researchunmatched
    • Time Managementunmatched
    • Writing Skillsunmatched

    Be found by employers

    5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

    Level up your application

    Professional resume templates

    Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

    Free resume templates

    Resume Builder

    Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

    Resume Builder