Staff R&d Software Engineer, Fivetran AI

Fivetran Fivetran · Data AI · Oakland, CA · Fivetran AI Department

Staff R&D Software Engineer for Fivetran AI team, focusing on building a governed context layer for AI agents. This involves researching emerging AI techniques (retrieval, reasoning, agentic AI), prototyping, and shipping production software. The role requires defining technical direction, building both backend and frontend systems, driving AISQL capabilities, ensuring production reliability, and setting testing standards. It emphasizes a generalist approach, working with technologies like Python, Java, SQL, LLMs, and vector databases.

What you'd actually do

  1. Research emerging techniques in retrieval, reasoning, and agentic AI, and decide what’s actually worth pursuing for Fivetran AI’s roadmap — then convince others
  2. Prototype new ideas quickly, then take the ones that prove out and turn them into shipped, production-grade features
  3. Define technical direction that spans multiple teams within Fivetran AI, ensuring architecture decisions made in one area don’t create problems in another
  4. Build and maintain both back-end and front-end systems for the Fivetran AI product — from Agents Schema pipelines to the Context Catalog UI
  5. Drive the AISQL capability forward: natural language to SQL grounded in dbt metric definitions, executed natively against the warehouse

Skills

Required

  • Python
  • Java
  • SQL
  • Kubernetes
  • LLMs
  • vector databases
  • BigQuery / Snowflake / Databricks
  • agentic AI
  • retrieval
  • reasoning

Nice to have

  • dbt
  • Claude
  • ChatGPT
  • Gemini
  • MCP protocol
  • React
  • TypeScript

What the JD emphasized

  • research emerging techniques
  • prototype new ideas quickly
  • shipped, production-grade features
  • Define technical direction
  • Build and maintain both back-end and front-end systems
  • production reliability
  • SRE
  • QA
  • coding agents to automate

Other signals

  • building the governed context layer that solves this problem
  • Agents Schema, an open standard for storing agent-ready context
  • Context Builder, the managed service that keeps it filled and fresh
  • research emerging techniques in retrieval, reasoning, and agentic AI
  • prototype new ideas quickly, then take the ones that prove out and turn them into shipped, production-grade features