The Senior Data Architect Ceded Reinsurance will lead the design and delivery of enterprise grade ceded reinsurance data products and data models enabling actuarial analytics recoveries accruals credit control and regulatory reporting including QMA returns
The role requires deep gross ceded net data expertise strong reinsurance domain knowledge and hands on experience building scalable analytics ready data platforms
Key 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
Required Skills Experience
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