Back to jobs

Senior Data Engineer (Remote)

San Francisco Office · San Francisco, California, United States

Live, first seen by us 68 days ago
Pay
Pay not listedSimilar roles state $127K–$189K
Work setting
Remote — work setting source
Location type: Remote
From the employer’s posting
Employment
Full-time — employment source
Employment type: Full-time
From the employer’s posting
Team
Data Analytics — team source
Department: Data Analytics
From the employer’s posting

What you’ll work on

Full posting

As our first dedicated Data Engineer, you will build and own the data foundation that powers analytics, reporting, and decision-making across the organization.

You won't be starting from zero or working alone.

  • Design and build a conformed, Kimball-style dimensional model across operational, behavioral, and transactional data

  • Own ingestion and pipelines end to end, including capturing change over time from sources without native history

  • Consolidate scattered transformation logic into a single governed, tested layer

  • Build identity resolution linking the same entity across systems

  • Encode business metric definitions once so reporting stops drifting across teams

From the employer’s posting
As our first dedicated Data Engineer, you will build and own the data foundation that powers analytics, reporting, and decision-making across the organization. This is a hands-on role where you'll design the dimensional model, own the pipelines that feed it, and establish the standards our data practice is built on.
You won't be starting from zero or working alone. You'll join a data team with direct analytics experience, and partner closely with engineering and other technical teams who have built and run what we have today. There's real institutional knowledge here to draw on. What's been missing is someone whose focus is turning it into a single, well-modeled foundation the whole company can rely on.
Design and build a conformed, Kimball-style dimensional model across our operational, behavioral, and transactional data
Own ingestion end to end, including capturing change over time from sources that don't preserve history natively
Consolidate transformation logic that currently lives in more than one place into a single governed, tested layer
building the spine that reliably connects the same entity as it appears across systems that each have their own identifiers and lifecycles
Encode business metric definitions once, so that reporting stops drifting across teams
Apply at Zencastr

Posting record

Report an error
Status in our records
Live
First seen by us
Sep 14, 202668 days ago
Recorded sightings
49
Last seen by us
Nov 21, 2026
Employer says posted
Sep 11, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

$127K–$189K is typical

The middle half of what similar US postings state. This one doesn’t list pay.

From 2,448 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 68

Up longer than most. Similar jobs usually come down between day 6 and day 56.

From 14,771 similar postings that came down. Coming down is not always a hire.

Zencastr is hiring

2 open jobs

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • BigQuery
  • dbt
  • MongoDB
  • Prefect
  • Redshift
  • Snowflake
  • Spark
  • Airflow
  • Dagster
Where the posting names them
- Have 5+ years of experience specifically in data engineering, analytics engineering, or a closely related role, including having built and owned a dimensional model in production - Have strong proficiency in SQL, with experience across document-based operational databases (e.g., MongoDB) and analytical data warehouses (e.g., BigQuery, Snowflake, Redshift, or similar) - Have experience building fact and dimension tables using star schema principles to support reporting and data marts, with a clear point of view on grain, conformed dimensions, and slowly-changing dimensions
- Have experience building fact and dimension tables using star schema principles to support reporting and data marts, with a clear point of view on grain, conformed dimensions, and slowly-changing dimensions - Have hands-on experience with modern transformation and modeling frameworks (e.g., dbt, Dataform, or similar), including managing transformation layers within a warehouse environment with version control, testing, and CI - Have built and maintained reliable ETL/ELT pipelines that transform raw application data into structured, analytics-ready datasets
- Have built and maintained reliable ETL/ELT pipelines that transform raw application data into structured, analytics-ready datasets - Have worked with orchestration tooling (e.g., Airflow, Dagster, Prefect, or similar) and think in terms of dependencies, retries, and backfills - Have experience with data ingestion or event streaming platforms (e.g., RudderStack, Segment, Pub/Sub, or similar) and ensuring consistent, reliable upstream data flows, including identity stitching across web and mobile
- Subscription billing data — proration, refunds, failed payments, trials - Experience with distributed processing frameworks (e.g., Spark, Beam, Dataflow) - Experience as a first or early data hire

Your next step

Complete your application on jobs.ashbyhq.com. The employer’s form will show what is required.

Applying through Ashby

  • No account needed. “Autofill from resume” at the top of the form fills the key fields from your file.

Already applied? Track this application

Job description

View original posting ↗

About the Role

As our first dedicated Data Engineer, you will build and own the data foundation that powers analytics, reporting, and decision-making across the organization. This is a hands-on role where you'll design the dimensional model, own the pipelines that feed it, and establish the standards our data practice is built on.

