Snowflake AI Engineer

HALO Branded Solutions is seeking a Snowflake AI Engineer to make enterprise data more accessible by developing a governed Semantic Layer and Snowflake Cortex Agents. The role partners with data teams, business analysts, and stakeholders to build trusted semantic models and natural-language data experiences.

Responsibilities

• Partner with stakeholders and data owners across HALO to develop a deep understanding of our enterprise data domains — including merchandise, orders, programs, client accounts, and recognition data
• Design and implement a comprehensive Semantic Layer within Snowflake, applying consistent business definitions, metrics, hierarchies, and context to our data assets
• Define and maintain semantic models, logical data objects, and certified metrics that serve as the trusted foundation for analytics and AI use cases
• Collaborate with the broader data team to ensure the Semantic Layer stays aligned with evolving data models, source systems, and business logic
• Document semantic definitions, lineage, and business rules to support data literacy and governance across the organization
• Design, build, and deploy Snowflake Cortex Agents that allow business users to interact with enterprise data through natural language queries
• Develop and fine-tune agent logic, intent parsing, and response generation to ensure accurate, reliable, and business-context-aware answers
• Integrate Cortex Agents with the Semantic Layer to ground AI responses in governed, certified data
• Establish feedback loops and monitoring to continuously improve agent performance, answer quality, and user trust
• Work with end users and stakeholders to identify high-value agent use cases, iterate on functionality, and drive adoption
• Stay current with Snowflake's evolving AI and data cloud capabilities, evaluating and championing new features relevant to our roadmap
• Contribute to data engineering best practices, coding standards, and peer review within the team
• Communicate technical concepts clearly to non-technical audiences, enabling business partners to understand and trust the data and AI tools you build
• Support data governance initiatives by promoting consistent, well-documented, and auditable data practices

Preferred

• Experience with LLM integration patterns, prompt engineering, or AI agent frameworks
• Familiarity with dbt for data transformation and semantic modeling
• Working knowledge of Python, particularly for Snowpark or Cortex API integrations
• Background 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 tooling (e.g., Monte Carlo, Elementary, or Snowflake data quality features)
• LLM Integration
• Prompt Engineering
• AI Agent Frameworks
• dbt
• Data Transformation
• Semantic Modeling
• Python
• Snowpark
• Cortex API Integration
• Branded Merchandise Data
• Retail Data
• Supply Chain Data
• B2B Services Data
• Snowflake SnowPro Certification
• Data Observability
• Data Quality Tooling
• Monte Carlo
• Elementary
• Snowflake Data Quality Features

Benefits

• Nationwide coverage for Medical, Dental, Vision, Life, and Disability insurance
• Additional Voluntary Benefits
• 401(k) Retirement Savings Plan
• Health Savings Accounts (HSA)
• Flexible Spending Accounts (FSA)
• Internal promotion opportunities
• Opportunity to accelerate your career by learning from industry leaders’ experience, insights, and skills
• Access to HALO’s influential global network, leadership opportunities, and diverse perspectives
• Recognition of milestones and nominations for awards; recognition can be converted into gift cards, trips, concert tickets, and merchandise
• Many roles offer hybrid work options
• Flexible schedules to help balance professional and personal demands, with employees and managers collaborating to create a schedule that supports customers

Company

• Branded merchandise, uniform programs, and recognition and incentive solutions
• Sterling, Illinois, USA
• http://www.halo.com/
• Founded in 1952
• 1001-5000 employees

Qualifications

• 3+ years of experience working with Snowflake in a data engineering, analytics engineering, or AI/ML engineering capacity
• Demonstrated experience designing and implementing semantic or logical data models (e.g., Snowflake Semantic Layer, dbt Semantic Layer, LookML, or equivalent)
• Hands-on experience with Snowflake Cortex features, including Cortex Analyst, Cortex Search, or AI/ML functions
• Strong SQL proficiency with deep knowledge of Snowflake-specific features (dynamic tables, materialized views, streams, tasks, row access policies)
• Solid understanding of enterprise data concepts — dimensional modeling, data vault, or medallion architecture patterns
• Experience working in cross-functional environments, translating business requirements into technical data solutions
• Strong communication skills — able to articulate data concepts to both technical and non-technical stakeholders
• Experience with LLM integration patterns, prompt engineering, or AI agent frameworks
• Familiarity with dbt for data transformation and semantic modeling
• Working knowledge of Python, particularly for Snowpark or Cortex API integrations
• Background 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 tooling (e.g., Monte Carlo, Elementary, or Snowflake data quality features)
• 3+ years of experience working with Snowflake in a data engineering, analytics engineering, or AI/ML engineering capacity.

Required skills

• Snowflake, SQL, Semantic Data Modeling, Snowflake Cortex Analyst, Snowflake Cortex Search, Snowflake AI/ML Functions, Dimensional Modeling, Data Vault, Medallion Architecture, dbt, Python, Snowpark, Prompt Engineering, Snowflake SnowPro Certification

Experience

• 3+ years