AI Automation Engineer SQL Snowflake

Forward Deployed AI Automation / Agentic AI Engineer (SQL & Snowflake)


Position Overview: 6 month contract


We are seeking a hands-on AI Automation / Agentic AI Engineer to join our team on a contract basis. In this role, you will design, build, and deploy AI-driven automation solutions, with a particular focus on optimizing internal request handling and operations workflows.


This is not a traditional, reporting-only data role. The ideal candidate blends agentic AI development, advanced SQL/Snowflake engineering, and API integrations to solve real-world business problems and eliminate manual processes.


Position Details

• Location/Schedule: Hybrid (3 days onsite, 2 days remote) | Standard Business Hours
• Assignment Type: Contract (Initial duration through the end of 2026, with potential for extension into 2027)
• Target Start Date: As soon as possible (July / Early August)

Key Responsibilities

• AI Workflow Development: Design, build, and implement practical AI automation workflows and standalone AI agents for internal business processes.
  
  
• Data Engineering & Structuring: Utilize SQL and Snowflake to access, analyze, validate, and structure clean datasets optimized for AI-enabled applications.
  
  
• System Integration: Connect applications, databases, and LLM models through robust API integrations to move data, trigger actions, and automate workflows end-to-end.
  
  
• Consultative Problem Solving: Partner closely with internal technical and non-technical stakeholders to uncover the root business challenges and translate those needs into technical solutions.
  
  
• Testing & Documentation: Validate SQL query performance, AI outputs, and overall workflow quality. Document all code and workflows thoroughly to ensure long-term maintainability.
  
  

Position Requirements


1. Hands-On Agentic AI / Generative AI Development (Must-Have)

• Proven experience building AI agents, AI workflows, or automation solutions utilizing LLMs.
  
  
• Must have experience integrating AI tools programmatically through APIs (experience limited to web interfaces like ChatGPT/Claude is insufficient).
  
  
• Deep understanding of prompt design, tool/function calling, data retrieval, workflow orchestration, and automation logic.
  
  
• Experience with RAG (Retrieval-Augmented Generation), LLM application development frameworks (e.g., LangChain, LlamaIndex), or AI-powered process automation.
  
  

2. Advanced SQL Experience (Must-Have)

• Advanced proficiency in writing, optimizing, and troubleshooting complex SQL queries (joins, window functions, CTEs).
  
  
• Ability to work with highly structured datasets to support AI applications.
  
  
• Note: Candidates must be comfortable passing a practical, live SQL technical assessment during the interview process.
  
  

3. Snowflake Expertise (Highly Preferred)

• Direct, hands-on experience with the Snowflake data platform is highly prioritized to ensure a fast ramp-up period.
  
  
• Experience leveraging Snowflake AI features, Cortex, Snowpark, or Snowflake-based automation is a major asset.
  
  

4. API Integration & Workflow Automation

• Strong experience connecting distinct systems, databases, and models via APIs.
  
  
• Proficiency with scripting languages (e.g., Python) to automate manual workflows, handle errors, and manage data pipelines.
  
  

5. Soft Skills & Problem Solving

• Stakeholder Empathy: A consultative mindset with the ability to understand internal user pain points and workflow bottlenecks.
  
  
• Autonomy: Proven capability to ramp up quickly in a fast-moving environment with minimal hand-holding.
  
  

Preferred Qualifications

• Experience working within a medical device, biotech, healthcare, or similarly regulated industry.
  
  
• Experience automating workflows related to quality systems, complaints, compliance, operations, or request-management.
  
  

Target Keywords for Applicants

• Core Skills: Agentic AI, GenAI, LLM Applications, AI Agents, RAG, Function Calling, Python.
  
  
• Data & Automation: SQL, Snowflake, Snowflake Cortex, Snowpark, API Integration, Workflow Automation, Data Pipelines.
  
  

Flexible work from home options available.