Teams at Shepherd

Build and own Shepherd’s canonical analytical layer using dimensional modeling and dbt. Partner with actuarial, reporting, operations, engineering, and other data consumers to define trusted business entities, facts, dimensions, relationships, and rules. Establish testing, reconciliation, documentation, lineage, and adoption practices; evaluate and migrate existing models and datasets; and shape semantic context for human and AI-assisted analytics.

Lead Inland Marine technical underwriting, including referral decisions, account reviews, guidelines, authority governance, audits, coverage forms, training, and capacity partner support. Partner with Claims, Actuarial, Data, Product, Engineering, and Compliance to improve underwriting practices, embed requirements into platform workflows, and manage complex Builders Risk and commercial construction risks.

Analyze commercial P&C insurance rates, filings, competitors, loss ratios, portfolios, and regulatory requirements. Build rating plans, support rate and form filings, respond to regulatory objections, and monitor product performance. Use SQL and PostgreSQL for data analysis, Metabase for dashboards, and dbt for data transformation. Collaborate with actuarial, underwriting, compliance, product, and engineering teams to translate insights into pricing and product decisions.