Sr Data Engineer, Agentic AI

Senior Data AI Engineer (Snowflake / Semantic Modeling / Agentic AI) We're looking for a Senior Data AI Engineer to help build the foundation for next-generation AI and analytics capabilities within a healthcare payer environment. This role will focus on designing Snowflake-based semantic data assets that power trusted analytics, natural language querying, and agentic AI-driven insights. The ideal candidate brings deep Snowflake expertise, strong semantic modeling experience, and a passion for building scalable data products that enable both business users and AI-powered solutions to access and understand data more effectively. What You'll Be Doing • Design and implement scalable Snowflake data models and pipelines supporting analytics and Agentic AI initiatives • Build and maintain bronze, silver, and gold data layers using medallion architecture principles • Develop semantic views, business metrics, dimensions, and reusable data assets that support self-service analytics and natural language data access • Partner with product, analytics, and engineering teams to translate business requirements into governed data products • Optimize Snowflake performance, transformations, and data architecture for scalability and reliability • Implement data quality validation, profiling, testing, and governance practices • Support Snowflake Cortex-enabled analytics, semantic intelligence, and AI-assisted workflows • Document semantic definitions, data lineage, and architectural standards Required Experience • Healthcare or payer industry experience (member, claims, provider, quality, or reference data) • Expert-level Snowflake SQL skills, including complex transformations, CTEs, advanced joins, and analytic/window functions • Strong experience building Snowflake data solutions using medallion architecture (bronze, silver, gold) • Hands-on semantic modeling experience including metrics, dimensions, grain, relationships, and semantic views • Experience validating data quality, profiling datasets, and ensuring trustworthy business outputs • Strong communication skills and ability to work cross-functionally with product, analytics, and engineering teams Preferred Experience • Snowflake Cortex, semantic intelligence, or AI-enabled analytics solutions • Agentic AI, natural language analytics, or AI-assisted engineering workflows • dbt development and governed self-service analytics environments • Python for automation, metadata processing, validation, or AI-related engineering initiatives • Experience evaluating, troubleshooting, and optimizing AI agent performance This is an exciting opportunity to help shape the future of AI-powered analytics by building trusted semantic data foundations that support both business users and intelligent agent-driven solutions.