Member of the Technical Staff - Data Engineer
Stand Insurance3 months ago
Base Salary
$240k - $295k/yr
Responsibilities
- Migrate the existing centralized Postgres analytics database to a production warehouse with a documented architecture, dbt models, parity checks, and a controlled cutover.
- Build and operate orchestrated data pipelines with dependency graphs, per-model run history, backfills, retries, dataset-specific cadences, and freshness SLAs.
- Create data-quality and observability infrastructure covering reconciliation, freshness, lineage, alerting, and a diagnostics console for non-engineering stakeholders.
- Design and maintain a shared semantic layer with typed, versioned, permission-aware entities and metrics.
- Build an automated production-to-sanitized data pipeline that creates de-identified, faithful datasets for local, development, and staging environments.
- Partner with Actuarial, Underwriting, Applied Science, leadership, and other stakeholders to identify missing insights and make trusted data self-service.
Requirements
- At least 12 years of industry experience.
- Proven experience migrating a live analytics store to a production warehouse, including cutover and parity validation.
- Production experience with dbt, including incremental models, snapshots, tests, and operational practices.
- Hands-on experience with a production orchestrator such as Dagster, Airflow, or Prefect, including dependency graphs, backfills, retries, and failure response.
- A track record of building data-quality or observability infrastructure such as reconciliation suites, freshness monitoring, lineage, and alerting.
- Proficiency designing schemas and metric definitions that non-engineers can use.
- Familiarity with authorization and data access-control patterns.
- Experience with product discovery and direct collaboration with people who need data answers.
- Preferred experience with insurance data, policy administration systems, actuarial reporting, or actuarial partnerships.
- Preferred experience with geospatial data at scale and PostGIS, H3, or similar tools.
- Preferred experience curating ML datasets and evaluation data, including training sets, labeled decision logs, feature stores, and holdouts.
- Preferred reverse ETL and early-stage experience, including being a first data hire.
Benefits
- Annual base salary range of $240,000 to $295,000 plus a meaningful equity grant.
- Above-market health, dental, and vision coverage.
- Weekly lunch stipend, flexible time off, and holidays.
- 401(k) plan, commuter benefits, PAT and MAT leave, and short-term and long-term disability.
- Monthly team gatherings and in-office perks.
Tech Stack
Categories
Data Engineering
About Stand Insurance
Stand Insurance builds a homeowners insurer and property risk platform that simulates catastrophe impacts on individual homes to guide underwriting and mitigation. It sells homeowners insurance and operates a physics- and AI-based Stand World Model to automate pricing and risk decisions at the asset level. Founded in 2023 and headquartered in San Francisco, the privately held company focuses on properties exposed to climate and catastrophe risk.