Back to jobs

Snowflake AI Engineer

Pay
$110,000–140,000/year · Base — pay source
Experience with data observability and quality tooling (e.g., Monte Carlo, Elementary, or Snowflake data quality features). Compensation: The estimated base salary range for this position is between $110,000-$140,000 annually. Please note that this pay range serves as a general guideline and reflects a broad spectrum of labor markets across the US. While it is uncommon for candidates to be hired at or near the top of the range, compensation decisions are influenced by various factors. At HALO, these include, but are not limited to, the scope and responsibilities of the role, the candidate's work experience, location, education and training, key skills, internal equity, external market data, and broader market and business considerations. Benefits: At HALO, we offer benefits that support all aspects of your life, helping you find a work-life balance that’s right for you. Our comprehensive benefits include nationwide coverage for Medical, Dental, Vision, Life, and Disability insurance, along with additional Voluntary Benefits. Prepare for your financial future with our 401(k) Retirement Savings Plan, Health Savings Accounts (HSA), and Flexible Spending Accounts (FSA).
Read the full posting
Work setting
Hybrid — work setting source
Work setup in the employer’s posting: Hybrid
From the employer’s posting
Employment
Full-time — employment source
Job Type Full-time Description We are HALO! We connect people and brands to create unforgettable, meaningful, and lasting experiences that build brand engagement and loyalty for our over 60,000 clients globally, including over 100 of the Fortune 500. Our nearly 2,000 employees and 1,000 Account Executives located in 40+ sales offices across the United States are the reason HALO is #1 in our $25B industry.
Read the full posting

What you’ll work on

Full posting
  • Design and implement a Semantic Layer in Snowflake with consistent business definitions and metrics

  • Design, build, and deploy Snowflake Cortex Agents for natural language queries on enterprise data

  • Integrate Cortex Agents with the Semantic Layer so AI answers use certified data

  • Define and maintain semantic models, logical data objects, and certified metrics

  • Set up feedback loops and monitoring to improve agent answer quality

From the employer’s posting
Design and implement a comprehensive Semantic Layer within Snowflake, applying consistent business definitions, metrics, hierarchies, and context to our data assets.
Design, build, and deploy Snowflake Cortex Agents that allow business users to interact with enterprise data through natural language queries.
Integrate Cortex Agents with the Semantic Layer to ground AI responses in governed, certified data.
Define and maintain semantic models, logical data objects, and certified metrics that serve as the trusted foundation for analytics and AI use cases.
Establish feedback loops and monitoring to continuously improve agent performance, answer quality, and user trust.

Before you apply

Work authorization
Must already have the right to workRight to Work
Employer’s visa record
9 H-1B petitions approved in fiscal 2024 and 2025For the employer as a whole. This posting doesn’t say whether the role is sponsored. US Citizenship and Immigration Services.

What you’ll bring

All qualifications

Core experience

  • 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.

Preferred experience

  • Experience with LLM integration patterns, prompt engineering, or AI agent frameworks.
  • Familiarity with dbt for data transformation and semantic modeling.
  • Experience with data observability and quality tooling (e.g., Monte Carlo, Elementary, or Snowflake data quality features).
Qualification wording
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.
Experience with LLM integration patterns, prompt engineering, or AI agent frameworks.
Familiarity with dbt for data transformation and semantic modeling.
Experience with data observability and quality tooling (e.g., Monte Carlo, Elementary, or Snowflake data quality features).
Apply at HALO

Posting record

Report an error

Actively hiringFirst seen by us 3 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 18, 20263 days ago
Recorded sightings
5
Last seen by us
Nov 22, 2026
Employer says posted
Nov 6, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 3

Similar jobs usually come down between day 1 and day 15.

From 1,376 similar postings that came down. Coming down is not always a hire.

HALO is hiring

1 open job

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • dbt
  • Snowflake
