Snowflake Cortex AI Engineer

Ontrac Solutions; Las Vegas (NV); On-site; USD 150,000 - 210,000; Full time

Job summary

OnTrac Solutions LLC is seeking a Snowflake Cortex AI Engineer to design, build, and operationalize AI-powered data solutions on Snowflake for a Las Vegas financial-services client. The role blends solution architecture, data engineering, and hands-on AI implementation, with a focus on Snowflake Cortex AI, Cortex Code, and Snowpark.

The ideal candidate will lead workshops from PoC to production, engage executives, and deliver production-grade AI/data platforms in a customer-facing, on-site

Qualifications

• Bachelor's degree and 12+ years IT experience after completing it.
• 5+ years in data engineering, analytics engineering, or data platforms.
• Deep expertise in Snowflake architecture, security, governance, and performance optimization.
• Hands-on experience with Snowflake Cortex AI, Cortex Code (CoCo / CoCo Desktop), Snowpark, and AI/ML integration patterns.
• Experience building LLM, RAG, vector search, and agentic AI solutions.
• Strong SQL and Python.
• Experience with Airflow, dbt, Spark, Kafka, and at least one cloud platform (AWS, Azure, or GCP).
• Strong customer-facing communication and solution-architecture skills.

Responsibilities

• Design and implement AI-powered data solutions using Snowflake Cortex AI, Cortex Code (CoCo), and CoCo Desktop
• Develop and deploy retrieval-augmented generation (RAG), agentic workflows, semantic layers, and enterprise AI applications
• Architect scalable data platforms on Snowflake, Kafka, Spark, Airflow, dbt, and cloud-native services
• Build robust ELT/ETL pipelines and real-time integrations
• Lead customer workshops, architecture reviews, proofs of concept, and production deployments
• Develop reusable accelerators, patterns, and best practices

Skills

SQL

Python

Snowflake Cortex AI

CoCo

CoCo Desktop

Snowpark

Airflow

dbt

Spark

Kafka

AWS

Azure

GCP

LLM

Vector search

Agentic AI

Education

Bachelor's degree

Tools

Snowflake Cortex AI

Job description

OnTrac is seeking a Snowflake Cortex AI Engineer to design, build, and operationalize AI-powered data solutions on Snowflake for an enterprise financial-services customer in Las Vegas. The role combines customer engagement, solution architecture, data engineering, and hands-on AI implementation, with a strong focus on Snowflake Cortex AI, Cortex Code (CoCo and CoCo Desktop), and Snowpark. You will take solutions from workshop and proof of concept through to production. This role is ideal for a highly technical, customer-focused engineer who can engage executives, architect solutions, and build production-grade AI and data platforms hands-on.

ENGAGEMENT

• Duration: long term; full-time or contract
• Location: Las Vegas, NV — onsite Monday to Friday
• You must be located in, or willing to relocate to, the Las Vegas area, and authorized to work in the United States

RESPONSIBILITIES

• Design and implement AI-powered data solutions using Snowflake Cortex AI, Cortex Code (CoCo), and CoCo Desktop
• Develop and deploy retrieval-augmented generation (RAG), agentic workflows, semantic layers, and enterprise AI applications
• Architect scalable data platforms on Snowflake, Kafka, Spark, Airflow, dbt, and cloud-native services
• Build robust ELT/ETL pipelines and real-time integrations
• Lead customer workshops, architecture reviews, proofs of concept, and production deployments
• Develop reusable accelerators, patterns, and best practices

REQUIRED QUALIFICATIONS

• Bachelor's degree, plus 12+ years of IT experience after completing it
• 5+ years in data engineering, analytics engineering, or data platforms
• Deep expertise in Snowflake architecture, security, governance, and performance optimization
• Hands-on experience with Snowflake Cortex AI, Cortex Code (CoCo / CoCo Desktop), Snowpark, and AI/ML integration patterns
• Experience building LLM, RAG, vector search, and agentic AI solutions
• Strong SQL and Python
• Experience with Airflow, dbt, Spark, Kafka, and at least one cloud platform (AWS, Azure, or GCP)
• Strong customer-facing communication and solution-architecture skills

USEFUL QUALIFICATIONS

• Snowflake certifications (SnowPro Advanced: Architect, Data Engineer, or AI specialization)
• Streamlit, Dynamic Tables, Snowpipe, and Snowflake Native Apps
• Integrating OpenAI, Anthropic, Gemini, or open-source models
• Knowledge of enterprise security, governance, privacy, and compliance frameworks
• Banking, payments, or other regulated financial-services experience