Senior R&D Software Engineer, Fivetran AI

About the Role

Fivetran and dbt are building the open data infrastructure that powers AI agents you can trust.

Fivetran is looking for a Senior Staff R&D Software Engineer to join our fast‑growing Fivetran AI team. Your data stack was built for humans — but agents are the new primary data consumers, and they have fundamentally different requirements. Agents can’t intuit context; it must be explicitly codified, governed, and traceable. We’re building the governed context layer that solves this problem:
Agents Schema, an open standard for storing agent‑ready context directly in the customer’s own data warehouse, and Context Builder, the managed service that keeps it filled and fresh.

This role goes well beyond standard engineering. You’ll research emerging techniques in the fast‑moving AI landscape and bring real product and market understanding to decide which ideas are worth pursuing — and then you’ll take what you’ve learned and ship it as production software. We’re looking for a true generalist who is willing and able to wear whatever hat the moment calls for: prototyping a new retrieval technique one week, hardening a backend service the next, then doing SRE or QA work when the team needs it.

At this level, you’re a trusted expert beyond your own department — your judgment shapes technical direction across Fivetran AI and the teams it depends on, you define your own direction rather than waiting for it, and you execute with the highest level of independence. Fivetran AI operates like a startup within Fivetran, and we need engineers who thrive on that range and ambiguity rather than staying in one lane.

Fivetran is the epitome of data‑driven development — our engineering team is focused on building a world‑class product that:

• Builds Infrastructure Agents Can Trust — join our mission to deliver the governed context layer that AI agents depend on: accurate semantic definitions, traceable lineage, data contracts, and auditable history baked in from the start.
• Embraces Open Standards — help build portable, interoperable data infrastructure:
  Agents Schema, open formats (Iceberg, Delta Lake), MCP‑native interfaces, and connector skills that work with any model and any compute.
• Scales Without Breaking — work to make Fivetran AI efficient at agent scale, where unit costs deflate as volume grows and context retrieval is fast, accurate, and cost‑controlled.

This is a full‑time hybrid position based out of our Denver, CO office. Our hybrid work model offers a blend of remote flexibility and in‑person collaboration, including two days in the office each week to connect and build as a team.

Python, Java, SQL, dbt, LLMs (Claude, ChatGPT, Gemini), vector databases, Big Query / Snowflake / Databricks, MCP protocol, React, Type Script, Kubernetes

• Identify which emerging AI research and techniques are worth pursuing, and set the agenda for Fivetran AI’s technical roadmap accordingly
• Prototype new ideas quickly, then take the ones that prove out and turn them into shipped, production‑grade features
• Define technical direction that spans Fivetran AI and collaborating departments — product, data platform, and go‑to‑market — resolving architectural tradeoffs that cross department lines
• Build and maintain both back‑end and front‑end systems for the Fivetran AI product — from Agents Schema pipelines to the Context Catalog UI
• Set the long‑term technical vision for capabilities like AISQL: natural language to SQL grounded in dbt metric definitions, executed natively against the warehouse
• Take ownership of production reliability across the platform: on‑call rotation, incident response, and SRE work to keep the system trustworthy at scale
• Set the bar for engineering quality, testing, and QA practices across the department, and do hands‑on work yourself when it matters most
• Use coding agents to automate the repetitive parts of the job, freeing up time for the research and design work that needs a human
• Define your own priorities and roadmap based on your judgment of what will most move Fivetran AI forward, with minimal oversight
• Mentor staff and senior engineers, and act as a multiplier for…