AI Data Integration Engineer

Aventiqo is seeking an AI Data Integration Engineer to support its data and artificial intelligence initiatives. The role will lead the creation of a sanitized healthcare claims data layer in Snowflake for AI systems and integrate AI solutions using Azure AI Foundry to support agents, copilots, and analytics capabilities.

Responsibilities:

• This role will lead the creation of a sanitized claims data layer (Snowflake views, models, and pipelines) used by internal and external AI systems to identify insights, patterns, savings opportunities, and potential issues for our members and clients
• Preferred candidates will also have experience integrating AI solutions in Azure AI Foundry, enabling us to scale toward enterprise-level AI agents, copilots, and analytics capabilities in the future

Requirements:

• Candidates must be authorized to work in the U.S. with no sponsorship
• 3+ years of hands-on Snowflake experience, including:
• SQL, semi-structured data (JSON), UDFs
• Secure Views & Masking Policies
• Data modeling (Star/Snowflake schemas)
• Performance optimization
• Strong experience building ETL/ELT pipelines in a modern data stack
• At least 1–2 years of applied AI/LLM development, including:
• Designing prompt pipelines
• Calling LLM APIs (Azure OpenAI, OpenAI, Anthropic, etc.)
• Integrating structured data into LLM workflows
• Previous work with healthcare or claims datasets (medical or pharmacy)
• experience integrating AI solutions in Azure AI Foundry