Member of the Technical Staff - Data Engineer

The role

You will own the data warehouse, definitions, and query surfaces for underwriting, pricing, and leadership. You will migrate the existing analytics database, build a trust framework, and create a shared semantic layer.

What you will do

• Migrate the centralized analytics database to a new warehouse
• Implement dbt for models and an orchestrator for scheduling
• Build a trust framework and diagnostics console for data reconciliation
• Create a shared semantic layer of typed, versioned entities and metrics
• Develop an automated production to sanitized pipeline for prototyping
• Partner with Actuarial, Underwriting, and Applied Science teams
• Build a harness to help stakeholders solve problems themselves

Required qualifications

• Min of 12 years of experience in industry
• Proven experience migrating a live analytics store onto a warehouse in production
• dbt in production: incremental models, snapshots, tests, and operational habits
• Hands-on experience with a real orchestrator (Dagster, Airflow, Prefect)
• Track record of building data-quality or observability infrastructure
• Proficiency designing schemas and metric definitions for non-engineers
• Familiarity with authorization and access-control patterns for data
• Comfort and experience in product discovery

Nice to have

• Insurance data experience
• Geospatial data at scale
• Curating data for ML and evals
• Reverse ETL
• Early-stage experience where you were the first data hire

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

Before you apply

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

About the company

Stand builds a scalable risk engine called the Stand World Model using advanced physics and AI to model catastrophic risk. The leadership team has built category-defining companies including Metromile, Policygenius, WePay, and HotelTonight.