Snowflake AI Engineer

This is a fully remote position, open to applicants in Illinois.

📋 Description

• Collaborate with stakeholders and data owners throughout HALO to gain insights into enterprise data domains, including merchandise, orders, programs, client accounts, and recognition data.

• Create and implement a robust Semantic Layer within Snowflake featuring consistent business definitions, metrics, hierarchies, and context.

• Define and oversee semantic models, logical data objects, and certified metrics for analytics and AI applications.

• Work alongside the data team to ensure the Semantic Layer aligns with changing data models, source systems, and business logic.

• Document semantic definitions, lineage, and business rules to enhance data literacy and governance.

• Design, construct, and deploy Snowflake Cortex Agents for natural-language interaction with enterprise data.

• Develop and refine agent logic, intent parsing, and response generation.

• Integrate Cortex Agents with the Semantic Layer to ensure AI responses are grounded in governed, certified data.

• Establish feedback mechanisms and monitoring systems to enhance agent performance, answer quality, and user trust.

• Identify high-impact agent use cases, iterate on functionality, and drive user adoption among end users and stakeholders.

• Assess and advocate for new Snowflake AI and data cloud capabilities.

• Contribute to data engineering best practices, coding standards, and peer review processes.

• Articulate technical concepts to non-technical audiences effectively.

• Support data governance through consistent, documented, and auditable data practices.

⛳️ Requirements

• Over 3 years of experience working with Snowflake in roles related to data engineering, analytics engineering, or AI/ML engineering.

• Proven experience in designing and implementing semantic or logical data models, such as Snowflake Semantic Layer, dbt Semantic Layer, LookML, or similar frameworks.

• Practical experience with Snowflake Cortex features, including Cortex Analyst, Cortex Search, or AI/ML functionalities.

• Strong proficiency in SQL with extensive knowledge of Snowflake-specific features, such as dynamic tables, materialized views, streams, tasks, and row access policies.

• Solid understanding of enterprise data concepts, including dimensional modeling, data vault, or medallion architecture patterns.

• Experience working in collaborative environments and translating business needs into technical data solutions.

• Excellent communication skills for conveying data concepts to both technical and non-technical stakeholders.

• Familiarity with LLM integration patterns, prompt engineering, or AI agent frameworks.

• Knowledge of dbt for data transformation and semantic modeling.

• Working knowledge of Python, especially for Snowpark or Cortex API integrations.

• Experience in branded merchandise, retail, supply chain, or B2B services data environments.

• Snowflake SnowPro certification (Core or Advanced: Data Engineer).

• Experience with data observability and quality tools, such as Monte Carlo, Elementary, or Snowflake data quality features.

• HALO participates in E-Verify.

🏝️ Benefits

• Comprehensive Medical, Dental, Vision, Life, and Disability insurance coverage nationwide.

• Additional Voluntary Benefits available.

• 401(k) Retirement Savings Plan.

• Health Savings Accounts (HSA).

• Flexible Spending Accounts (FSA).

• Opportunities for internal promotion and career advancement.

• Access to HALO’s influential global network, leadership opportunities, and diverse perspectives.

• Recognition awards redeemable for gift cards, trips, concert tickets, and merchandise.

• Flexible work schedules.

• Hybrid work options for a variety of roles.

• Reasonable accommodations for individuals with disabilities.