We are seeking an experienced Senior Actuarial Analyst to support the analysis, modernization, and migration of actuarial reporting solutions into a Segment Data Warehouse environment. The ideal candidate will have strong experience with actuarial reporting processes, data analysis, and requirements gathering, with the ability to translate complex actuarial calculations into technical solutions.
The candidate will collaborate with actuarial business teams, data developers, and technical teams to analyze existing Excel and SQL-based actuarial reports, validate calculations, define requirements, and support the successful implementation of new reporting solutions.
Required Technical/Functional Skills
- 10+ years of experience in actuarial analysis, actuarial reporting, or related data analytics roles.
- Experience analyzing and documenting existing actuarial reports, measures, and calculations.
- Strong understanding of actuarial data, reporting processes, and business calculations.
- Ability to analyze underlying data and provide clarification on key calculations and data relationships.
- Experience translating business requirements into technical requirements for development teams.
- Experience creating requirements documentation, user stories, and acceptance criteria.
- Experience working with Excel-based reporting solutions and SQL-driven data analysis.
- Ability to collaborate with developers to replace legacy reports within enterprise data warehouse environments.
- Experience performing QA testing and validating new reports and measures against defined requirements.
- Prior experience with actuarial reserving and reporting processes, preferably within the reinsurance industry.
Preferred Skills
- Strong SQL skills for data analysis and validation.
- VBA experience for Excel-based reporting automation.
- Experience working with actuarial reserving processes and insurance/reinsurance data.
- Experience with data warehouse reporting environments.
Roles and Responsibilities
- Analyze existing Excel and SQL-based actuarial reports and measures and provide guidance to developers for migration into the Segment Data Warehouse.
- Review and clarify actuarial calculations, business rules, and reporting logic.
- Analyze source data to ensure accuracy and alignment with actuarial requirements.
- Develop functional requirements documentation and acceptance criteria as needed.
- Perform QA testing to validate that newly developed reports, calculations, and measures meet business expectations.
- Partner with actuarial stakeholders and technical teams to resolve data and reporting challenges.
- Support modernization initiatives by helping transition legacy reporting processes into scalable data warehouse solutions.
Required Experience
- Minimum 10 years of experience in actuarial analysis, reporting, data analytics, or related roles.
- Experience in insurance/reinsurance actuarial reporting preferred.
- Strong analytical, documentation, and communication skills.