Snowflake AI Engineer

HALO Branded Solutions is seeking a Snowflake AI Engineer for its Data & Analytics team. The role develops a governed Semantic Layer and Snowflake Cortex Agents, making enterprise data accessible through trusted natural-language answers while collaborating with data teams and business stakeholders.

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

Benefits

• Nationwide coverage for Medical, Dental, Vision, Life, and Disability insurance, along with additional Voluntary Benefits.
• 401(k) Retirement Savings Plan
• Health Savings Accounts (HSA)
• Flexible Spending Accounts (FSA)
• Career advancement and internal promotion opportunities, with access to HALO’s influential global network and leadership opportunities.
• Recognition of milestones and awards, with recognition convertible into gift cards, trips, concert tickets, and merchandise.
• Many roles offer hybrid work options, and flexible schedules.

Company

• Branded merchandise, uniform programs, and recognition incentive solutions.
• Richmond, Virginia, USA
• https://www.boostbranding.com/
• Founded in 1983
• 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, Semantic Data Modeling, Snowflake Cortex Analyst, Snowflake Cortex Search, SQL, Snowflake Dynamic Tables, Materialized Views, Streams, and Tasks, Snowflake Row Access Policies, Dimensional Modeling, Data Vault, Medallion Architecture, dbt, Python

Experience

• 3+ years