Where the posting names them
- 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.
- 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.
- 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.
- 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.
We are HALO! We connect people and brands to create unforgettable, meaningful, and lasting experiences that build brand engagement and loyalty for our over 60,000 clients globally, including over 100 of the Fortune 500. Our nearly 2,000 employees and 1,000 Account Executives located in 40+ sales offices across the United States are the reason HALO is #1 in our $25B industry. HALO Branded Solutions is seeking a skilled and curious Snowflake AI Engineer to join our growing Data & Analytics team. In this role, you will be at the forefront of how we unlock the value of our enterprise data — building a robust Semantic Layer that brings structure and business context to our data assets, and developing intelligent Cortex Agents that empower our teams to get instant, trusted answers through natural language conversations. You will work closely with data engineers, business analysts, and stakeholders across the organization to understand how our data is created and used, translate that understanding into a well-governed semantic model, and bring it to life through Snowflake's AI-native capabilities. This is a high-impact, highly visible position for someone who loves both the craft of data engineering and the challenge of making data accessible to everyone. 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.
Cortex Agent Development • 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.
Platform & Collaboration • 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.
Requirements - 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).
- 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).
- 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).
- 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). Compensation: The estimated base salary range for this position is between $110,000-$140,000 annually. Please note that this pay range serves as a general guideline and reflects a broad spectrum of labor markets across the US. While it is uncommon for candidates to be hired at or near the top of the range, compensation decisions are influenced by various factors. At HALO, these include, but are not limited to, the scope and responsibilities of the role, the candidate's work experience, location, education and training, key skills, internal equity, external market data, and broader market and business considerations.

Your next step

Complete your application on recruiting.paylocity.com. The employer’s form will show what is required.

Applying through Paylocity

  • “Upload your resume and we’ll automatically fill out your application”: the form fills itself from your file, so check it before sending.

Already applied? Track this application

Job description

View original posting ↗

Job Type

Full-time

Description

We are HALO! We connect people and brands to create unforgettable, meaningful, and lasting experiences that build brand engagement and loyalty for our over 60,000 clients globally, including over 100 of the Fortune 500. Our nearly 2,000 employees and 1,000 Account Executives located in 40+ sales offices across the United States are the reason HALO is #1 in our $25B industry.


HALO Branded Solutions is seeking a skilled and curious Snowflake AI Engineer to join our growing  Data & Analytics team. In this role, you will be at the forefront of how we unlock the value of our  enterprise data — building a robust Semantic Layer that brings structure and business context to  our data assets, and developing intelligent Cortex Agents that empower our teams to get instant,  trusted answers through natural language conversations. You will work closely with data engineers, business analysts, and stakeholders across the  organization to understand how our data is created and used, translate that understanding into a  well-governed semantic model, and bring it to life through Snowflake's AI-native capabilities. This is  a high-impact, highly visible position for someone who loves both the craft of data engineering and  the challenge of making data accessible to everyone.  


Responsibilities


Semantic Layer Development 

• 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. 


Cortex Agent Development 

• 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. 


Platform & Collaboration 

• 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.

Requirements

  • 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. 


Preferred Experience

  • 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). 

 

Compensation: The estimated base salary range for this position is between $110,000-$140,000 annually. Please note that this pay range serves as a general guideline and reflects a broad spectrum of labor markets across the US. While it is uncommon for candidates to be hired at or near the top of the range, compensation decisions are influenced by various factors. At HALO, these include, but are not limited to, the scope and responsibilities of the role, the candidate's work experience, location, education and training, key skills, internal equity, external market data, and broader market and business considerations.


Benefits: At HALO, we offer benefits that support all aspects of your life, helping you find a work-life balance that’s right for you. Our comprehensive benefits include nationwide coverage for Medical, Dental, Vision, Life, and Disability insurance, along with additional Voluntary Benefits. Prepare for your financial future with our 401(k) Retirement Savings Plan, Health Savings Accounts (HSA), and Flexible Spending Accounts (FSA).


Application Information: To apply to this opportunity, click the APPLY button at the top right or very bottom of the screen to complete our online application. A resume is optional, so you may choose to upload and have the application prefill with your information. There are 5 sections to complete in total, including General information, Work History, Education, Compliance, and optional demographic questions. Once you have successfully submitted your application, you will receive a submission confirmation email from our system.


Application Deadline: Applications are reviewed and processed only when there is a specific need or opportunity, rather than on a fixed schedule or at a set deadline. Because they are reviewed on an as-needed basis, a job posting will be removed once the position has been filled or is no longer available.


