Staff Software Engineer - Prism in Oakland, California at Fivetran
Explore Related Opportunities
Job Description
Position Title: Staff Software Engineer - Prism
From Fivetrans 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. Were 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, were 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, were building on the strengths of both companies while continuing to deliver the products and experiences our customers know and trust. Its an exciting time to join us: were 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
We are building the next foundational layer of the analytics stack: an Enterprise Context Platform that captures, stores, and exposes organizational decision memory.
As a seasoned engineer on Context Platform Systems, you will architect and build the durable memory substrate that powers agentic analytics workflows. This platform stores not just metadata, but meaning: decisions, intent, rationale, and history and makes it safely accessible to humans, agents, and applications.
This is a greenfield, high-leverage role with company-level impact.
What Youll Do
- Prototype apt technical solutions and find best fits for the context engine. Architect and build the core Context Platform
- Design schemas and primitives for Decision Memory and enterprise context
- Own context storage systems (graph, vector, event/time-based)
- Build read/write/query APIs used by agents, products, and external apps
- Design permission-aware, auditable context access
- Ensure the context engine is interoperable, portable, and zero-lock-in by design
- Partner closely with agentic systems engineers and product leadership
What Youll Own
- Context schemas and schema evolution strategies
- Storage and data modeling choices
- Platform APIs and interfaces
- Security, identity propagation, and audit foundations
- Long-term scalability and correctness of context data
What You Wont Own
- Agent behavior or orchestration logic
- Business rules or governance policy decisions
- Product UI or workflow automation
(Those are consumers of the platform you build.)
Skills We're Looking For
- Significant experience building distributed systems, data platforms, or infrastructure
- Comfort operating in ambiguous, greenfield problem spaces
- Deep expertise in data modeling and schema design
- Experience designing shared platforms used by many teams
- Strong instincts around APIs, contracts, and backward compatibility
- Ability to reason about systems, not just components
Bonus Skills (Optional)
- Experience with knowledge graphs, metadata systems, or search/retrieval systems
- Experience building systems with governance, auditability, or compliance requirements
- Familiarity with dbt or modern analytics stacks or developer tooling
Why This Role Matters
If this platform is built correctly:
- Agents become trustworthy
- Governance scales without slowing teams down
- We become the System of Decision for analytics
This role lays the foundation for the next S-curve of the company.
#LI-HYBRID
#LI-SA1
Perks and 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 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
Click here to learn more about Fivetran's Benefits by Region.
Were honored to be valued at over $5.6 billion, but more importantly, were 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 having 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.
To learn more about Fivetrans culture and what its like to be part of the team, click here and enjoy our video.
To learn more about our candidate privacy policy, you can read our statement here.
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.
Equal Opportunity Employer, including disability/protected veterans