Architect, Snowflake Cortex

Nimble Gravity, LLC; Portland (OR); On-site; USD 150,000 - 190,000; Full time

Job summary

Nimble Gravity, LLC is seeking an AI and data architect to design, build, and optimize Cortex-powered apps on Snowflake. You will lead data pipelines, semantic models, and governance, while collaborating with engineers and clients to deploy end-to-end AI solutions.

You’ll work with Snowflake Cortex, Snowpark, Python, and Streamlit to deliver scalable, secure, and cost-aware systems. If you enjoy solving complex problems in a consultative setting, join us.

Qualifications

• Proven experience as data/AI architect or senior engineer with Snowflake hands-on
• Strong SQL and Python with Snowpark experience
• Knowledge of Snowflake Cortex capabilities or similar LLM apps
• Familiarity with RAG, semantic search, text-to-SQL, and agentic patterns
• Solid data modeling, ELT/ETL, and orchestration (dbt, Airflow)
• Strong Snowflake security and governance (RBAC, masking, policies)
• Experience with CI/CD, APIs, and cloud fundamentals on Azure, AWS, or GCP

Responsibilities

• Architect and build AI applications on Snowflake using Cortex AI functions, Cortex Analyst, Cortex Search, Cortex Agents, and Snowflake Intelligence
• Shape pipelines, semantic models, and unstructured data processing to make AI outputs trustworthy
• Develop full-stack with Python, SQL, Snowpark, and Streamlit, integrating external APIs and LLMs as needed
• Design for scale and security with RBAC, masking, and governance from day one
• Tune warehouses, models, and queries to manage costs and performance for clients
• Lead architecture conversations: sessions, demos, and workshops with clients
• Collaborate with data engineers, data scientists, and app developers to deliver end-to-end outcomes
• Keep pace with Snowflake's AI roadmap and turn new capabilities into reusable patterns

Skills

SQL

Python

Snowflake

Snowpark

APIs

CI/CD

Cloud fundamentals

Education

Master's degree in a related field

Background in data science / machine learning

Tools

Snowflake Cortex

dbt

Airflow

Streamlit

Snowflake Intelligence

REST APIs

Job description

About Nimble Gravity: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.

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 process

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 Applied Anthropic Practice

About Nimble Gravity

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.