Snowflake Data Architect

Design end-to-end ceded reinsurance data models across the lifecycle:

Treaty & facultative placements, layers, limits, participations

Premium cessions, commissions, reinstatements

Claims, accruals, recoveries, cash calls, settlements

Define Gross, Ceded, and Net data views with consistent grain across:

Underwriting year, accident year, accounting and reporting periods

Architect data structures supporting actuarial triangles (paid, incurred, ultimates) and ultimate recoveries analysis

Enable accruals, credit control, and recoveries analytics, including counterparty exposure, overdue balances, and leakage tracking

Drive ceded reinsurance data products for actuarial, finance, management, and regulatory reporting

Design data models and reporting layers to support QMA and statutory returns, ensuring auditability, lineage, and consistency

Establish data quality, reconciliation, and governance frameworks for ceded reinsurance domains

Act as a trusted advisor to Reinsurance, Finance, Actuarial, Claims, and Analytics stakeholders