DataFull-time

Analytics Engineer (dbt)

Kestrel Cover · Renters insurance you can buy in four minutes

About this job

Kestrel Cover sells renters insurance online to 210,000 policyholders. Our numbers have to stand up in front of regulators and reinsurers, so "the dashboard says something different" is a real problem, not a shrug.

You'll own the dbt project that sits between raw policy data and every report we publish. In the first 90 days you'll untangle the three definitions of "active policy" currently in use, add tests to the claims models, and rebuild the loss ratio dashboard that the board reviews each quarter. We use dbt, BigQuery and Looker.

The data team is four people across North America. We work from a written backlog, review models in pull requests, and hold one weekly sync. Most of your stakeholders are in finance and actuarial, and they prefer a clear doc to a meeting.

Highlights

  • 01Equity: 0.03–0.07%
  • 02401(k) with 5% match
  • 03Two company-wide quiet weeks a year

Tags

Related jobs

More in Data
  • Part-time

    Greenlot · Community solar subscriptions for renters and homeowners

    $55–65k (0.6 FTE)
    • SQL
    • Energy
  • BI Developer, Finance

    Larchmont Pay · Data

    Full-time

    Larchmont Pay · Payout infrastructure behind 4,000 online marketplaces

    $130–150k
    • BI
    • Finance
  • Full-time

    Shelfwise · Online storefronts and search for independent bookstores

    $170–200k
    • Machine learning
    • Search
Live demo · Timezone Fair— View template →