About the Role
Fivetran and dbt are building the open data infrastructure that powers AI agents you can trust. Fivetran is looking for a Staff R&D Software Engineer to join our fast-growing Fivetran AI team. This role goes well beyond standard engineering, requiring research into emerging AI techniques, product and market understanding to identify viable ideas, and the ability to ship these ideas as production software. The ideal candidate is a generalist capable of prototyping, backend development, SRE, and QA work. At this level, you are expected to be a trusted expert, defining technical direction, and independently executing high-level direction with sound judgment. Fivetran AI operates like a startup, requiring engineers who thrive on range and ambiguity.
Responsibilities
- Research emerging techniques in retrieval, reasoning, and agentic AI, and decide what's worth pursuing for Fivetran AI's roadmap, then convince others.
- Prototype new ideas quickly, then turn successful ones into shipped, production-grade features.
- Define technical direction spanning multiple teams within Fivetran AI, ensuring architecture decisions do not create downstream problems.
- Build and maintain both back-end and front-end systems for the Fivetran AI product, including Agents Schema pipelines and the Context Catalog UI.
- Drive the AISQL capability forward: natural language to SQL grounded in dbt metric definitions, executed natively against the warehouse.
- Take ownership of production reliability across the platform, including on-call rotation, incident response, and SRE work.
- Set the bar for testing and QA practices, and perform hands-on QA work.
- Use coding agents to automate repetitive tasks, freeing up time for research and design.
- Take high-level direction from product and leadership and independently define and execute the concrete plan to achieve goals.
- Mentor other engineers and raise the technical bar across the Fivetran AI team.
- Contribute to hiring by participating in and helping shape the interview process.
Requirements
- 8+ years of programming experience across Python and/or Java, with the ability to move fluidly between back-end and front-end work.
- Considered a trusted expert beyond your own team, able to exert influence and define technical direction across multiple teams.
- Comfortable reading AI/ML research and turning promising findings into working prototypes, then production systems.
- Strong product and market awareness — able to judge which emerging techniques are worth building versus which are hype.
- Track record of taking ambiguous, high-level direction and independently defining and executing the concrete work to deliver it.
- Experience with SQL and data warehouses (BigQuery, Snowflake, Databricks, or similar).
- Genuine willingness to work across the full stack: research, backend, frontend, SRE, and QA, as the team’s needs demand.
- Writes well-structured, performant code and can dive into unfamiliar codebases to suggest improvements.
- Experience using coding agents or similar AI tooling to speed up day-to-day engineering work.
- Demonstrated ability to mentor other engineers and influence technical decisions beyond your immediate team.
- Thrives in a startup-like environment with shifting priorities and a high degree of ownership.
Skills
- Python
- Java
- SQL
- dbt
- LLMs (Claude, ChatGPT, Gemini)
- Vector databases
- BigQuery
- Snowflake
- Databricks
- MCP protocol
- React
- TypeScript
- Kubernetes
- LLM-powered applications (RAG pipelines, embeddings, evaluation frameworks, or agent frameworks)
- Semantic layers (dbt, LookML, Sigma, or similar)
- MCP (Model Context Protocol) ecosystem
- AI agent integrations
- Site reliability engineering (monitoring, alerting, incident response)
- Data processing (ETL, ELT)
- Building data connectors
- Cloud environments (AWS, GCP)
- Docker
- Open source AI or data projects
Location
- New York, NY
Work Type
- Full-time
- Hybrid
Experience Level
- Staff
- 8+ years of programming experience
Salary/Compensations
- $196,033—$245,041.50 USD
Benefits
- 100% employer-paid medical insurance
- Generous paid time-off policy (PTO), plus paid sick time, inclusive parental leave policy, holidays, and volunteer days off
- RSU stock grants
- Professional development and training opportunities
- Company virtual happy hours, free food, and fun team-building activities
- Monthly cell phone stipend
- Access to an innovative mental health support platform
About the Company
- Fivetran's mission is to make access to data as simple and reliable as electricity.
- Fivetran and dbt Labs are merging to create a leading data infrastructure company.
- Together, they deliver the data infrastructure layer for moving, transforming, and trusting data.
- Fivetran automates data movement across systems, clouds, engines, and tools.
- dbt Labs pioneered analytics engineering, enabling reliable and governed insights.
- The combined company supports thousands of organizations in building a trusted foundation for analytics, AI, and business decisions.
- Fivetran is focused on building a world-class product that builds infrastructure agents can trust, embraces open standards, and scales without breaking.
- The company emphasizes using no-nonsense tools and takes pride in the simplicity and effectiveness of its systems.
- Fivetran is valued at over $5.6 billion and operates with core values of Get Stuck In, Do the Right Thing, and One Team, One Dream.
- Fivetran values and recognizes that diverse teams build a world-class company and better serve customers, people, and communities.
Equal Opportunity
- We are committed to ensuring that all candidates have an equal opportunity to participate in our interview process.
- If you require accommodations at any stage of the process due to a disability, medical condition, or any other circumstance, please submit your request by filling out this form.
- We will work with you to provide reasonable accommodations to facilitate your participation and ensure a fair and accessible interview experience.
- Your request and any information provided will be kept confidential and will not impact your candidacy.
