AI Data Engineer

AI Data Engineer

Join the Data Science team as an AI Data Engineer responsible for building the data foundations that make enterprise AI products accurate, explainable, and scalable. This role will design and implement Snowflake and dbt pipelines from raw source data to curated gold-layer datasets, create semantic models that LLM tools can use reliably, and partner with data science, product, and engineering teams to convert data dictionaries and business definitions into AI-ready data products. The ideal candidate is a strong data engineer with deep Snowflake/dbt experience and a practical understanding of how semantic layers, ER relationships, denormalized models, and metadata quality influence LLM and agent performance.

Key responsibilities include:

• Design, build, optimize, and operate Snowflake pipelines and dbt models across raw, curated, and gold-layer datasets.
• Create semantic models, relationships, metrics, dimensions, and curated views that allow LLM tools and agents to answer questions accurately.
• Translate team-defined data dictionaries, business definitions, and source mappings into tested, governed, and reusable data products.
• Design datasets for AI agents, natural-language analytics, Snowflake Cortex Analyst, and other LLM-powered tools.
• Balance normalized source models, ER relationships, dimensional models, denormalized consumption layers, and semantic-layer needs.

Qualifications:

• 6+ years of experience in data engineering, analytics engineering, database engineering, or data platform development in production environments.
• Strong hands-on experience with Snowflake, including SQL development, performance tuning, security-aware design, cost optimization, and large-volume processing.
• Strong hands-on experience with dbt or comparable ELT tooling, including models, tests, documentation, lineage, and environment promotion.
• Experience building raw-to-curated-to-gold data pipelines and business-ready datasets.
• Strong SQL and Snowflake development skills, including complex transformations, views, stored procedures/Snowflake Scripting, and query optimization.
• Experience creating semantic layers, semantic models, metrics, dimensions, relationships, and curated analytical views.
• Good understanding of ER modeling, dimensional modeling, denormalized consumption models, and data grain management.
• Experience translating data dictionaries and business definitions into physical models, dbt models, and semantic-layer definitions.
• Understanding of Snowflake Cortex capabilities such as Cortex Analyst, Cortex Complete, and semantic-model-driven natural-language querying.
• Ability to partner with data science, product, engineering, and business teams to deliver AI-ready data products.

Preferred experience:

• Experience in life sciences, healthcare, pharma commercialization, MDM, patient data, channel data, or commercial data platforms.
• Experience with Snowflake semantic views, Cortex Analyst, Cortex Search, or other AI/LLM data platform capabilities.
• Experience with data quality frameworks, metadata management, data observability, and lineage tooling.
• Experience with orchestration tools such as dbt Cloud jobs, Airflow, Dagster, cloud-native schedulers, or similar platforms.
• Experience with Python for data automation, metadata processing, testing, or API integrations.
• Experience designing governed data products for BI, AI/ML, natural-language analytics, or agentic applications.
• Snowflake SnowPro, dbt certification, or equivalent data engineering credentials.

IntegriChain offers:

• Mission driven: Work with the purpose of helping to improve patients' lives!
• Excellent and affordable medical benefits + non-medical perks including Student Loan Reimbursement, Flexible Paid Time Off and Paid Parental Leave
• 401(k) Plan with a Company Match to prepare for your future
• Robust Learning & Development opportunities including over 700+ development courses free to all employees