Back to jobs

Member of the Technical Staff - Data Engineer

San Francisco, California, United States

Open 3 months, first seen by us 101 days ago
Pay
$240,000–295,000/year · Base — pay source
You'd rather design the ideal warehouse than migrate the working one, or you'd leave the old pipeline running indefinitely because removing it feels risky. The annual base salary range for full-time employees in this position is $240,000 to $295,000 + meaningful Equity Grant. Compensation decisions are dependent on several factors including, but not limited to, an individual’s qualifications, location where the role is to be performed, internal equity, and alignment with market data.
Read the full posting
Work setting
Hybrid — work setting source
Work setup in the employer’s posting: Hybrid
From the employer’s posting
Employment
Full-time — employment source
Employment type in the employer’s posting: FullTime
From the employer’s posting

What you’ll work on

Full posting

We are building the self-driving insurer: a national carrier whose standard operating procedure is explicit, instrumented, and handed to agents one proven step at a time — so the book grows without the org.

Every one of those decisions runs on data, and every one of them is only as good as the number underneath it.

  • Migrate the Postgres analytics store to a warehouse with dbt models and a parity check

  • Schedule datasets with per-dataset cadence, freshness SLAs and snapshots

  • Build reconciliation tests that run on every load and fail the run on mismatch

  • Build a diagnostics console showing data freshness, reconciliation and affected dashboards

  • Create a shared semantic layer of versioned metrics and entities with central permissions

From the employer’s posting
We are building the self-driving insurer: a national carrier whose standard operating procedure is explicit, instrumented, and handed to agents one proven step at a time — so the book grows without the org.
Every one of those decisions runs on data, and every one of them is only as good as the number underneath it. That's the precondition this role owns. Not a dashboard. The warehouse, the definitions, and the query surfaces that underwriting, pricing, and leadership all resolve to — and that our agents will read from long before they're trusted to write.
You migrate it: dbt for models, a real orchestrator for scheduling
per-dataset cadence and freshness SLAs, snapshots on the entities whose history matters
Reconciliation between each system of record and the warehouse — row counts, premium totals, status parity — running as tests on every load and failing the run
A console where anyone, not just you, can see whether a dataset is fresh, whether it reconciled
One registry of typed, versioned, permission-aware entities and metrics.

Before you apply

Work authorization
Must already have the right to work in the USCandidates must be authorized to work in the US Stand does not sponsor new work visas

Benefits in the posting

Full benefits wording
  • Above-market Health, Dental, and Vision coverage
  • Weekly lunch stipend
  • 401(k) plan
  • Commuter benefits
  • PAT & MAT Leave
  • Short-Term and Long-Term Disability
  • Monthly team gatherings
  • In-office perks
  • AI in the Interview Process
  • Work Authorization

From the employer’s posting.

Apply at Stand

Posting record

Report an error

Open 3 monthsWe first saw this posting 101 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.

Status in our records
Live
First seen by us
Aug 13, 2026101 days ago
Recorded sightings
56
Last seen by us
Nov 22, 2026
Employer says posted
Aug 10, 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

Higher than most similar jobs

$240K–$295K against $127K–$189K, the middle half of what similar US postings state.

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

Time since we first saw it

Day 101

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

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

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.

  • dbt
  • Prefect
  • Airflow
  • Dagster
  • PostgreSQL
Where the posting names them
Concretely, the platform is four things: A warehouse where every dataset moves at its own speed. Today we have a centralized analytics database in Postgres, rebuilt hourly in full. It works, and it's why you start on the second problem instead of the first. You migrate it: dbt for models, a real orchestrator for scheduling, per-dataset cadence and freshness SLAs, snapshots on the entities whose history matters. Bind state on minutes, vendor pulls and reference data daily. A trust framework and diagnostics console. Reconciliation between each system of record and the warehouse — row counts, premium totals, status parity — running as tests on every load and failing the run, not as a monthly spot check. A console where anyone, not just you, can see whether a dataset is fresh, whether it reconciled, and which dashboards are affected when it didn't. Turning a discrepancy someone noticed into a permanent test should take an afternoon.
What you'll ship - First 30 days: Warehouse chosen and justified in writing — cost at our volume, latency, how it reads from operational Postgres, who administers it. A dbt project that reproduces today's tables, with an automated parity check against the existing store that passes before anything changes. Orchestrator running the current schedule unchanged, now with a dependency graph and per-model run history. - First 3 months: A governance-first pipeline that empowers stakeholders to self-serve metric definitions and targets, independently promoting ideas to productionized, tested models. Launch of the diagnostics console, enabling non-engineers to monitor data health, freshness SLAs, and reconciliation status without engineering intervention.
- Proven experience migrating a live analytics store onto a warehouse in production — including the cutover and the parity proof, not a greenfield build. - dbt in production: incremental models, snapshots, tests, and the operational habits around them. - Hands-on experience with a real orchestrator (Dagster, Airflow, Prefect) — dependency graphs, backfills, retries, and being paged when a load fails.
- dbt in production: incremental models, snapshots, tests, and the operational habits around them. - Hands-on experience with a real orchestrator (Dagster, Airflow, Prefect) — dependency graphs, backfills, retries, and being paged when a load fails. - Track record of building data-quality or observability infrastructure: reconciliation suites, freshness monitoring, lineage, alerting people didn't turn off.

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 ↗

