Snowflake AI Engineer

HALO Branded Solutions

. Partner with stakeholders and data owners across HALO to understand enterprise data domains, including merchandise, orders, programs, client accounts, and recognition data .

Posted 11/10/2026full-timeRemote • Illinois • United StatesMid-LevelSenior💰 $110,000 - $140,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and implementing Semantic Layers within Snowflake, ensuring alignment with enterprise data models and governance practices. Proficient in SQL and familiar with AI/ML integration patterns to enhance data accessibility and usability.

Highest-signal resume keywords

Snowflake ExperienceSemantic Data ModelingSQL ProficiencyAI/ML IntegrationData Governance

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Semantic Layer DesignLogical Data ModelsSQLDimensional ModelingData VaultMedallion ArchitecturePythonCortex FeaturesData TransformationData Quality Tooling

Soft Skills

Strong Communication SkillsCross-Functional Collaboration

Tools & Technologies

SnowflakeDbtCortex APIMonte CarloElementary

Certifications & Qualifications

Snowflake SnowPro Certification

Industry Keywords

Branded MerchandiseRetailSupply ChainB2B ServicesData Engineering

Tech Stack

Tools & technologies

CloudPythonSnowflakeSQLVault

About the role

Key responsibilities & impact

Partner with stakeholders and data owners across HALO to understand enterprise data domains, including merchandise, orders, programs, client accounts, and recognition data
Design and implement a comprehensive Semantic Layer within Snowflake with consistent business definitions, metrics, hierarchies, and context
Define and maintain semantic models, logical data objects, and certified metrics for analytics and AI use cases
Collaborate with the data team to align the Semantic Layer with evolving data models, source systems, and business logic
Document semantic definitions, lineage, and business rules to support data literacy and governance
Design, build, and deploy Snowflake Cortex Agents for natural-language interaction with enterprise data
Develop and fine-tune agent logic, intent parsing, and response generation
Integrate Cortex Agents with the Semantic Layer to ground AI responses in governed, certified data
Establish feedback loops and monitoring to improve agent performance, answer quality, and user trust
Identify high-value agent use cases, iterate on functionality, and drive adoption with end users and stakeholders
Evaluate and champion new Snowflake AI and data cloud capabilities
Contribute to data engineering best practices, coding standards, and peer review
Communicate technical concepts to non-technical audiences
Support data governance through consistent, documented, and auditable data practices

Requirements

What you’ll need

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, such as 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, including 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 cross-functional environments and translating business requirements into technical data solutions
Strong communication skills for articulating data concepts to 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, such as Monte Carlo, Elementary, or Snowflake data quality features
HALO participates in E-Verify

Benefits

Comp & perks

Nationwide Medical, Dental, Vision, Life, and Disability insurance coverage
Additional Voluntary Benefits
401(k) Retirement Savings Plan
Health Savings Accounts (HSA)
Flexible Spending Accounts (FSA)
Internal promotion and career advancement opportunities
Access to HALO’s influential global network, leadership opportunities, and diverse perspectives
Recognition awards convertible into gift cards, trips, concert tickets, and merchandise
Flexible schedules
Hybrid work options for many roles
Reasonable accommodations for individuals with disabilities