Skip to main content

Collective

AI Data Engineer, Data Platform

San Francisco (Remote)$180k–$230kfulltimemidAdded today

About this role

Collective is seeking an experienced AI Data Engineer to design, build, and scale the data platform powering analytics and AI across their business-of-one platform. You'll own end-to-end data pipelines, data modeling, quality assurance, and work closely with product, analytics, and business teams to establish engineering standards for a growing fintech company.

What you'll do

  • Design and build scalable batch and event-driven data pipelines ingesting from databases, SaaS tools, and APIs into BigQuery
  • Model data using dbt with dimensional design patterns, layered architecture, and comprehensive documentation
  • Implement data quality testing, monitoring, alerting, and data contracts; triage pipeline failures and incidents
  • Optimize warehouse performance, query tuning, partitioning, clustering, and manage BigQuery costs
  • Establish and drive data engineering best practices around version control, code review, CI/CD, and infrastructure-as-code
  • Enable analytics and AI use cases by maintaining semantic layers, metric definitions, and self-serve reporting capabilities

What they're looking for

  • SQL and Python (expert-level SQL, strong Python for production pipelines)
  • BigQuery and cloud data warehouse architecture
  • dbt or equivalent data transformation frameworks
  • Data pipeline orchestration (Airflow, Dagster, Cloud Composer)
  • Dimensional modeling and schema design
  • Data quality frameworks, testing, monitoring, and observability
  • Git workflows, CI/CD, and infrastructure-as-code principles
  • Financial or fintech data domain knowledge

Benefits

  • Hybrid work model based in San Francisco with remote flexibility
  • 100% medical, dental, and vision coverage for employees; 75% for dependents
  • Flexible PTO plus 14 company holidays
  • 16 weeks fully paid parental leave
  • 401k plan with equity package
  • $150 monthly commuter support and $200 quarterly wellness reimbursement
Apply with Autofill

Opens the application — the Jobs AI extension fills it for you. Set up autofill

Opens the official application on the employer’s site. No login required.

Collective

Collective builds an accounting platform designed to serve self-employed individuals and small businesses, with features including banking integrations, transaction pipelines, and reconciliation systems. The company is hiring fullstack and junior software engineers to develop and scale their financial products platform.

View all jobs at Collective

Likely interview questions

  • Walk us through a complex data pipeline you built end-to-end: what were the data sources, transformation logic, and how did you ensure data quality?
  • Describe your experience with dbt and dimensional modeling—how do you approach designing a layered architecture for a new domain or dataset?
Unlock all 7 questions free — and practice them live →