Why Join Stand: At Stand, you’ll help build a new class of global property protection. We use advanced physics and AI to model catastrophic risk at the asset level, then automate underwriting and mitigation before loss occurs. Insurance is simply the current delivery mechanism.

We stay when traditional insurers exit. We model what others approximate. And we build systems that change outcomes, not just prices.

Our leadership team has built category-defining companies (Metromile, Policygenius, WePay, HotelTonight) and brings decades of expertise in underwriting, capital management, and reinsurance.

Background: The property insurance industry is built to price loss after it happens. It relies on coarse proxies, backward-looking data, and manual processes, then accepts damage as unavoidable.

Stand takes a different approach. We simulate how real-world catastrophes affect individual properties, translate that into actionable decisions, and automate the business around it. The result is a platform that can underwrite what others can’t and operate with far less friction.

Role Summary

We are building the self-driving insurer: a national carrier whose standard operating procedure is explicit, instrumented, and handed to agents one proven step at a time — so the book grows without the org.

Every one of those decisions runs on data, and every one of them is only as good as the number underneath it. That's the precondition this role owns. Not a dashboard. The warehouse, the definitions, and the query surfaces that underwriting, pricing, and leadership all resolve to — and that our agents will read from long before they're trusted to write.

Concretely, the platform is four things:

A warehouse where every dataset moves at its own speed. Today we have a centralized analytics database in Postgres, rebuilt hourly in full. It works, and it's why you start on the second problem instead of the first. You migrate it: dbt for models, a real orchestrator for scheduling, per-dataset cadence and freshness SLAs, snapshots on the entities whose history matters. Bind state on minutes, vendor pulls and reference data daily.

A trust framework and diagnostics console. Reconciliation between each system of record and the warehouse — row counts, premium totals, status parity — running as tests on every load and failing the run, not as a monthly spot check. A console where anyone, not just you, can see whether a dataset is fresh, whether it reconciled, and which dashboards are affected when it didn't. Turning a discrepancy someone noticed into a permanent test should take an afternoon.

A shared semantic layer. One registry of typed, versioned, permission-aware entities and metrics. A metric means one thing, defined once, in version control. Deciding what a metric should mean isn't your call; making it easy for an actuary or underwriter to codify it once, so the next person doesn't redefine it in a dashboard, is your job. The agentic query surface is built on this layer and can't see past it: an agent answers in natural language, shows the query it ran, and reaches nothing its invoking user couldn't reach directly.

Data that's safe to be creative with. An automated production → sanitized pipeline producing a de-identified but faithful copy of the book — consistent synthetic identities, preserved distributions, intact joins, edge cases kept rather than smoothed away. It becomes the default seed for local, dev, and staging, and the default substrate for anyone prototyping against real-shaped data. Raw PII access becomes the exception with an audit trail.

You'll partner closely with Actuarial and Underwriting, who ask the questions, and with Applied Science, whose models both consume this data and produce more of it. Working to understand what insights are missing and build a pathway to get them the information they need. You start by understanding their problem, then you solve it, and then you build a harness that can help them solve problems themselves

This is a foundations role. Your success is measured by the questions other people answer without you: how fast an actuary can rate a cohort, how confidently an underwriter can trust a stage count, and how quickly an engineer can prototype against realistic data without filing a request.

What you'll ship

  • First 30 days: Warehouse chosen and justified in writing — cost at our volume, latency, how it reads from operational Postgres, who administers it. A dbt project that reproduces today's tables, with an automated parity check against the existing store that passes before anything changes. Orchestrator running the current schedule unchanged, now with a dependency graph and per-model run history.

  • First 3 months: A governance-first pipeline that empowers stakeholders to self-serve metric definitions and targets, independently promoting ideas to productionized, tested models. Launch of the diagnostics console, enabling non-engineers to monitor data health, freshness SLAs, and reconciliation status without engineering intervention.

  • First 6 months: A semantic layer that dashboards, analysts, and agents all resolve to, with permissions enforced centrally and covered by tests. A sanitized production mirror refreshing on schedule and seeding every non-production environment. Leadership pipeline, loss ratio, and premium reporting all coming from one source, produced without engineering in the loop.

