← Back
2024
Actuarial Staging ETL
Multi-step SQL ETL powering Reserving and Current Accident Year analytics
SQLPythonETLSnowflakeActuarial
Overview
Architected and maintain the end-to-end ETL pipeline that stages policy, premium, and claims data for the Actuarial team. Feeds Reserving analytics and the Current Accident Year (CAY) model across all Lines, Coverages, and transactions — the backbone that drives reserving decisions and regulatory state filings.
Key Outcomes
- →Powers Reserving and Current Accident Year analysis across every Line and Coverage
- →Replaced fragile manual processes with a versioned, scheduled pipeline
- →Supports state filing workflows with reproducible, auditable data lineage