Analytics Engineer

The role

You will build and own Shepherd's canonical analytical layer by designing and implementing data models. You will work with domain experts to translate business knowledge into shared facts, dimensions, and business rules.

What you will do

• Design, build, and own canonical data models for core business entities and processes.
• Partner with domain experts to translate insurance and operational knowledge into facts, dimensions, and business rules.
• Identify what should be shared across Actuarial, reporting, and other consumers.
• Establish testing, reconciliation, documentation, lineage, ownership, and development practices.
• Evaluate existing models, reports, and actuarial datasets and lead migrations.
• Shape the semantic context for people and AI-assisted tools.
• Collaborate with the Data Lead and platform engineers to keep models coherent.

Required qualifications

• Strong SQL skills and hands-on experience developing production data models with dbt.
• Deep experience with dimensional modeling, including defining model grain, facts, dimensions, historical state, and relationships.
• Experience owning important analytical models including validation, documentation, maintenance, and consumer adoption.
• Comfortable learning an unfamiliar domain from subject-matter experts and translating requirements into technical designs.
• Ability to lead cross-functional migrations and earn adoption.
• Sound engineering judgment for analytical systems.
• Comfortable operating with ambiguity and taking ownership of unsolved problems.

Nice to have

• Experience in insurance, financial services, or another domain where definitions and data quality have material business consequences.
• Familiarity with semantic layers, data catalogs, metric definitions, or AI-assisted analytics.
• Experience establishing analytics-engineering practices in a growing or early-stage data organization.
• Familiarity with Python, Dagster, data ingestion pipelines, and modern software-engineering and CI/CD practices.

Benefits

• Premium Healthcare
• 100% contribution to health, dental, and vision
• Fertility benefits and family building support
• Flexible PTO
• Daily lunches, dinners, and snacks
• Professional Development
• Access to premium coaching, including leadership development
• Competitive 401(k) Plan
• Dog-friendly office

About the company

Shepherd rebuilds commercial insurance with software, data, AI, and deep underwriting expertise. The company develops insurance products and partners with established insurers to back coverage.