Analytics Data Engineer

Saint Francis Hospital, Inc.; New Haven (CT); On-site; USD 90,000 - 130,000; Full time

Job summary

Saint Francis Hospital, Inc. seeks an Analytics Data Engineer to design and maintain ELT pipelines powering neuroscience and mental health research.

You will transform healthcare data into secure, high-quality research datasets and collaborate across investigators, clinicians, data scientists and IT teams. Requirements include a Bachelor’s degree, 3+ years of related experience, strong SQL, and HIPAA compliance.

Qualifications

• Minimum Education: Bachelor’s degree in related field.
• Epic Cosmos, Cogito or Epic Caboodle Certification. One data model certification, preferred.
• Work Experience: Minimum 3 years related experience.

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.

Skills

SQL

Microsoft 365

HIPAA compliance

Data management

Analytical skills

Communication skills

Independent and collaborative work

Education

Bachelor’s degree

Job description

Current Saint Francis Employees -

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.

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

Saint Francis is a Catholic, not-for-profit Health system based in Tulsa, Oklahoma. We are the largest private employer in Eastern Oklahoma with over 12,000 employees, including 1,000 physicians. The health system is anchored by the 1,112-bed Saint Francis Hospital, the largest hospital in Oklahoma and the 11th largest in the nation. Our system also includes hospitals in south Tulsa, Muskogee and Vinita, as well as 110 Warren Clinic locations from Monkey Island to McAlester, northeastern Oklahoma's only children's hospital, a level IV neonatal intensive care unit, a 168-bed heart hospital, and Tulsa's leading trauma and emergency center.