Senior Actuary (FSA) - Data Steward
About the role
Pacific Life is actively seeking a Senior Actuary (FSA) 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. While construction is underway for our new Charlotte location, we are opening an interim location in early 2026, less than a mile from the Queensbridge Collective.
Responsibilities
- Data Coordination & Integration
- Coordinate prioritization and delivery of data changes across actuarial, IT, and business teams.
- Support integration of new or updated data sources into Prophet and other actuarial systems.
- Ensure Prophet tables and actuarial data structures remain aligned, consistent, and optimized across product lines.
- Work with business partners to understand how data movements impact results, providing clarity, analysis, and direction.
- Collaborate with business stakeholders to understand actuarial model requirements, ensuring data is structured appropriately to meet modeling needs.
- Assist in onboarding new products into production data pipelines and actuarial systems.
- Support assumption updates, asset/market scenario inputs, reinsurance changes, and other data updates.
- Partner with modeling teams to define optimal data approaches for new products that streamline regression testing and accelerate development.
- Quality Assurance & Data Governance
- Develop and apply data validation rules, diagnostic checks, and cleansing routines.
- Identify future data issues that may impact quarter-end reporting by understanding model run structures and policy mapping logic.
- Implement governance for centralized reference tables to ensure reproducibility and cross-team consistency.
- Prophet Data Tables & Data Domains
- Maintain reference data tables (risk codes, cap rates, product mappings, file name assignments).
- Understand and manage relationships between data domains and Prophet inputs to ensure accuracy and completeness.
- Update cohort mapping and Prophet file references for new or revised products.
- Process Optimization
- Identify automation opportunities and areas for process improvement to enhance reliability and efficiency.
- Mitigate risks caused by new plan codes, new asset types, missing keys, or evolving table structures.
- Improve the stability and reproducibility of historical model runs and reporting cycles.
- Analysis & Insights
- Conduct exploratory data analyses on both input and output data.
- Provide insights and decision support to actuarial, finance, and business teams.
- Aid in reporting enhancements, ad hoc studies, and enterprise analytics initiatives.
- Documentation & Training
- Develop clear and comprehensive documentation for data processes, governance, and workflows.
- Provide training and support to actuarial and non-actuarial partners to build shared understanding and transparency.
- Actuarial Credentials: FSA
- Education: Bachelor’s in Actuarial Science, Mathematics, Statistics, Computer Science, or related field.
- Experience: Strong background in data management, governance, data architecture, or actuarial data processes.
- Experience working with actuarial models and data structures.
- Technical Skills: SQL, scripting (Python/R), relational databases, data lakes, and data management platforms.
- Experience with Snowflake, Prophet, or PolySystems is a strong plus.
- Analytical Abilities: Skilled in interpreting complex datasets and diagnosing data issues.
- Communication: Ability to translate technical details into clear business language.
- Project Management: Effective at organizing workflows, timelines, and stakeholder alignment.
- Continuous Learning: Interest in expanding expertise in Prophet data architecture and modern data management approaches.
- SQL
- Scripting (Python/R)
- Relational databases
- Data lakes
- Data management platforms
- Snowflake
- Prophet
- PolySystems
Qualifications
Skills
Benefits
Your benefits start day 1. Your wellbeing is important to Pacific Life, and we’re committed to providing you with flexible benefits that you can tailor to meet your needs. Whether you are focusing on your physical, financial, emotional, or social wellbeing, we’ve got you covered. Prioritization of your health and well-being includes Medical, Dental, Vision, and Wellbeing Reimbursement Account that can be used on yourself or your eligible dependents. Generous paid time off options include: 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.