AI Data Engineer (Agent Platform)
About CollectiveCollective 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 RoleMost 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 DoDevelop agent infrastructureBuild retrieval, planning, and execution systems on top of real dataSupport multi-step reasoning and analysis workflowsIntegrate into internal tools Build an end-to-end analytics systemCreate a natural language interface over our entire data stackEnable anyone to run complex analyses without writing SQLOwn and improve the data layerCollaborate with product engineering to design and evolve clean, consistent data modelsIdentify inconsistencies in the core schema and resolve them at the sourceBuild and maintain data pipelinesOwn the reliability of our data infrastructure end-to-endDebug and fix broken systems (e.g. dbt models, pipeline failures)Make it easy to integrate new data sources into the data warehouseMake it trustworthyEnsure outputs are correct, consistent, and explainableBuild evaluation loops, monitoring, and guardrailsEliminate ambiguity in metrics, definitions, and sources of truthHandle permissions, sensitive data, and edge casesDrive adoptionWork directly with teams across EPD, Member Operations, Legal, and moreDrive alignment on data definitions and system usageTurn this into the default way people interact with dataWhat You'll Bring You are a product engineer working in dataYou treat data models as part of the product, not a separate layerYou have strong opinions on schema design, naming, and consistencyYou're comfortable identifying issues in production data and fixing them at the rootYou are an owner, not a participantYou take vague, high-stakes problems and turn them into real systemsYou care about outcomes, not just implementationYou have strong data experienceExperience with data modeling, warehouses, and pipelinesYou're an exceptional builderYou can go from idea → architecture → productionYou've built with LLMs, RAG, or agents in productionYou've shipped systems that people actually rely onYou have influenceYou communicate effectively with both technical and non-technical stakeholdersYou can drive alignment across teams with competing prioritiesYou're comfortable challenging existing systems and pushing for better approachesWhat We OfferHybrid 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.