Healthcare Analytics Data Engineer: ELT & EHR Pipelines

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

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.