Senior Business Analyst - Actuarial Data

*
* Job Description:

**** We’re actively seeking a talented Senior Business Analyst - Actuarial Data to join our 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 you are not currently located near one of our offices, you will be required to relocate.
As an Senior Business Analyst - Actuarial Data you’ll move Pacific Life, and your career, forward by providing critical support to Enterprise Actuarial Valuation team by assisting in the coordination, management, and governance of actuarial data. You will fill a new role that sits on a team of 2 people in the Enterprise Actuarial Valuation division. Your colleagues will include other data analysts, actuaries, and data/IT professionals.
** How you’ll help move us forward:
**** Data Coordination & Integration:
*** 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.
** Support & Implementation:
*** 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.
** Quality Assurance & Governance:
*** 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.
** Prophet Data Tables & Data Domains:
*** 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.
** Process Optimization:
*** 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.
** Analysis & Insights:
*** 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.
** Documentation & Training:
*** 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.
** The experience you bring:
*** 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.
** What makes you stand out:
*** Experience with Python, FIS Prophet, and/or Tableau.
* Working knowledge of insurance and annuity administrative systems.
** Base Pay Range:
** The base pay range noted represents the company’s good faith minimum and maximum range for this role at the time of posting. The actual compensation offered to a candidate will be dependent upon several factors, including but not limited to experience, qualifications and geographic location. Also, most employees…