Senior Data Engineer — Build Trusted Data Pipelines

Foresight Works; San Francisco (CA); On-site; USD 180,000 - 240,000; Full time

Benefits offered by this job

Health insurance

401(k)

Paid time off

Job summary

Foresight is seeking a Senior Data Engineer in the United States to build the data foundation behind our AI-driven infrastructure platform. You will design and operate production data pipelines, ensuring clean, trusted data that powers predictions, analytics, and customer reporting.

This hands-on role emphasizes data quality, observability, and governance, handling ingestion from industry tools, preserving history, and enabling scalable analytics for customers and internal teams.

Qualifications

• 5+ years of experience building and running production data pipelines with ownership from source to consumer.
• Strong Python and advanced SQL skills, including complex queries.
• Deep data modeling experience in Postgres or similar relational databases: schema design, indexing, partitions, migrations.

Responsibilities

• Own pipelines from design through production with data contracts, freshness and quality targets.
• Collaborate with ML engineers on features and datasets; work with frontend/backend teams on data behind product features.
• Design for failure with retriable, idempotent pipelines and safe recovery from bad inputs.

Skills

Python

Advanced SQL

Data modeling (Postgres)

Data pipelines

AWS data services

Testing for data

Communication

Tools

Airflow

pgvector

Job description

Foresight is seeking a Senior Data Engineer in the United States to build the data foundation behind our AI-driven infrastructure platform. You will design and operate production data pipelines, ensuring clean, trusted data that powers predictions, analytics, and customer reporting.

This hands-on role emphasizes data quality, observability, and governance, handling ingestion from industry tools, preserving history, and enabling scalable analytics for customers and internal teams.