Architect, Snowflake Cortex

Nimble Gravity, LLC; United States; On-site; USD 120,000 - 180,000; Full time

Job summary

Nimble Gravity, LLC is seeking an AI and data architect to design, build, and productionize Cortex-powered AI applications on Snowflake, working with clients and engineers to turn ideas into reliable systems.

You will shape data foundations, implement pipelines and governance, and ensure security and cost controls, while leading architecture sessions, demos, and collaborative work with data scientists and developers.

Qualifications

• Proven experience as a data or AI architect or senior engineer with hands-on Snowflake experience.
• Strong SQL and Python skills, with Snowpark experience.
• Working knowledge of Snowflake Cortex or comparable LLM-based applications.
• Familiarity with RAG, semantic search, text-to-SQL, and agentic patterns.
• Solid grasp of data modeling, ELT/ETL, and orchestration (dbt, Airflow, or similar).
• Strong understanding of Snowflake security and governance: RBAC, masking, row access policies, and data sharing.
• Experience with CI/CD, APIs, and cloud fundamentals on Azure, AWS, or GCP.

Responsibilities

• Architect and build AI applications on Snowflake using Cortex functions, Cortex Analyst, Cortex Search, Cortex Agents, and Snowflake Intelligence.
• Build the data foundation: pipelines, semantic models, and unstructured data processing including Document AI.
• Develop full-stack: Python, SQL, Snowpark, and Streamlit; integrate with external APIs and LLMs where needed.
• Design for scale and security: RBAC, data masking, and governance from day one.
• Manage cost and performance: tune warehouses, models, and queries for predictable costs.
• Lead client conversations: run architecture sessions, demos, and workshops; communicate trade-offs.
• Collaborate: work with data engineers, data scientists, and app developers to deliver end-to-end results.
• Keep learning: follow Snowflake's AI roadmap and convert new capabilities into reusable patterns.

Skills

SQL

Python

Snowpark

Snowflake Cortex

RAG

semantic search

text-to-SQL

dbt

Airflow

CI/CD

APIs

cloud fundamentals

Tools

Streamlit

Snowflake Cortex

Snowflake Snowpark

Airflow

dbt

Job description

We’re a data, AI and digital engineering consultancy. Certified across Microsoft, Anthropic, and Databricks, we turn AI ambition into working systems for leaders who need results, not roadmaps.

You’ll design and deliver AI applications that run directly on our clients' Snowflake data, using Snowflake Cortex. We're looking for an AI and data architect who knows that a good model is only as useful as the data and governance behind it. You'll design, build, and optimize Cortex-powered applications, from first architecture sketch to production. You'll work with clients and engineers to turn abstract ideas into systems people use.

Key Responsibilities

• Architect and build: Design and implement AI applications on Snowflake using Cortex AI functions, Cortex Analyst, Cortex Search, Cortex Agents, and Snowflake Intelligence.
• Build the data foundation: Shape the pipelines, semantic models, and unstructured data processing (including Document AI) that make AI answers trustworthy.
• Develop full-stack: Build with Python, SQL, Snowpark, and Streamlit, and integrate with external APIs, applications, and LLM providers where the use case calls for it.
• Design for scale and security: Apply role-based access control, data masking, and governance so applications are secure, resilient, and compliant from day one.
• Manage cost and performance: Tune warehouses, models, and queries, and make consumption-based costs predictable for clients.
• Lead client conversations: Run architecture sessions, demos, and workshops. Help clients choose the right approach and understand the trade-offs.
• Collaborate: Work closely with data engineers, data scientists, and app developers to deliver end-to-end outcomes.
• Keep learning: Track Snowflake's fast-moving AI roadmap and turn new capabilities into reusable patterns for the team.

What We're Looking For

Required

• Proven experience as a data or AI architect or senior engineer, including hands-on work on Snowflake.
• Strong SQL and Python skills, with experience in Snowpark.
• Working knowledge of Snowflake Cortex capabilities, or comparable hands-on experience with LLM-based applications and a clear plan to ramp quickly.
• Familiarity with RAG, semantic search, text-to-SQL, and agentic patterns.
• Solid grasp of data modeling, ELT/ETL, and orchestration (dbt, Airflow, or similar).
• Strong understanding of Snowflake security and governance: RBAC, masking, row access policies, and data sharing.
• Experience with CI/CD, APIs, and cloud fundamentals on Azure, AWS, or GCP.

Preferred

• SnowPro Core or Advanced certification.
• Experience with Streamlit, Snowflake Native Apps, or Cortex Fine-tuning.
• Background in data science, machine learning, or formal engineering training.
• Experience integrating Snowflake with other AI platforms, including Claude.
• Consulting or client-facing delivery experience.

Core Qualities

• Problem-solving excellence: You approach hard technical challenges with creativity and rigor.
• Ownership and accountability: You take responsibility for design, delivery, and success.
• Adaptability: You're comfortable learning and shipping new technology in a fast-moving field.
• Collaboration: You communicate clearly and work well in a team.

Interview with Recruiter (30 min)
1st Technical Interview (45 min)
2nd Technical Interview (45 min)
Final Interview with VP, AI Applied Solutions
Case Studies

Nimble Gravity is a team of outdoor enthusiasts, adrenaline seekers, and experienced growth hackers. We love solving hard problems and believe the right data can transform and propel growth for any organization.

Nimble Gravity is an Equal Opportunity Employer and considers applicants for employment without regard to race, color, religion, sex, orientation, national origin, age, disability, genetics or any other basis forbidden under federal, state, or local law. Nimble Gravity considers all qualified applicants.