Actuarial Analyst: Prophet Modeling & Valuation

Chariot Reinsurance, Ltd.; Northern (KY); Hybrid; USD 85,000 - 120,000; Full time

Job summary

Chariot Reinsurance, Ltd. in the United States seeks an Actuarial Analyst to contribute to the valuation team by preparing model inputs, running Prophet, and delivering quarterly results across U.S. GAAP and Bermuda EBS.

The role emphasizes data validation, variance analysis, documentation, and collaboration with Finance, Risk and management. Experience with Prophet and actuarial reporting is preferred, with strong Excel skills and programming exposure.

Qualifications

• Bachelor's degree in actuarial science, mathematics or related field.
• Progress toward actuarial designation or equivalent qualification.
• Approximately 5–8 years actuarial experience in life insurance or reinsurance valuation.

Responsibilities

• Prepare, validate and load quarterly Prophet model inputs, including seriatim liability data, asset data, actuarial assumptions, economic scenarios and mapping tables.
• Execute and monitor scheduled Prophet production runs for U.S. GAAP, Bermuda EBS, U.S. statutory, tax and other required reporting bases, escalating run issues and completing reruns where necessary.
• Produce quarterly actuarial results and supporting metrics, including reserves, best estimate liabilities, capital and solvency measures, earnings components, cash flows and key management reporting metrics.
• Perform quarter-over-quarter rollforwards, actual-to-expected analysis and attribution of material movements; prepare clear commentary for reviewers and business partners.
• Complete data, model and output controls, including reconciliations, reasonableness checks, regression testing, static and dynamic validation, implied‑rate analysis and control evidence.
• Prepare standardized reporting packages, model extracts, journal‑entry support and disclosure information for Finance, Accounting, Risk and management within the quarter‑end timetable.
• Maintain run records, process documentation, model change logs and version controls in accordance with the actuarial control framework and audit requirements.
• Support stress, sensitivity, liquidity, BSCR and other analytical runs, as well as projection runs used for planning and capital analysis.
• Assist with annual assumption updates by executing test runs, analyzing impacts and documenting the implementation and results.
• Support model changes, production fixes and new‑business onboarding through testing, validation and controlled implementation.
• Identify opportunities to automate recurring data preparation, model execution, controls and reporting activities, working with technology and external partners as needed.
• Respond to internal and external audit requests and provide supporting documentation for assigned processes and results.
• Occasional help with other ad-hoc tests such as pricing support.

Skills

Actuarial modeling

Prophet

SQL

Python

Excel

Education

Bachelor's degree

Tools

SQL

Python

Excel

Job description

Chariot Reinsurance, Ltd. in the United States seeks an Actuarial Analyst to contribute to the valuation team by preparing model inputs, running Prophet, and delivering quarterly results across U.S. GAAP and Bermuda EBS.

The role emphasizes data validation, variance analysis, documentation, and collaboration with Finance, Risk and management. Experience with Prophet and actuarial reporting is preferred, with strong Excel skills and programming exposure.