1 month ago
Base Salary
$165k - $185k/yr
Responsibilities
- Design, build, and own canonical data models for Shepherd’s core business entities and processes.
- Translate insurance and operational knowledge into facts, dimensions, grains, relationships, and business rules with domain experts.
- Define shared analytical foundations while preserving legitimate domain-specific variants.
- Establish testing, reconciliation, documentation, lineage, ownership, and development practices for trustworthy models.
- Evaluate existing models, reports, and actuarial datasets and lead consumers through migrations.
- Shape semantic context for people and AI-assisted tools and maintain model coherence as source systems and platform architecture evolve.
- Collaborate with the Data Lead and platform engineers on analytical model and platform evolution.
Requirements
- Strong SQL skills and hands-on experience developing production data models with dbt.
- Deep experience with dimensional modeling, including model grain, facts, dimensions, historical state, and entity relationships.
- Experience owning important analytical models through validation, documentation, maintenance, and consumer adoption.
- Ability to learn unfamiliar domains from subject-matter experts and turn incomplete or conflicting requirements into durable technical designs.
- Ability to lead cross-functional migrations and earn adoption.
- Sound engineering judgment and a preference for tested, understandable, reusable models over one-off outputs.
- Comfort operating with ambiguity and taking ownership of undefined problems.
- Preferred: experience in insurance, financial services, or other domains where definitions, historical state, and data quality have significant business consequences.
- Preferred: familiarity with semantic layers, data catalogs, metric definitions, or AI-assisted analytics.
- Preferred: experience establishing analytics-engineering practices in a growing or early-stage data organization.
- Preferred: familiarity with Python, Dagster, data ingestion pipelines, and modern software-engineering practices.
Benefits
- 100% employer contribution to health, dental, and vision coverage.
- Fertility benefits and family-building support.
- Unlimited PTO.
- Daily lunches, dinners, and snacks.
- Offices in San Francisco, New York City, Dallas-Fort Worth, Chicago, and Los Angeles.
- Professional development access, including premium coaching and leadership development.
- Competitive 401(k) plan.
- Dog-friendly San Francisco office.
About Shepherd
Shepherd is a technology-driven managing general underwriter that provides casualty insurance and risk management tools for commercial construction and other high‑hazard industries. It sells through brokers and pairs underwriting with software to help contractors manage safety and claims. Founded in 2021 and headquartered in San Francisco, Shepherd is privately held and partners with carriers including Intact; it announced a Series B round in 2026 led by Intact Private Capital.