Job Description
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
Apply Now
Apply Now