Snowflake Data Architect

• 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.

• 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.

Education: MCA,Intergrated course BCA+MCA,Bachelor of Engineering

• Preferred skills: Technology->Architecture->Architecture
• ALL,Technology->Data on Cloud-Data Store->Snowflake