AI Finance Analytics Engineer & Automation Lead Job San Francisco area,California USA,IT/Tech

Requirements

AI-assisted development — You have used an LLM coding assistant (CoCo, Cursor, Git Hub Copilot, Claude, or equivalent) as your primary development tool — not an occasional helper, not a code reviewer. You know how to write a prompt that produces production-ready output, how to steer a model that's heading in the wrong direction, and how to encode domain logic into a reusable, parameterized skill.

You have a measurable, trackable record of daily AI usage
Prompt engineering and skill authoring — You can write a structured prompt (YAML + Markdown or equivalent) that routes correctly 95% of the time, handles edge cases gracefully, and encodes enough domain knowledge that the model behaves like a subject matter expert. You think in terms of context, instructions, examples, and output format — not just "the thing I typed before the code came out."
Python — Modern, type-hinted, readable. You write Python-based applications, data pipelines, and reporting automation. You understand caching, session state, and how to structure a multi-page app cleanly
SQL — CTEs, window functions, incremental pipeline patterns. You don't look up the syntax for a row-numbered deduplication
Data modeling fundamentals — You understand semantic layers, and how to build a model that a non-technical user can query in plain English
(Desirable) Snowflake Cortex — Cortex Analyst, Cortex Agents, , , Dynamic Tables, semantic views
(Desirable) Snow Work / CoCo — Prior experience deploying agents, authoring skill files, or working within the Snowflake Intelligence ecosystem
(Desirable) Finance literacy — You can read a revenue waterfall, distinguish ARR from NRR, and explain what drives a QoQ change in product revenue
(Desirable) Reporting automation — openpyxl, multi-tab Excel exports formatted to spec, named ranges
(Desirable) Dbt — Model authoring, () patterns, YAML tests in a cloud warehouse context
(Desirable) Semantic search / embeddings — Vector similarity, embedding-based retrieval, and how they power natural language analytics
1–3 years of experience in analytics, data engineering, or a technical finance adjacent role
Has used an AI coding assistant as a primary development tool — daily usage, not occasional
Proficient in SQL — you can write a window function without looking it up
Has shipped at least one Python application that end-users actually interacted with
Comfortable working in Git (PRs, branches, code review)
Familiar with fiscal year concepts and core revenue metrics (ARR, bookings, NRR)
Your stakeholders are financial analysts and senior directors who think in Excel models and board decks. You write prompts and code, but your output needs to make sense to someone who has never opened a terminal. You are the translation layer between what the model can do and what finance actually needs
You communicate complex ideas simply, ensuring stakeholders understand, trust, and can act on what you build. You are the translation layer between what the model can do and what finance actually needs

What the job involves

We are an AI-first analytics team. We don't use AI to augment traditional BI workflows — we've replaced them. The Finance Analytics team builds the intelligence layer that Strategic Finance runs on: AI agents that encode repeatable finance processes, Streamlit apps that surface real-time insight, semantic models that let any analyst query complex data in plain English, and workflow automations that collapse hours of manual work into a single prompt
Our primary development environment is CoCo (Cortex Code), Snowflake's AI coding assistant, and Snow Work, the AI IDE we ship work in. Every deliverable on this team is built AI-first: you design the workflow, you write the prompt, you validate the output. If you are still building dashboards by hand, refreshing Excel files manually, or treating AI as a spell-checker for your code — this role will ask you to operate differently
This is a high-breadth seat. One week you're building a new AI agent for quarterly revenue analysis; the next you're designing a sensitivity analysis tool for an earnings war room. You are equally comfortable in an AI-IDE, a…