> Markdown version of [/jobs/ext/4700410-sr-snowflake-engineer-ai-cortex-solutions](https://www.wearedevelopers.com/jobs/ext/4700410-sr-snowflake-engineer-ai-cortex-solutions). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Sr. Snowflake Engineer - AI & Cortex Solutions

- **Company:** Acunor Inc
- **Location:** Wilmington, DE, United States
- **Experience:** Expert
- **Salary:** $145,600 - $156,000
- **Contract:** Temporary to permanent
- **Skills:** Artificial Intelligence, Amazon Web Services, Data Analysis, ARM Architecture, Unit Testing, Microsoft Azure, Business Software, Cloud Computing, Code Review, Databases, Data Architecture, Information Engineering, Data Governance, Extract Transform Load (ETL), Data Security, Data Warehousing, Database Design, Database Development, Dimensional Modeling, Information Retrieval, Python (Programming Language), Machine Learning, Performance Tuning, Query Optimization, Role-Based Access Control, Sentiment Analysis, SQL Databases, Systems Integration, Web Application Frameworks, Enterprise Search, Enterprise Data Management, Design of Telemetry/logging Agents, Freeform SQL, Google Cloud, Data Storage Technologies, Retrieval-Augmented Generation, Large Language Models, Snowflake, Prompt Engineering, Apache Spark, Data Layers, Data Analytics, Star Schema, Apache Kafka, Semantic Modeling, Streamlit Framework, Natural Language Understanding, Data Pipelines, Automation Anywhere
- **Published:** November 13, 2026
- **Apply:** https://www.careerbuilder.com/job-details/sr-snowflake-engineer-ai-cortex-solutions-wilmington-de--0ab31bb9-9666-4109-b5b5-aab6e2b0eb46

## About the Role

Artificial Intelligence (AI), Artificial Intelligence (AI), Consulting, Snowflake Schema, Cloud Computing, Data Analysis, Business Solutions, Metrics, Information Retrieval, Search Engine Optimization (SEO), Snowflake & AI Expertise
Hands on experience with Snowflake Cortex: Cortex Analyst, Cortex Search, Cortex Agents, AISQL Functions, Semantic Models.
Strong understanding of Snowflake's CoCO, Snowpark, and platform native AI capabilities.
Technical Skills
Proficiency in SQL, Python, and ETL/ELT tools ( Informatica, dbt etc.).
Experience with cloud platforms such as AWS, Azure, or GCP.
Familiarity with Spark, Kafka, and modern data engineering frameworks.
Data Warehousing & Modeling
Strong knowledge of dimensional modeling(star Schema), semantic modeling, data architecture, and analytical data design.
Experience integrating AI/ML patterns into enterprise data platforms..
Generative AI & LLMs
Experience with prompt engineering, RAG architectures, embeddings, and agent design.
Understanding of LLM driven workflows and enterprise AI application patterns.
Soft Skills
Strong problem solving abilities and analytical thinking.
Effective communication with technical and non technical stakeholders.
Ability to work collaboratively and take ownership of projects.

Certifications (Preferred)
Snowflake Certified Developer / SnowPro
Cloud certifications (AWS, Azure, GCP)

## Description

We are seeking a highly skilled Sr. Snowflake Engineer with strong AI, LLM, and Snowflake Cortex expertise to design, build, and optimize modern data, analytics, and AI applications on the Snowflake Data Cloud. This role blends advanced data engineering, semantic modeling, AI driven development, and enterprise grade Snowflake implementation to deliver scalable, measurable business outcomes.
Core Responsibilities
AI & Snowflake Cortex Responsibilities
AI Solution Design & Implementation: Build AI powered analytics, semantic insights, and business applications using Snowflake Cortex capabilities.
Semantic Models & Views: Develop and maintain semantic layers enabling natural language querying, governed metrics, and business friendly data access.
Cortex Search & Knowledge Retrieval: Design and optimize enterprise search solutions for document intelligence and knowledge retrieval.
Cortex Agents: Configure and orchestrate agents to unify structured and unstructured data sources for automated workflows.
AISQL Functions: Implement summarization, classification, extraction, sentiment analysis, and content generation use cases.
AI Application Development: Build interactive AI applications using Streamlit, Snowsight, and Python frameworks within Snowflake.
Testing & Improvement: Validate, monitor, and continuously enhance AI models, agents, and applications.
General Snowflake Development Responsibilities
Database Design & Management: Create and manage Snowflake databases, schemas, tables, and objects for efficient, organized data storage.
SQL Development: Write complex SQL queries to extract, transform, and load (ETL/ELT) data for analytics, reporting, and AI workflows.
Data Pipeline Development: Build and maintain scalable ETL/ELT pipelines to ingest data from diverse sources into Snowflake with high quality and reliability.
Performance Optimization: Monitor and optimize Snowflake performance through query tuning, clustering, micro partitioning, and workload scaling.
Security & Access Control: Implement RBAC, data governance, user permissions, and security policies to protect sensitive information.
Collaboration: Work closely with data engineers, analysts, architects, and business teams to translate requirements into scalable data and AI solutions.
Testing & Documentation: Conduct unit testing, code reviews, and maintain clear documentation for data workflows, pipelines, and AI applications.