Core competencies (Required)

  • Min of 12 years of experience in industry

  • Proven experience migrating a live analytics store onto a warehouse in production — including the cutover and the parity proof, not a greenfield build.

  • dbt in production: incremental models, snapshots, tests, and the operational habits around them.

  • Hands-on experience with a real orchestrator (Dagster, Airflow, Prefect) — dependency graphs, backfills, retries, and being paged when a load fails.

  • Track record of building data-quality or observability infrastructure: reconciliation suites, freshness monitoring, lineage, alerting people didn't turn off.

  • Proficiency designing schemas and metric definitions that non-engineers can actually use.

  • Familiarity with authorization and access-control patterns for data.

  • Comfort and experience in product discovery — working directly with the people who need the answer, not from a ticket.

Nice-to-have skills

  • Insurance data experience. Policy administration systems (Socotra, Guidewire, Duck Creek), written vs. earned premium, loss and premium triangles, reserving and development, statutory or bureau reporting, or having partnered closely with actuaries.

  • Geospatial data at scale — parcels, hazard layers, imagery, point clouds — with PostGIS, H3, or similar. Our unit of analysis is a specific building on a specific parcel.

  • Curating data for ML and evals — training sets, labeled decision logs, feature stores, and the discipline of keeping a holdout honest.

  • Reverse ETL — pushing modeled data back into the operational surfaces where people actually work.

  • Early-stage experience where you were the first data hire and had to choose what not to build.

You're not a fit if

  • You have less than 12 years of experience in industry

  • Your data experience is primarily building dashboards on top of models someone else owned.

  • You want a fully specified backlog. This role is defined by ambiguity for the first year.

  • You'd rather design the ideal warehouse than migrate the working one, or you'd leave the old pipeline running indefinitely because removing it feels risky.

The annual base salary range for full-time employees in this position is $240,000 to $295,000 + meaningful Equity Grant.

Compensation decisions are dependent on several factors including, but not limited to, an individual’s qualifications, location where the role is to be performed, internal equity, and alignment with market data.

Benefits:

  • Above-market Health, Dental, and Vision coverage

  • Weekly lunch stipend

  • Flexible time off + holidays

  • 401(k) plan

  • Commuter benefits

  • PAT & MAT Leave

  • Short-Term and Long-Term Disability

  • Monthly team gatherings

  • In-office perks

AI in the Interview Process

Thoughtful use of AI tools is expected and valued at Stand. Candidates should be prepared to discuss how they use AI, how they evaluate its output, and how it informs their work. Strong communication, sound judgment, and the ability to clearly articulate experience and decision-making remain core requirements.

Some parts of the interview process are designed to assess independent thinking, communication, and problem-solving. If you plan to use an AI assistant or LLM during any portion of an interview, please discuss it with your interviewer in advance.

Work Authorization

Candidates must be authorized to work in the U.S. Stand does not sponsor new work visas. We can consider candidates on TN visas, O-1A visas, or H-1B transfers with three years or more remaining.

Equal Opportunity Employment

Stand is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status. We believe that diversity enriches the workplace, and we are committed to growing our team with the most talented and passionate people from every community.

We are committed to providing reasonable accommodations for qualified individuals. If you require assistance, please contact us at hr@standinsurance.com.

Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.

AI Use in Hiring

We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us at hr@standinsurance.com.

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
You'd rather design the ideal warehouse than migrate the working one, or you'd leave the old pipeline running indefinitely because removing it feels risky. The annual base salary range for full-time employees in this position is $240,000 to $295,000 + meaningful Equity Grant. Compensation decisions are dependent on several factors including, but not limited to, an individual’s qualifications, location where the role is to be performed, internal equity, and alignment with market data.
Location & working pattern

San Francisco, California, United States

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

Work authorization
Some parts of the interview process are designed to assess independent thinking, communication, and problem-solving. If you plan to use an AI assistant or LLM during any portion of an interview, please discuss it with your interviewer in advance. Work Authorization Candidates must be authorized to work in the U.S. Stand does not sponsor new work visas. We can consider candidates on TN visas, O-1A visas, or H-1B transfers with three years or more remaining. Equal Opportunity Employment

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.