Key Responsibilities :

• Create excel models (using VBA, SQL) against client models of legacy software. Run all the models points & portfolio to ensure that model output matches with legacy software results. Fix the model for deviation. Ensure the testing and validation is successful Write model spec against each of these legacy software models first. Write procedure notes against each of these spreadsheet model developed. Performing contractual premium review of product block/policies.
• Working on Bonus, Expense review, Fund mergers etc projects
• To ensure that all enquiries are recorded correctly on the Company Systems, for work to be scheduled to the individual and the team and to provide an audit trail.
• To ensure that you are aware of the company complaint and incident identification procedure and that these are acted upon immediately to minimize regulatory breaches, customer/client detriment and business image.
• To ensure that work is processed within industry compliance and legislative requirements under the guidance of the Manager, Analysts and Technicians, ensuring compliance with controls and procedures.
• To undertake any other duties as may be deemed appropriate by your manager.
• Ensure personal and business objectives for self are met in line with the departmental business plan and monitor success.
• To ensure that regulatory and audit requirements are met. To be aware of data security from a customer and business perspective and take responsibility for the prevention of fraudulent activity. Maintaining the data protection ideals of clear desk, secure storage, and secure PC.
• To ensure that the business operating systems utilized are used correctly and professionally.

Requirements : 

• Actuarial exam/s passed from IAI/IFOA/SOA etc.
• VBA Programming experience
• Experience with Structured Query Language (SQL)
• Actuarial Analysis experience within Life insurance (and annuity/pension policies)
• At least 3 to 5 years of actuarial experience of Life insurance
• Experience of working within an outsourcing environment