I
Snowflake Data Architect
I
- Posted a month ago
- Be among the first 10 applicants
Job Description
Responsibilities :
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.Additional Responsibilities:
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.More Info
Job Type:
Industry:
Role:
Function:
Employment Type:

