Sr. Principal AI Systems Architect

Fivetran; Oakland (CA); Hybrid; USD 252,000 - 315,000; Full time

Benefits offered by this job

Employer-paid medical insurance

Generous PTO

Paid sick time

Parental leave

Holidays and time off

Volunteer days off

RSU stock grants

Professional development

Team events

Monthly cell phone stipend

Mental health support

Job summary

Fivetran in Oakland, CA is seeking a engineer-architect to shape the AI analyst experience. You will own the architecture behind the analyst AI system, including metadata contracts, tool interfaces, context assembly, and evaluation loops, building a product-quality, reliable workflow.

This is a full-time, hybrid role based in our Oakland office with remote flexibility and two days in the office each week to collaborate as a team.

Qualifications

• Extensive experience building AI-enabled product systems.
• Strong software architecture skills around APIs and orchestration.
• Practical understanding of LLM prompting, tool use, retrieval, and evaluation methods.

Responsibilities

• Define the architecture for the analyst AI stack across prompts, tools, metadata, memory and context strategies, evaluation, and runtime safety.
• Build the abstractions and interfaces that allow product teams to add new agent capabilities without brittle prompt sprawl.
• Design retrieval and context strategies that give the model the right information at the right time with strong cost, latency, and quality tradeoffs.
• Establish evaluation loops, benchmark suites, and review processes to measure, debug, and improve model behavior.
• Partner with product, engineering, and analyst-domain experts to translate real analytical workflows into robust AI-enabled product capabilities.
• Drive quality standards around correctness, trust, transparency, and failure handling in analyst-facing AI experiences.

Skills

AI product systems

Software architecture

LLM prompting

Tool integration

Retrieval strategies

Evaluation methods

Backend engineering

Product collaboration

Tools

APIs

Contracts

Orchestration

Context management

Job description

From Fivetran’s founding until now, our mission has remained the same: to make access to data as simple and reliable as electricity. With Fivetran, customer data arrives in their warehouses, canonical and ready to query, with no engineering or maintenance required. We’re proud that more organizations continue to leverage our technology every day to become truly data-driven.

About Us

Fivetran and dbt Labs are bringing together two industry-leading companies with a shared mission: helping organizations unlock the full value of their data. Together, we’re delivering the data infrastructure layer that helps organizations move, transform, and trust their data — from the moment data moves, through every transformation, to the context teams and AI systems rely on. Fivetran helps organizations automate data movement across the systems, clouds, engines, and tools they rely on. dbt Labs pioneered analytics engineering, helping teams transform data into reliable, governed insights. Together, we support thousands of organizations as they build a trusted foundation for analytics, AI, and better business decisions. As we bring our teams and technology together, we’re building on the strengths of both companies while continuing to deliver the products and experiences our customers know and trust. It’s an exciting time to join us: we’re creating a company with the scale, talent, and technology to help more organizations put their data to work with greater speed, confidence, and impact. During this transition period, you may see references to both Fivetran and dbt Labs throughout our recruiting process as we integrate our teams, systems, and career sites.

About The Role

Fivetran needs an engineer-architect who can make the AI analyst experience real, dependable, and extensible. This role owns the architecture behind the analyst AI system, including metadata contracts, tool interfaces, context assembly, prompt and skill orchestration, evaluation loops, and the operational patterns that make agents useful in real workflows instead of isolated demos.

This is a systems role as much as an AI role. The challenge is not just getting an LLM to do something impressive once. The challenge is building a product-quality analyst system that can reason over schema and business context, use tools correctly, recover from ambiguity, and improve through disciplined evaluation and iteration.

This is a full-time, hybrid position based at our Oakland, CA 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.

What You'll Do

• Define the architecture for the analyst AI stack across prompts, tools, metadata, memory and context strategies, evaluation, and runtime safety.
• Build the abstractions and interfaces that allow product teams to add new agent capabilities without creating brittle prompt sprawl.
• Design retrieval and context strategies that give the model the right information at the right time with strong cost, latency, and quality tradeoffs.
• Establish evaluation loops, benchmark suites, and review processes so model behavior can be measured, debugged, and improved systematically.
• Partner with product, engineering, and analyst-domain experts to translate real analytical workflows into robust AI-assisted product capabilities.
• Drive quality standards around correctness, trust, transparency, and failure handling in analyst-facing AI experiences.

What We're Looking For

• Deep experience building AI-enabled product systems, not just running experiments.
• Strong software architecture skills, especially around APIs, contracts, orchestration, and system boundaries.
• Practical understanding of LLM prompting, tool use, retrieval, structured outputs, and evaluation methods.
• Ability to work fluently across backend engineering, product constraints, and user workflow design.
• Clear judgment about where agent systems should be flexible and where they should be constrained.
• Comfort working in ambiguous environments where patterns are still being invented.

Why This Role Matters

The quality of the AI analyst experience will shape how differentiated Fivetran feels. This role determines whether the system is merely novel or actually reliable enough to become part of an analyst's day-to-day workflow. Strong architecture here reduces product risk and creates leverage for the rest of the team.

The compensation range displayed on this job posting reflects the minimum and maximum target for new hire compensation for the target position and level, and may include sales incentives or target bonuses depending on the role. Our compensation ranges are determined by role, level, and location. Our job titles may span more than one career level. Within the range, individual compensation is determined by additional factors, including job-related skills, experience, relevant education or training, business need, market demands.

Oakland Pay Range

$251,835—$314,794 USD

Your recruiter can share more about the specific compensation range for your location during the hiring process.

Perks And Benefits

• 100% employer-paid medical insurance
• Generous paid time-off policy (PTO), plus paid sick time, inclusive parental leave policy, holidays (including a year end Global Week of Rest), 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 that offers personalized care and resources in areas such as: therapy, coaching, and self-guided mindfulness exercises for all covered employees and their covered dependents.

*May vary by country and worker type - please reach out to your recruiter for more information

We’re honored to be valued at over $5.6 billion, but more importantly, we’re proud of our core values of Get Stuck In, Do the Right Thing, and One Team, One Dream. Read about us in Forbes.

Fivetran brings together high-quality talent across the globe to make data access as easy and reliable as electricity for our customers. We value and recognize that our customers benefit from innovative teams made of people from many backgrounds, experiences, and identities. Fivetran promotes diversity, equity, inclusion & belonging through attracting, recruiting, developing, and retaining a diverse workforce, not only because it is the right thing to do, but because it helps us build a world-class company to better serve our customers, our people and our communities.

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 don't hesitate to 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. We look forward to hearing from you and accommodating your needs to the best of our ability.