AI Solutions Engineer/Architect (Snowflake & Generative AI)

Client: global pharmaceutical company
Job: GenAI Solutions Engineer/Architect (Snowflake & Generative AI)
Location: 100% Remote, from anywhere in the US
Job type: 6-month contract Position

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

Experience with 1 of the below is required:
• Commercial Pharma Analytics
• Clinical Trials
• Claims Data
• OMOP Data Model