Onsite
About Collective:
Collective is on a mission to redefine the way businesses-of-one work. Our technology and team of trusted advisors help members achieve financial independence by taking care of everything from business incorporation to accounting, bookkeeping, tax services, and access to a thriving community, all in one integrated platform. We believe in empowering self-employed people to enjoy the same tax savings that big companies get, so they can focus on their passion, not paperwork.
Featured in Forbes, Business Insider, Yahoo, Bloomberg, Financial Times, TechCrunch, and more. We are backed by General Catalyst, Sound Ventures (Ashton Kutcher and Guy Oseary), QED Investors, Google’s Gradient Ventures, Expa, and other investors who have financed iconic companies like YouTube, Substack, Twitch, Box, Hims, Instacart, and Lyft.
About the role:
Most teams have the data they need but can’t access it. This role is here to fix that.
We're hiring a senior engineer to build an internal data agent: a system that lets anyone at the company act as their own data analyst. Individuals can ask questions in plain English and get back correct, decision-ready answers or dashboards.
This is not a traditional data role. You'll operate across AI systems, data infrastructure, and product engineering. You'll be responsible both for building a powerful system and for ensuring the data it relies on is clean, consistent, and reliable.
The problem space is wide open. We’re looking for a strategic operator to shape the technical direction, the data model, and system adoption.
What you'll do:
Develop agent infrastructure
Build retrieval, planning, and execution systems on top of real data
Support multi-step reasoning and analysis workflows
Integrate into internal tools
Build an end-to-end analytics system
Create a natural language interface over our entire data stack
Enable anyone to run complex analyses without writing SQL
Own and improve the data layer
Collaborate with product engineering to design and evolve clean, consistent data models
Identify inconsistencies in the core schema and resolve them at the source
Build and maintain data pipelines
Own the reliability of our data infrastructure end-to-end
Debug and fix broken systems (e.g. dbt models, pipeline failures)
Make it easy to integrate new data sources into the data warehouse
Make it trustworthy
Ensure outputs are correct, consistent, and explainable
Build evaluation loops, monitoring, and guardrails
Eliminate ambiguity in metrics, definitions, and sources of truth
Handle permissions, sensitive data, and edge cases
Drive adoption
Work directly with teams across EPD, Member Operations, Legal, and more
Drive alignment on data definitions and system usage
Turn this into the default way people interact with data
What you'll bring:
You are a product engineer working in data
You treat data models as part of the product, not a separate layer
You have strong opinions on schema design, naming, and consistency
You're comfortable identifying issues in production data and fixing them at the root
You are an owner, not a participant
You take vague, high-stakes problems and turn them into real systems
You care about outcomes, not just implementation
You have strong data experience
Experience with data modeling, warehouses, and pipelines
You're an exceptional builder
You can go from idea → architecture → production
You've built with LLMs, RAG, or agents in production
You've shipped systems that people actually rely on
You have influence
You communicate effectively with both technical and non-technical stakeholders
You can drive alignment across teams with competing priorities
You're comfortable challenging existing systems and pushing for better approaches
What we offer:
Hybrid Work Model: Based in San Francisco with a balance of in-office and remote flexibility.
Fresh Lunch: Provided on in-office days.
Commuter Support: $150 monthly reimbursement for transit expenses.
Health & Wellness: $200 quarterly reimbursement to support your well-being.
Time Off: Flexible PTO plus 14 company holidays.
Comprehensive Coverage: 100% medical, dental, and vision for employees; 75% coverage for dependents.
Parental Leave: 16 weeks fully paid.
Retirement & Ownership: 401k plan plus an equity package.
Team Connection: Quarterly virtual events and an annual in-person summit.
Want to know if this job is worth applying to?
