Latest AI JobsBrowse Jobs
Collective logo

AI Data Engineer, Data Platform

CollectiveSan FranciscoEngineering
Apply on company site
Salary
$180K – $230K
Job type
Full-time
Work mode
Remote
Posted
24 Sept 2026
Status
Open · checked 7d ago

About this role

Financial Solutions & Resources for Self seeks an AI Data Engineer to oversee and scale the data platform supporting reporting, analytics, and artificial intelligence initiatives. This full-time position operates on a hybrid schedule out of San Francisco with remote flexibility, perfectly suited for an experienced professional with a strong background in building production-grade data systems.

Role Overview

The AI Data Engineer will design, build, and maintain robust data pipelines that transfer information from third-party systems, financial applications, and core product databases directly into the BigQuery warehouse. This role involves modeling information into reliable, well-documented tables while establishing essential engineering standards to ensure platform trustworthiness. Working within the engineering department, this team member collaborates closely with business stakeholders, analysts, and product engineers across Go-to-Market, Finance, and Operations teams.

Key Responsibilities

Create, launch, and support scalable batch and event-driven data pipelines utilizing custom Python loaders, managed connectors like Fivetran, and orchestration tooling to ingest data into BigQuery.
Design and implement analytical and dimensional data models within dbt, establishing a clear layered architecture that features explicit documentation, naming conventions, and grain.
Ensure high data reliability and quality by deploying pipeline testing, monitoring, alerting, data contracts, and managing incident triage to root causes.
Manage warehouse spend and query performance by tuning clustering, partitioning, and resource costs as data volumes expand.
Define best practices for infrastructure-as-code, code reviews, version control, and CI/CD while authoring comprehensive system runbooks.
Implement strict data retention rules, PII handling protocols, and access controls in partnership with legal and security teams.
Build semantic layers, metric definitions, and robust documentation that allow internal agents and LLM-based tools to query the warehouse reliably.
Partner with product engineers on change management and source schema design while helping stakeholders build self-serve reporting in Metabase.

Requirements

Minimum of 5 years of professional background working in data engineering, analytics engineering, or related functions, ideally within fintech or B2B SaaS organizations.
Expert-level SQL capabilities paired with strong Python programming skills for pipeline and tool creation.
Production-level familiarity with cloud data warehouses (BigQuery preferred), transformation tools like dbt, ingestion software like Fivetran, and workflow orchestrators such as Airflow.
Comprehensive understanding of dimensional modeling, warehouse architecture layers, and schema design principles.
Demonstrated background in operating data observability, lineage, alerting, and testing frameworks in production environments.
Fluency in engineering fundamentals including git workflows, CI/CD, code reviews, and infrastructure-as-code.

Nice to Have

Background working with streaming or event data technologies like Kafka or Pub/Sub alongside product analytics tools such as Amplitude.
Practical knowledge of Google Cloud Platform infrastructure and Terraform.
Experience utilizing observability solutions including Datadog.
Exposure to handling financial, payroll, tax, or accounting data correctness.
Prior work building semantic layers, metric stores, or supporting LLM evaluations and AI-assisted development tools like Claude Code.

Skills and Tools

Python
SQL
LLM
Kafka
Airflow
dbt
Terraform
BigQuery
Fivetran
Metabase

Salary and Benefits

Annual Salary Range: $180,000 to $230,000 USD
Hybrid Work Model with remote flexibility based out of San Francisco
Fresh catered lunches provided on in-office days
Monthly commuter transit reimbursement of $150
Quarterly wellness stipend of $200
Flexible Paid Time Off combined with 14 company holidays
Full medical, vision, and dental insurance coverage for employees at 100%, and 75% coverage for dependents
16 weeks of fully paid parental leave
401(k) retirement plan and an equity package
Regular team connections including quarterly virtual events and an annual in-person company summit

About the Company

Financial Solutions & Resources for Self delivers an integrated platform designed to help businesses-of-one achieve financial independence. The company provides a comprehensive suite of services that handles everything from business incorporation and bookkeeping to tax services, accounting, and community access. Featured across major publications like Forbes, Bloomberg, TechCrunch, and the Financial Times, the organization is backed by prominent investors and venture funds.

How to Apply

Interested candidates should submit their application directly through the official company careers page on the Collective website.

Skills and tech stack

PythonLLMSQLKafkaAirflow

Questions candidates ask

What is the salary range for the AI Data Engineer position?

The annual salary for this role ranges from $180,000 to $230,000 USD.

Is this position remote or located in an office?

This role features a hybrid work model based in San Francisco, offering a balance of in-office presence and remote flexibility.

How many years of experience are required?

Applicants must have 5+ years of professional experience in data engineering, analytics engineering, or a closely related field.

What technical skills are primarily needed for this role?

Key technical requirements include expert-level SQL, strong Python abilities, experience with cloud data warehouses like BigQuery, dbt, orchestration tools like Airflow, and managed ingestion tools.

How should I apply for this job?

You should apply directly on the official company careers page of the Collective website.

Ready to apply?

The application is on the official Collective careers page.

Apply on company site