Hybrid Data Platform Engineer: Scalable Analytics & AI

Collective; San Francisco (CA); Hybrid; USD 160,000 - 210,000; Full time

Benefits offered by this job

Hybrid Work Model

Fresh Lunch

Transit reimbursement

Wellness reimbursement

Flexible PTO

Medical/dental/vision coverage

Parental leave

401k + equity

Annual in-person summit

Job summary

Collective is seeking a Data Engineer to own and scale the data platform powering analytics, reporting, and AI. You will design and maintain pipelines moving data from product, financial, and third-party systems into a BigQuery warehouse, and model it into clean, well-documented tables.

You will join the Data Engineering team and work with product engineers, analysts, and business stakeholders. This is a hands-on role focused on data quality, production ownership, and scalable foundations for

Qualifications

• 5+ years in data/analytics engineering or similar, preferably in B2B SaaS or fintech.
• Expert SQL and strong Python for building production pipelines.
• Hands-on with BigQuery, dbt, Fivetran, and an orchestrator (Airflow/Dagster/Cloud Composer).
• Deep data modeling in layered warehouse architecture with clear grain and naming.
• Data quality, monitoring, alerting, and on-call in production.
• Git-based workflows, CI/CD, and infrastructure-as-code; data infra as software.
• Able to communicate trade-offs to non-technical stakeholders and drive alignment.

Responsibilities

• Design, build, and maintain scalable data pipelines from apps, SaaS tools, and APIs into BigQuery.
• Model data with dimensional design and layered architecture, ensuring clear documentation.
• Own data quality, establish SLAs, and triage data incidents to root cause.
• Tune performance and cost, including partitioning and clustering of warehouse data.
• Set engineering standards for version control, code review, CI/CD, and IaC.
• Govern and secure data with access controls and PII handling.
• Collaborate with product, analysts, and stakeholders to enable self-serve reporting in Metabase.
• Support AI and analytics use cases with a reliable semantic layer and metric definitions.

Skills

SQL

Python

BigQuery

dbt

Airflow

Data modeling

Data quality

Communication

Ownership

Git / CI-CD

Tools

BigQuery

Fivetran

dbt

Airflow

Dagster

Cloud Composer

Terraform

Datadog

Metabase

Job description

Collective is seeking a Data Engineer to own and scale the data platform powering analytics, reporting, and AI. You will design and maintain pipelines moving data from product, financial, and third-party systems into a BigQuery warehouse, and model it into clean, well-documented tables.

You will join the Data Engineering team and work with product engineers, analysts, and business stakeholders. This is a hands-on role focused on data quality, production ownership, and scalable foundations for