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.
Job details are sourced from the employer's original posting.
Open job postingAbout the company
The Data Analyst plays a key role in the supporting client implementations, expansions, and/or change requests. This is a contract to hire (CTH) role and we are looking for only candidates to IL. Responsibilities: • Work with various teams to recommend automation of manual process and performance enhancements. • Design & develop applications using UNIX scripting, SQL and Control-M. • Act as liaison between business area and technical team to ensure all parties have complete understanding of project scope and requirements. • Provide analytical and problem solving skills when addressing and resolving issues, assessing possible systems impacts, and recommending technical solutions. • Provide technical support to developers and consultants to ensure all company standards and procedures are met. • Conduct code walk-thru of systems solutions to ensure design quality and consistency, as well as cross-reference to the business requirements. • Utilize technical skills to design develop and test technical solutions to business. • Improve, automate, maintain and support existing batch processes. Qualified candidates will have: • BS in Computer Science or related discipline. • 2+ years IT experience, which includes SQL development with relational database (Sybase / Oracle / SQL Server) • Hands on experience with Sybase, UNIX, shell scripting is a plus • Experience with database consolidation, integration and migration projects. • Expertise in relational database design. • Excellent verbal and written communication, presentation and authoring skills. • Solid experience in data analysis, data modeling and performance tuning. • Strong analytical and problem solving skills. • Solid interpersonal and relationship building skills that enable cross functional partnerships. • Knowledge of IT industry trends and technologies. • Healthcare experience a plus • Experience with Real-time B2B, EDI, MQ Series, HIPAA transaction set is a plus. • ETL tools & process, including IBM InfoSphere experience is a plus. All your information will be kept confidential according to EEO guidelines.