Assist in gathering and organizing actuarial data for integration with Prophet and IT systems
Support coordination of data updates across various teams, ensuring proper alignment with actuarial modeling needs
Help maintain consistency across Prophet tables, aiding in data standardization and structure improvements
Provide support for new product implementations, including updates to assumption changes, asset/market/scenario model inputs, and reinsurance data
Assist in tracking data-related changes and ensuring seamless integration into production processes
Work closely with the Actuarial Data Steward and modeling team to streamline regression testing and development
Perform data validation checks and assist with cleansing activities to maintain high-quality actuarial data
Help monitor and troubleshoot data inconsistencies, ensuring timely resolution of issues affecting quarterly reports
Support the implementation of governance controls for centralized data tables
Assist in maintaining reference data tables, including updating product information, risk codes, cap rates, and other critical data elements
Support updates to cohort mapping tables with new Prophet file names assigned to products
Ensure accurate organization of policy information within various data domains
Identify opportunities to improve efficiency in data handling and processing
Assist in managing input data to minimize issues related to missing or changed tables
Help resolve reproducibility challenges caused by structural changes in data tables
Assist in data exploration and analysis, providing insights for actuarial and business users
Support reporting and ad-hoc analysis by extracting and organizing key actuarial data
Help maintain documentation of actuarial data processes for both actuarial and non-actuarial teams
Support training efforts by assisting in the development of reference materials and guidance for data-related tasks

Requirements

Bachelor’s degree in finance, actuarial science, statistics, mathematics, data science, or a related field
Familiarity with life insurance and annuity products
Working knowledge of SQL, Excel, VBA
Strong technical, analytical, and problem-solving skills
Background in developing presentable data results and analysis
Ability to meet and manage responsibilities under tight time frames
Strong verbal and written communication skills for effective interactions
Experience working cross-functionally with different departments
Continuous improvement mindset, collaborative and inclusive
Ability to work independently

Benefits

Your Benefits Start Day 1
Prioritization of your health and well-being including Medical, Dental, Vision, and Wellbeing Reimbursement Account that can be used on yourself or your eligible dependents
Generous paid time off options including: Paid Time Off, Holiday Schedules, and Financial Planning Time Off
Paid Parental Leave as well as an Adoption Assistance Program
Competitive 401k savings plan with company match and an additional contribution regardless of participation

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLExcelVBAdata validationdata cleansingdata explorationdata analysisactuarial modelingregression testingdata standardization

Soft Skills

analytical skillsproblem-solving skillscommunication skillscollaborationindependencetime managementcontinuous improvement mindsetattention to detailorganizational skillstraining and development