About the Role
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. This role owns the data warehouse, definitions, and query surfaces that underwriting, pricing, and leadership all resolve to. 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. This is a foundations role. Your success is measured by the questions other people answer without you.
Responsibilities
- Migrate the current analytics database in Postgres to a new warehouse solution.
- Implement dbt for data modeling.
- Utilize a real orchestrator for scheduling data pipelines.
- Establish per-dataset cadence and freshness SLAs.
- Implement snapshots on key entities.
- Build a trust framework and diagnostics console for data quality.
- Develop reconciliation tests between systems of record and the warehouse.
- Create a console for monitoring data freshness, reconciliation status, and affected dashboards.
- Build a shared semantic layer with a registry of typed, versioned, permission-aware entities and metrics.
- Develop an agentic query surface built on the semantic layer.
- Create an automated pipeline for producing a de-identified copy of the book for local, dev, and staging environments.
- Partner with Actuarial and Underwriting to understand data needs and build solutions.
- Partner with Applied Science to integrate data consumption and production.
Requirements
- Proven experience migrating a live analytics store onto a warehouse in production, including cutover and parity proof.
- Experience with dbt in production, including incremental models, snapshots, and tests.
- Hands-on experience with a real orchestrator (Dagster, Airflow, Prefect) including dependency graphs, backfills, and retries.
- Track record of building data-quality or observability infrastructure (reconciliation suites, freshness monitoring, lineage, alerting).
- Proficiency designing schemas and metric definitions for non-engineers.
- Familiarity with authorization and access-control patterns for data.
- Comfort and experience in product discovery, working directly with stakeholders.
- Candidates must be authorized to work in the U.S. Stand does not sponsor new work visas.
- Consideration for candidates on TN visas, O-1A visas, or H-1B transfers with three years or more remaining.
Skills
- dbt
- Dagster
- Airflow
- Prefect
- PostGIS
- H3
Location
- Remote
Work Type
- Full-time
Experience Level
- Early-stage experience where you were the first data hire
Salary/Compensations
- $240,000 to $295,000 + meaningful Equity Grant
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
About the Company
- 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. The real product is a scalable risk engine, our Stand World Model.
- We stay when traditional insurers exit. We model what others approximate. And we build systems that change outcomes, not just prices.
- Our leadership team includes former successful founders and CEOs from Metromile, PolicyGenius, WePay, and HotelTonight, bringing deep experience in building and scaling high-growth companies.
- 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.
Equal Opportunity
- 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.
- Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.
