Snowflake Data Architect

Snowflake Data Architect

Ceded Reinsurance Domain (Mandatory) • Strong hands-on experience with: o Treaty types (QS, Surplus, XoL, Stop Loss) and Facultative reinsurance o Recoveries, accruals, cash calls, commutations, and credit control o Gross / Ceded / Net actuarial and financial views • Experience supporting triangles, ultimates, and regulatory (QMA) reporting Data Architecture & Technology • Expert in conceptual, logical, and physical data modeling • Strong experience with cloud data platforms (Snowflake, Databricks, Azure/AWS) • Proven use of: o Fivetran for scalable ingestion of reinsurance, finance, and bordereaux data o Apache Kafka for event-driven and near real-time claims, recoveries, and financial feeds • Advanced SQL and working knowledge of Python • Experience supporting analytics and BI consumption (Power BI / Tableau). Personal Attributes • Strong analytical mindset with attention to financial and contractual detail • Ability to bridge actuarial, finance, and data engineering teams • Executive-level communication and stakeholder management skills • Comfortable operating in complex, global reinsurance environments. • Design end-to-end ceded reinsurance data models across the lifecycle: o Treaty & facultative placements, layers, limits, participations o Premium cessions, commissions, reinstatements o Claims, accruals, recoveries, cash calls, settlements • Define Gross, Ceded, and Net data views with consistent grain across: o 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.