FREE ACCESS
5,000–10,000 jobs/day
See all jobs on JobTailor
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Business Analyst – Actuarial Data
Pacific Life. Assist in gathering and organizing actuarial data for integration with Prophet and IT systems .
Tech Stack
Tools & technologiesSQLVBA
About the role
Key responsibilities & impact- 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
What you’ll need- 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
Comp & perks- 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
ATS Keywords
✓ Tailor your resumeApplicant 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