AI Data Engineer
Core
Design and implement Snowflake and dbt pipelines to create AI-ready semantic models and gold-layer datasets for LLM tools and agents.
Role type
Senior AI Data Engineer
Builds
Production data pipelines, semantic models, and curated datasets for enterprise AI products
Domain
Life Sciences / Data Engineering / AI/LLM
Deliverable
production ML models
Required skills
Snowflake, dbt, SQL, semantic modeling, data pipeline development, data dictionary translation, ER modeling, Snowflake Cortex
Preferred skills
Life sciences domain knowledge, data quality frameworks, orchestration tools (Airflow/Dagster), Python, SnowPro certification
Technologies
Snowflake, dbt, Snowflake Cortex, Airflow, Dagster
Responsibilities
Build reliable data pipelines from raw to gold layers using Snowflake and dbt; Create semantic models and curated views for natural-language querying; Translate data dictionaries into physical and semantic models; Design ER relationships and join paths for AI agents; Partner with AI teams to optimize data models for LLM performance; Support data consolidation and governance across enterprise systems.