You won't be starting from zero or working alone. You'll join a data team with direct analytics experience, and partner closely with engineering and other technical teams who have built and run what we have today. There's real institutional knowledge here to draw on. What's been missing is someone whose focus is turning it into a single, well-modeled foundation the whole company can rely on.

You will work cross-functionally to understand how data is generated and used, and translate those needs into scalable models and structured reporting layers. A central part of the work is identity resolution: building the spine that reliably connects the same entity as it appears across systems that each have their own identifiers and lifecycles.

This role is ideal for someone who enjoys owning data systems end to end — from ingestion and transformation through modeling, governance, and performance — and who wants the autonomy to design a warehouse properly, with colleagues who can help you understand the business behind the data.

What You’ll Do

  • Design and build a conformed, Kimball-style dimensional model across our operational, behavioral, and transactional data

  • Own ingestion end to end, including capturing change over time from sources that don't preserve history natively

  • Consolidate transformation logic that currently lives in more than one place into a single governed, tested layer

  • Implement and manage our data warehouse and transformation layer, taking ownership of the pipelines that move data from our operational systems into it

  • Establish foundational best practices for data modeling, documentation, testing, and governance

  • Improve data reliability, quality, and accessibility across systems

  • Collaborate with analysts and business stakeholders to support evolving data needs

  • Encode business metric definitions once, so that reporting stops drifting across teams

  • Monitor and optimize performance and cost efficiency across pipelines, storage, and warehouse queries

You're a Good Fit If You

  • Have 5+ years of experience specifically in data engineering, analytics engineering, or a closely related role, including having built and owned a dimensional model in production

  • Have strong proficiency in SQL, with experience across document-based operational databases (e.g., MongoDB) and analytical data warehouses (e.g., BigQuery, Snowflake, Redshift, or similar)

  • Have experience building fact and dimension tables using star schema principles to support reporting and data marts, with a clear point of view on grain, conformed dimensions, and slowly-changing dimensions

  • Have hands-on experience with modern transformation and modeling frameworks (e.g., dbt, Dataform, or similar), including managing transformation layers within a warehouse environment with version control, testing, and CI

  • Have built and maintained reliable ETL/ELT pipelines that transform raw application data into structured, analytics-ready datasets

  • Have worked with orchestration tooling (e.g., Airflow, Dagster, Prefect, or similar) and think in terms of dependencies, retries, and backfills

  • Have experience with data ingestion or event streaming platforms (e.g., RudderStack, Segment, Pub/Sub, or similar) and ensuring consistent, reliable upstream data flows, including identity stitching across web and mobile

  • Have a solid understanding of data modeling best practices, including schema design, dimensional modeling, and performance considerations

  • Have a track record of inheriting and operating systems you didn't build

  • Have a strong focus on data quality, validation, and governance, with the ability to identify and resolve inconsistencies

  • Have an understanding of performance optimization across pipelines, storage, and warehouse queries

  • Can explain technical tradeoffs clearly to non-engineers

  • Are comfortable operating in a growing environment where you both execute technically and help shape our data architecture standards

Nice to have

  • Change data capture patterns from operational databases

  • Subscription billing data — proration, refunds, failed payments, trials

  • Experience with distributed processing frameworks (e.g., Spark, Beam, Dataflow)

  • Experience as a first or early data hire

Key Responsibilities

  • Design, build, and maintain reliable data pipelines that transform operational data into structured, analytics-ready datasets

  • Design and maintain the dimensional model — dimensions, facts, and bridge tables with clearly defined grain

  • Develop and maintain scalable data models and data marts to support reporting and business analysis

  • Manage and optimize data ingestion and event workflows to ensure consistent, high-quality upstream data flows

  • Implement and manage transformation processes that structure raw data for analytics use

  • Implement orchestration, testing, freshness monitoring, and alerting so that data issues are caught before stakeholders encounter them

  • Build and maintain change capture or snapshotting to support historical reporting and slowly-changing dimensions

  • Improve data freshness — moving our core operational data from batch refreshes toward near-real-time availability, and establishing freshness SLAs stakeholders can rely on

  • Ensure strong standards for data quality, validation, and consistency across systems

  • Document models and definitions so analysts and stakeholders can self-serve with confidence

  • Monitor and optimize performance, reliability, and cost efficiency within the analytics environment

  • Partner cross-functionally to translate business requirements into scalable data solutions

  • Proactively improve our data systems so they remain structured, consistent, and scalable as the organization grows

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 845, the most 1,344, and the latest week had 1,007.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

San Francisco, California, United States

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.