Snowflake Data Architect

Educational Requirements Service Line Responsibilities

• Design end-to-end ceded reinsurance data models across the lifecycle: Treaty facultative placements, layers, limits, participation
• 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.

Additional Responsibilities

• Ceded Reinsurance Domain (Mandatory)
• Strong hands-on experience with:
• Treaty types (QS, Surplus, XoL, Stop Loss) and Facultative reinsurance
• Recoveries, accruals, cash calls, commutations, and credit control
• 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:
• Fivetran for scalable ingestion of reinsurance, finance, and bordereaux data
• 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.

Preferred Skills

• Technology->Architecture->Architecture - ALL
• Technology->Data on Cloud-DataStore->Snowflake