Senior Actuary – Data Steward

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.

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

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

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

• Conduct exploratory data analyses on both input and output data.
• Provide insights and decision support to actuarial, finance, and business teams.
• Assist with reporting enhancements, ad hoc studies, and enterprise analytics initiatives.

• 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
• Bachelor’s in Actuarial Science, Mathematics, Statistics, Computer Science, or related field.
• Strong background in data management, governance, data architecture, or actuarial data processes.
• Experience working with actuarial models and data structures.
• Technological skills: SQL, scripting (Python/R), relational databases, data lakes, and data management platforms.
• Experience with Snowflake, Prophet, or Poly Systems 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.