Analytics Engineer
Core
Build and own Shepherd's canonical analytical layer, establishing shared entities, facts, dimensions, and business rules to serve actuarial, reporting, product workflows, and AI-assisted tools.
Role type
Senior IC analytics engineer (data modeling & platform ownership)
Builds
Canonical data models, shared analytical foundations, and trusted data representations for the commercial risk platform (via careerplan.io/jobs/2ee4ffbf-a5fd-4f6b-99bd-a06eb0efc4ce-analytics-engineer-at-shepherd)
Domain
Insurance (Commercial Property & Casualty) + Data Engineering
Deliverable
production ML models
Required skills
SQL, dbt, dimensional modeling, data model ownership, cross-functional collaboration, domain translation, engineering judgment, ambiguity management
Preferred skills
Insurance/financial services domain knowledge, semantic layers, data catalogs, Python, Dagster, CI/CD practices
Technologies
dbt, SQL, Python, Dagster
Responsibilities
Design and build canonical data models for core business entities; Partner with domain experts to translate insurance knowledge into explicit facts and dimensions; Establish testing, reconciliation, documentation, and lineage practices for analytical models; Lead cross-functional migrations to reliable shared foundations; Shape semantic context for human and AI-assisted tool usage; Collaborate with platform engineers to maintain model coherence as architecture evolves
Seniority
Senior, hands-on IC