Actuarial Analyst

Constellation Insurance, Inc.•Montgomery, OH

1d•Hybrid

About The Position

Entry-level Actuarial Analyst positions are hired into the Actuarial Rotation Program. This program provides the opportunity to rotate among various actuarial departments within Constellation Insurance, including Valuation, Special Projects, Enterprise Risk Management, Product Development, Hedging, and Reinsurance. Candidates will be hired into one of these departments and are expected to spend a minimum of two years in the role before being eligible to rotate. The initial hiring role and department are determined by availability and company needs at the time of hire.

Requirements

A bachelor's degree in actuarial science, mathematics, statistics or related quantitative field.
Passed at least one or more exams toward associateship with the Society of Actuaries.
Recent graduate with internship experience in a related field or one to two years of related experience.
Experience with Excel, including updating and maintaining existing spreadsheets; familiarity with common formulas and analytical tools; and the ability to develop spreadsheets for actuarial analysis and reports.
Knowledge of programming, preferably experience with writing macros in Visual Basic or developing code for modeling insurance products within actuarial modeling software.
Experience using database tools (Microsoft Access and/or SAS) to build queries, analysis and use reporting tools on large sets of data.

Nice To Haves

Experience with actuarial software preferred (i.e. Moody's AXIS, MG-ALFA, Poly Systems, Prophet, Moses, etc.).
Effective communicator
Problem solver
Integrity
Diligence
Pride in work
Big picture acumen

Responsibilities

Rotate among actuarial departments including Valuation, Special Projects, Enterprise Risk Management, Product Development, Hedging, and Reinsurance.
Serve in an actuarial role for a minimum of two years before being eligible for rotation.
Perform actuarial analysis and develop reports.
Write macros in Visual Basic or develop code for modeling insurance products within actuarial modeling software.
Use database tools (Microsoft Access and/or SAS) to build queries, perform analysis, and use reporting tools on large sets of data.