AI Automation 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.

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)

• 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.

• 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.
• 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., Lang Chain, Llama Index), or AI‑powered process automation.
• 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.
• Snowflake Expertise (Highly Preferred):
  Direct, hands‑on experience with the Snowflake data platform. Experience leveraging Snowflake AI features, Cortex, Snowpark, or Snowflake‑based automation is a major asset.
• 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.
• 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.

• 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.

• 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.