Haystack
← Back to Jobs
Remote
Other
SP

Agentic AI Engineering - REMOTE

SR Partners LLCNew York, NY🇺🇸United StatesPosted Oct 13, 2026

Why This Role Stands Out

This remote Agentic AI Engineering role offers a unique opportunity to shape cutting-edge AI solutions within a reputable company, allowing you to leverage your advanced Snowflake and semantic modeling expertise. You'll thrive here if you possess a strong understanding of healthcare data and enjoy driving impactful projects with autonomy. Apply now to join a forward-thinking team and advance your career in AI.

Quick Overview

Seniority
Mid Senior
Work mode
Remote
Location
New York, NY, United States
Posted
21 hours ago
SQLSnowflakeAgiledbt

Job Description

Job Title - AI Data Engineer / Agentic AI Engineering

Location - Remote

Experience - 12+ years

As a Data Engineer, you will be a part of an Agile team to build healthcare applications and implement new features while adhering to the best coding development standards.

Skill Requirement :
Healthcare or payer domain experience, especially with member, claims, provider, quality, or reference data.
Snowflake SQL: Highly skilled. Must be able to develop complex transformations, optimize performance, and work confidently with CTEs, advanced joins, and analytic/window functions.
Snowflake Data Engineering: Strong real-world experience building curated data layers using medallion architecture principles across bronze, silver, and gold datasets.
Semantic Modeling / Semantic Layer Engineering: Must be able to define business-friendly metrics, dimensions, grain, relationships, and reusable semantic views on top of Snowflake data.
Snowflake Cortex / AI-Enabled Analytics: Experience supporting Snowflake Cortex-based analytics workflows, semantic intelligence, or agentic analytics use cases is strongly preferred.
Data Quality, Profiling, and Validation: Must be able to identify natural and surrogate keys, assess cardinality and distribution, validate transformations, and ensure trustworthy semantic outputs.
Strong communication and ownership: Able to work across engineering, product, and analytics partners, clarify requirements, and proactively drive work with limited direction.
Day to day Job Description of a Senior Data AI Engineer role:
Design and implement scalable Snowflake data models and pipelines that align with business objectives and agentic AI use cases.
Build curated bronze, silver, and gold data layers and reusable semantic assets that support trusted analytics and natural-language data access.
Collaborate with product, analytics, and engineering partners to translate complex requirements into governed data products and semantic models.
Optimize Snowflake queries, warehouse configurations, and transformation performance for reliability, scalability, and cost efficiency.
Design and implement data quality validation, profiling, and testing strategies to improve trust in downstream semantic outputs.
Contribute to lineage-aware transformation patterns, documentation, and engineering standards for reusable data assets.
Use dbt where applicable to develop modular transformations, tests, and deployment patterns; prior hands-on dbt experience is preferred.
Support Snowflake Cortex-enabled analytics, semantic intelligence, and agent-assisting workflows where applicable.
Troubleshoot production issues and implement durable long-term solutions.
Document architectural decisions, semantic definitions, and data lineage.


PSRTEK is a reputed technology recruitment and IT staffing brand with a global footprint and an admired client base. As an ideas and innovation powerhouse with a culture of excellence, we bring remarkable expertise and deliver powerfully transformative results.

Similar jobs