Haystack
← Back to Jobs
Technology
DW

AI Solutions Engineer (Snowflake & Generative AI)

Dale Workforce SolutionsPrinceton, NJ🇺🇸United StatesPosted 24 Aug 2026

Quick Overview

Seniority
Mid Senior
Work mode
Hybrid
Location
Princeton, NJ, United States
Posted
2 days ago
SQLSnowflakeGenerative AILLMPython

Job Description

Contract Position
Open to W2 or C2C
Remote, with travel to Princeton, NJ - 1-2 times per month

Position Summary:

We are seeking a Senior AI Solutions Engineer to accelerate the development and production of enterprise AI solutions within our Commercial Data & Analytics platform. This individual will be responsible for building AI-powered applications, semantic data models, and scalable data pipelines using Snowflake and modern Generative AI technologies.

The ideal candidate is a hands-on engineer with strong expertise in Snowflake, Python, SQL, and LLM-based application development who can quickly contribute to multiple high-priority AI initiatives.

Primary Responsibilities:
• Design and develop AI-powered applications using Snowflake Cortex, Large Language Models (LLMs), and Agentic AI frameworks.
• Build and optimize semantic models and AI-ready datasets for structured and unstructured data.
• Design and automate data ingestion, transformation, orchestration, and refresh pipelines.
• Integrate clinical, commercial, and external data sources into enterprise AI workflows.
• Optimize Snowflake performance and ensure production-ready, maintainable solutions.
• Support deployment, testing, and operationalization of AI solutions.

Required Qualifications:
• 7+ years of experience in Data Engineering, AI Engineering, or Software Engineering.
• Strong hands-on experience with Snowflake, including Snowpark, SQL, and performance optimization.
• Experience developing Generative AI applications using LLMs, Prompt Engineering, RAG, AI Agents, and workflow orchestration.
• Strong programming skills in Python.
• Experience designing semantic data models and enterprise data pipelines.

Preferred Qualifications:
• Experience with Snowflake Cortex (Analyst, Search, Complete, Intelligence, Cortex Agents).
• Experience with healthcare or life sciences data.
• Experience with OMOP, claims data, clinical trial data, or commercial pharmaceutical data.

Technical Skills:
• Snowflake (Snowpark, Cortex, SQL)
• Python
• Generative AI / LLMs
• RAG & AI Agents
• Prompt Engineering
• Semantic Modeling

Nice-to-Have Experience:
• Commercial Pharma Analytics
• Clinical Trials
• Claims Data
• OMOP Data Model

Similar jobs