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

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.
• Support onboarding of new products into production data pipelines and actuarial systems.
• Assist in 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.

Qualifications

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

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.