Analytics Engineer

📋 Description

• Design, build, and own canonical data models for Shepherd’s core business entities and processes.
• Partner with domain experts to translate insurance and operational knowledge into explicit facts
• Identify what should be shared across Actuarial, reporting, and other consumers while preserving
• Establish the testing, reconciliation, documentation, lineage, ownership, and development practices
• Evaluate existing models, reports, and actuarial datasets, then lead consumers through migration to
• Shape the semantic context that helps people and AI-assisted tools use Shepherd’s data correctly

🎯 Requirements

• Strong SQL skills and hands-on experience developing production data models with dbt.
• Deep experience with dimensional modeling, including defining model grain, facts, dimensions
• You have owned important analytical models beyond their initial implementation, including
• You are comfortable learning an unfamiliar domain directly from subject-matter experts and
• You can lead cross-functional migrations and earn adoption rather than treating model deployment as
• You bring sound engineering judgment to analytical systems and value tested, understandable

🎁 Benefits

• Premium Healthcare - 100% contribution to top-tier health, dental, and vision
• Fertility benefits and family building support
• Unlimited PTO
• Daily lunches, dinners, and snacks
• SF, NYC, Dallas-Fort Worth, Chicago and LA Offices
• Professional Development - Access to premium coaching, including leadership development