Senior Staff R&d Software Engineer, Fivetran AI

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

Senior Staff R&D Software Engineer for Fivetran AI, focusing on building the governed context layer for AI agents. The role involves researching emerging AI techniques, prototyping, shipping production software, and defining technical direction for agent-ready context, including Agents Schema and Context Builder. Responsibilities span backend, frontend, and SRE work, with an emphasis on building infrastructure agents can trust, embracing open standards, and scaling efficiently.

What you'd actually do

  1. Identify which emerging AI research and techniques are worth pursuing, and set the agenda for Fivetran AI’s technical roadmap accordingly
  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 Fivetran AI and collaborating departments — product, data platform, and go-to-market — resolving architectural tradeoffs that cross department lines
  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. Set the long-term technical vision for capabilities like AISQL: natural language to SQL grounded in dbt metric definitions, executed natively against the warehouse

Skills

Required

  • Python
  • Java
  • SQL
  • dbt
  • LLMs (Claude, ChatGPT, Gemini)
  • vector databases
  • BigQuery / Snowflake / Databricks
  • MCP protocol
  • React
  • TypeScript
  • Kubernetes
  • research emerging techniques
  • prototyping
  • production software development
  • backend development
  • frontend development
  • SRE
  • QA
  • technical roadmap definition
  • architectural tradeoffs
  • long-term technical vision
  • natural language to SQL

Nice to have

  • coding agents to automate repetitive tasks

What the JD emphasized

  • agents are the new primary data consumers
  • fundamentally different requirements
  • research emerging techniques
  • ship it as production software
  • true generalist
  • wear whatever hat the moment calls for
  • prototyping a new retrieval technique
  • hardening a backend service
  • SRE or QA work
  • trusted expert beyond your own department
  • define your own direction
  • highest level of independence
  • operates like a startup
  • thrive on that range and ambiguity
  • building the governed context layer that AI agents depend on
  • Agents Schema, an open standard
  • Context Builder, the managed service
  • AISQL

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 the fast-moving AI landscape
  • ship it as production software
  • prototyping a new retrieval technique
  • hardening a backend service
  • AISQL: natural language to SQL grounded in dbt metric definitions