More About HALO:

At HALO, we energize our clients' brands and amplify their stories to capture the attention of those who matter most. That’s why over 60,000 small- and mid-sized businesses partner with us, making us the global leader in the branded merchandise industry.

  • Career Advancement: At HALO, we’re passionate about promoting from within. Internal promotions have been key to our exponential growth over the past few years. With so many industry leaders at HALO, you’ll have the opportunity to accelerate your career by learning from their experience, insights, and skills. Plus, you'll gain access to HALO’s influential global network, leadership opportunities, and diverse perspectives.
  • Culture: We love working here, and we’re confident you will too. At HALO, you’ll experience a culture of ingenuity, inclusion, and relentless determination. We push the limits of possibility and imagination by staying curious, humble, and bold breaking through yesterday’s limits. Diversity fuels our creativity, and we thrive when each of us contributes to an inclusive environment based on respect, dignity, and equity. We hold ourselves to a high standard of excellence with a commitment to results and supporting one another with accountability, transparency, and dependability.
  • Recognition: At HALO, your success is our success. You can count on us to celebrate your wins. Colleagues across the company will join in recognizing your milestones and nominating you for awards. Over time, you’ll accumulate recognition that can be converted into gift cards, trips, concert tickets, and merchandise from your favorite brands.
  • Flexibility: Many of our roles offer hybrid work options, and we pride ourselves on flexible schedules that help you balance professional and personal demands. We believe that supporting our customers is a top priority and trust that you and your manager will collaborate to create a schedule that achieves this goal.

HALO is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We insist on an environment of mutual respect where equal employment opportunities are available to all applicants without regard to race, color, religion, sex, pregnancy (including childbirth, lactation and related medical conditions), national origin, age, physical and mental disability, marital status, sexual orientation, gender identity, gender expression, genetic information (including characteristics and testing), military and veteran status, and any other characteristic protected by applicable law. Inclusion is a core value at HALO and we seek to recruit, develop and retain the most talented people.


HALO participates in E-Verify. Please see the following notices in English and Spanish for important information: E-Verify Participation and Right to Work.


HALO is committed to working with and providing reasonable accommodations to individuals with disabilities. If you need reasonable accommodation because of a disability for any part of the employment process – including the online application and/or overall selection process – you may email us at hr@halo.com. Please do not use this as an alternative method for general inquiries or status on applications as you will not receive a response. Reasonable requests will be reviewed and responded to on a case-by-case basis.

Demand for AI Engineer roles

New AI Engineer postings at the employers we follow are up 340% over the last 6 weeks compared with the 6 before.

Weekly new AI Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 78, the most 803, and the latest week had 438.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under AI Engineer, by the work the posting describes.

AI engineers build products on top of AI models that already exist, most often large language models: they connect a model to a company's data and tools and ship the assistants, agents and search features people use.

Postings ask for strong Python or TypeScript, experience with model APIs, retrieval and agent frameworks, and ways to test whether the model's answers are good enough.

An ML engineer trains and serves models; an AI engineer usually starts from a model someone else trained and builds the product around it, though titles often mix the two.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
Experience with data observability and quality tooling (e.g., Monte Carlo, Elementary, or Snowflake data quality features). Compensation: The estimated base salary range for this position is between $110,000-$140,000 annually. Please note that this pay range serves as a general guideline and reflects a broad spectrum of labor markets across the US. While it is uncommon for candidates to be hired at or near the top of the range, compensation decisions are influenced by various factors. At HALO, these include, but are not limited to, the scope and responsibilities of the role, the candidate's work experience, location, education and training, key skills, internal equity, external market data, and broader market and business considerations. Benefits: At HALO, we offer benefits that support all aspects of your life, helping you find a work-life balance that’s right for you. Our comprehensive benefits include nationwide coverage for Medical, Dental, Vision, Life, and Disability insurance, along with additional Voluntary Benefits. Prepare for your financial future with our 401(k) Retirement Savings Plan, Health Savings Accounts (HSA), and Flexible Spending Accounts (FSA).
Location & working pattern

IL, USA

This passage needs a closer read in the full description.

Work authorization

This passage needs a closer read in the full description.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.