Business Analyst - Actuarial Data

Pacific Life • Newport Beach, CA

1d • Hybrid

About The Position

Pacific Life is actively seeking a talented Business Analyst - Actuarial Data to join their Data Steward Team in Charlotte, NC, Newport Beach, CA or Omaha, NE. This role follows a hybrid schedule of four days in the office (on-site). If not currently located near one of the offices, relocation is required. As a Senior Business Analyst - Actuarial Data, the individual will provide critical support to the Enterprise Actuarial Valuation team by assisting in the coordination, management, and governance of actuarial data. This is a new role on a team of 2 people within the Enterprise Actuarial Valuation division, collaborating with other data analysts, actuaries, and data/IT professionals. Pacific Life emphasizes its mission to help policyholders with financial planning and retirement, fostering collaboration and innovation to transform the industry and make a positive impact.

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.

Nice To Haves

• Experience with Python, FIS Prophet, and/or Tableau.
• Working knowledge of insurance and annuity administrative systems.

Responsibilities

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

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Number of Employees: 501-1,000 employees