Actuarial Analyst
Current• Knowledge of advanced Excel functionality such as what-if data tables, array formulae etc and trained in key design principles of development and audit of Excel models. Experience of building dashboard reports in Excel and key visualisation tools such as charts and pivot tables.• Developed and worked with a number of example Excel actuarial models to detailed specifications including building and testing a policyholder illustration model in line with FCA COBS guidance including a unit-linked cashflow projection and annuity calculation model.• Trained in VBA and general best coding practices and has developed and tested VBA applications including sensitivity analyses, cashflow models and data import.• Undertook introductory courses in R and Python, covering key syntax and practical examples using popular libraries.• Databases (Access, SQL): Manipulation and formatting of complex Excel datasets, and interrogation of actuarial data sets using Access queries and SQL.• Effective written and verbal communication covering topics such as providing client services and technical documentation.• Life insurance and Pensions knowledge: common products, investment/assets knowledge, development of profit testing and reserving techniques. • Experienced introductory training courses on General Insurance and Lloyd’s and demonstrated an understanding of the key features of the London market.• Knowledge of the insurance regulatory environment, including key reporting standards and other relevant legislation including TCF and illustrations guidance.• Professionalism and associated actuarial standards, including the Actuaries’ Code, TAS and APS.
