Data Science Engineer (Snowflake Cortex / Epic FHIR / LLM)

Data Science Engineer (Snowflake Cortex / Epic FHIR / LLM)
Location: Remote
Duration: Long-Term Contract
Interview Process: 1 Internal Screening + 1 Client Interview

About the Role

Client is expanding its Snowflake data platform to support a strategic healthcare initiative focused on enabling a Home Hospital program. This program uses machine learning to determine patient eligibility for home-based treatment in near real-time.

The ML model has already been developed in Data bricks. The goal of this role is to migrate and operationalize the solution within Snowflake, build near real-time data ingestion pipelines from Epic, and support LLM-based workflows using Snowflake Cortex.

This is a highly hands-on, senior-level engineering role.

Key Responsibilities

Snowflake Engineering

• Design and develop Snowflake stored procedures (SQL & Python)
• Work with Snowpark, Snowflake Notebooks, Streams, and Tasks
• Build feature engineering pipelines inside Snowflake
• Implement monitoring, alerts, and data quality checks
• Maintain clean documentation and runbooks
  

Epic API Integration

• Build near real-time ingestion pipelines from Epic using APIs
• Work directly with Epic FHIR and HL7 data
• Parse and transform healthcare payloads using business logic
• Handle API-driven integrations (GET/POST methods)
  

LLM & Snowflake Cortex Integration

• Utilize Snowflake Cortex functions including:
• AI_COMPLETE
• AI_SUMMARIZE
• AI_EXTRACT
• Prepare structured features for LLM consumption
• Collaborate with AI/ML teams to ensure stable data contracts
• Support adaptation of foundational LLMs for healthcare use cases (data perspective)
  

Migration Work

• Migrate components from Data bricks to Snowflake
• Rebuild and optimize workflows in Snowflake architecture

Required Qualifications

• 5 8+ years of experience in Data Engineering or Data Science Engineering
• Strong hands-on expertise in Snowflake (expert-level stored procedures required)
• Experience with Snowflake Cortex (including newer AI functions)
• Advanced SQL and strong Python skills
• Direct experience integrating with Epic APIs
• Knowledge of FHIR and HL7 standards
• Experience building near real-time ingestion pipelines
• Strong communication skills and ability to work with cross-functional teams

Nice to Have

• Experience with Data bricks
• Prior experience in healthcare or hospital systems

Ideal Candidate Profile

We are looking for a senior engineer who has:

• Direct hands-on experience pulling data from Epic via APIs
• Deep understanding of healthcare data standards (FHIR, HL7)
• Built Snowflake-based LLM pipelines using Cortex
• Experience migrating solutions from Data bricks to Snowflake
• Ability to work independently in a small, highly technical team