AI/Data Engineer

Codetech • New Orleans, LA

1d

About The Position

The AI Data Integration Engineer will create a sanitized healthcare claims data layer using Snowflake views, models, and pipelines. Internal and external AI systems will use this layer to identify insights, patterns, savings opportunities, and potential issues for members and clients. The role combines data engineering, AI development, and healthcare domain expertise, with a preferred focus on integrating solutions in Azure AI Foundry to support future enterprise AI agents, copilots, and analytics capabilities.

Performance will be evaluated based on delivery and secure deployment of validated sanitized Snowflake views; accurate, explainable AI insights; reduced manual analysis time; high-quality documentation and reproducible pipelines; a successful Azure AI Foundry expansion prototype or pilot; and trusted collaboration with product, clinical, and engineering teams.

Requirements

• At least 3 years of hands-on Snowflake experience, including SQL, semi-structured JSON data, UDFs, secure views, masking policies, data modeling with Star or Snowflake schemas, and performance optimization.
• Strong experience building ETL/ELT pipelines in a modern data stack.
• At least 1–2 years of applied AI/LLM development, including prompt pipeline design, calling LLM APIs, and integrating structured data into LLM workflows.
• Previous work with healthcare or medical or pharmacy claims datasets.
• Strong understanding of HIPAA privacy principles, de-identification strategy, and PHI minimization.
• Clear written and verbal communication skills.
• Ability to translate product requirements into technical solutions.
• Comfort working in a fast-paced, evolving environment.
• Collaborative approach and strong problem-solving mindset.
• Experience with Snowflake, SQL, ETL/ELT tools, Python, APIs, LLMs such as Azure OpenAI or OpenAI, and Git.

Nice To Haves

• Experience with Azure AI Foundry, including model catalog and deployments, agents or tool-calling workflows, Responses API, and vector indexing and retrieval.
• Experience with Azure OpenAI in a HIPAA environment.
• Familiarity with Health Data Services, FHIR, or Fabric Healthcare Data Solutions.
• Experience building RAG pipelines, vector embeddings, or semantic search.
• Experience designing AI-driven analytics, copilot-style solutions, or automated insights tools.
• Background in MLOps, data governance, or data privacy engineering.
• PBM or payer experience, including pharmacy claims, accumulators, or benefit design.
• Experience generating cost driver analysis, adherence metrics, trend and utilization insights, or plan optimization and savings recommendations.
• Previous work supporting clinical, actuarial, or analytics teams.
• Experience with Azure Functions, Azure Service Bus, Fabric, FHIR APIs, Databricks, or vector databases.

Responsibilities

• Build and maintain a sanitized claims data layer using Snowflake views, data models, and pipelines.
• Integrate structured healthcare claims data into AI and LLM workflows to generate insights, patterns, savings opportunities, and potential issue detection.
• Design prompt pipelines and call LLM APIs.
• Apply HIPAA privacy principles, de-identification strategies, and PHI minimization to data and AI workflows.
• Deliver validated, securely deployed Snowflake views and reproducible data pipelines.
• Develop a prototype or pilot for expansion using Azure AI Foundry.
• Document solutions and collaborate with product, clinical, engineering, and analytics teams.

What This Job Offers

• Job Type: Full-time
• Education Level: No Education Listed