AI Data Integration Engineer

Candidate Portal

Create Job Alert

Search JobsSign InRegister With UsLanguageEnglishEspañolFrancais中文

Job List

AI Data Integration Engineer #26-01461

Onsite

Apply Now

Share on

Job Description

100% Remote.

Location

Natchitoches, Louisiana (100% Remote)

Duration

6 Month C2H

Job Description

We are seeking an AI Data Integration Engineer with strong hands-on experience in Snowflake, healthcare claims

data, and practical AI/LLM integration.

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.

This role sits at the intersection of data engineering, AI development, and healthcare domain expertise.

MINIMUM REQUIREMENTS (REQUIRED TO HIRE)

Technical

3+ years of hands-on Snowflake experience, including

o SQL, semi-structured data (JSON), UDFs

o Secure Views & Masking Policies

o Data modeling (Star/Snowflake schemas)

o Performance optimization

• Strong experience building ETL/ELT pipelines in a modern data stack.
• At least 1–2 years of applied

AI/LLM development, including

o Designing prompt pipelines

o Calling LLM APIs (Azure OpenAI, OpenAI, Anthropic, etc.)

o Integrating structured data into LLM workflows

• Previous work with healthcare or claims datasets (medical or pharmacy).
• Strong understanding of HIPAA privacy principles, de-identification strategy, and PHI minimization.

Soft Skills

• Clear written and verbal communication.
• Ability to translate product requirements into technical solutions.
• Comfortable working in a fast-paced, evolving environment.
• Highly collaborative; strong problem-solving mindset.

PREFERRED QUALIFICATIONS (STRONG PLUS)

Azure & Enterprise AI

Experience with Azure AI Foundry, including

o Model catalog & deployments

o Agents / tool-calling workflows

o Responses API

o Vector indexing and retrieval

• Experience with Azure OpenAI in a HIPAA environment.
• Familiarity with Health Data Services, FHIR, or Fabric Healthcare Data Solutions.

Advanced Data & AI

• Experience building RAG pipelines, vector embeddings, semantic search.
• Experience designing AI-driven analytics, copilot-style solutions, or automated insights tools.
• Background in ML Ops, data governance, or data privacy engineering.

Healthcare Domain

• PBM or payer experience (pharmacy claims, accumulators, benefit design).

Experience generating insights such as

o Cost driver analysis

o Adherence metrics

o Trend & utilization insights

o Plan optimization / savings recommendations

• Previous work supporting clinical, actuarial, or analytics teams.

SUCCESS CRITERIA (HOW PERFORMANCE WILL BE EVALUATED)

o Snowflake sanitized views delivered, validated, and securely deployed.

o AI integration produces accurate, explainable insights consistently.

o Reduction in manual analysis time for internal teams.

o High-quality documentation and reproducible pipelines.

o Successful prototype or pilot for Azure AI Foundry–based expansion.

o Trusted partnership with product, clinical, and engineering teams.

TOOLS & TECHNOLOGIES USED

Required

Snowflake, SQL, ETL/ELT tools (DBT, Matillion, Airflow, etc.), Python, APIs, LLMs (Azure OpenAI or OpenAI), Git.

Preferred

Azure AI Foundry, Azure Functions, Azure Service Bus, Fabric, FHIR APIs, Databricks (optional), Vector DBs.

Job Responsibilities

CORE RESPONSIBILITIES

Snowflake Data Engineering (Primary Responsibility)

• Design, develop, and maintain sanitized, de-identified views in Snowflake for AI consumption.
• Implement robust ETL/ELT transformations to prepare claims, pharmacy, member, and utilization data for

downstream AI and analytics workflows.

• Build reusable data models, UDFs, and stored procedures to compute derived metrics (e.g., utilization

flags, cost drivers, adherence metrics, risk markers).

• Ensure data structures follow HIPAA privacy, minimization, and de-identification best practices.
• Collaborate with product and AI teams to define minimal-but-sufficient data schemas for AI analysis.

AI Integration & Feature Development

• Build the first version of a claims insight engine using LLMs (Azure OpenAI, OpenAI, or similar) grounded

on Snowflake data.

• Create schemas and payloads to feed structured data into AI prompts or agent pipelines.

Produce structured outputs such as

• Patterns in claims behavior
• Cost savings opportunities
• Potential issues in plan design
• Member-level or population-level recommendations
• Explanation narratives suitable for clients or internal teams
• Work with the product team to design LLM prompt strategies, guardrails, and output formatting.

Data Governance & Compliance

• Implement data privacy controls, PHI minimization, and secure access layers within Snowflake.
• Work with compliance teams to validate that AI inputs follow regulatory and organizational standards.
• Maintain auditability and logging for data access and AI interactions.

Collaboration

• Partner with product managers, analysts, and AI engineers to understand requirements and translate

them into technical deliverables.

• Educate internal teams on how the AI insights layer works (Snowflake view, AI input, AI output patterns).
• Participate in roadmap planning to evolve the claims AI platform into a scalable enterprise solution.

About Us

InterSources Inc, a Certified Diverse Supplier, was founded in 2007 and offers innovative solutions to help clients with Digital Transformations across various domains and industries. Our history spans over 16 years and today we are an Award-Winning Global Software Consultancy solving complex problems with technology. We recognize that our employees and our clients are our strengths as the diverse talents and opportunities they bring to the table enable us to grow as a global platform and they are causally linked with our success. We provide strategic and technical advice, and we have expertise in areas covering Artificial Intelligence, Cloud Migration, Custom Software Development, Data Analytics Infrastructure & Cloud Solutions, Cyber Security Services, etc. We make reasonable accommodations for clients and employees and we do not discriminate based on any protected attribute including race, religion, color, national origin, gender sexual orientation, gender identity, age, or marital status. We also are a Google Cloud partner company. We align strategy with execution and provide secure service solutions by developing and using the latest technologies that thrive our resources to deliver industry-leading capabilities to our clients and customers, making it convenient for our clients to do business with InterSources Inc. Our teams also drive growth by refining technology-driven client experiences that put the users first, providing an unparalleled experience. This results in strengthening the core technologies of clients, enabling them to scale with flexibility, create seamless digital experiences and build lifelong relationships.