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