Technical Responsibilities:
▪ Conversion of existing Python scripts (in AWS) specific to Life and Health Actuarial teams to Google Big Query SQL
▪ Testing of the rewritten Big Query SQL logic and sign-off, upon alignment with Actuarial teams
▪ Document the requirement, ETL logic, testing plan and test results
Business Responsibilities:
▪ Work closely with finance and actuarial team enterprise architecture team, application development team to understand the applications workflow and requirement, integration pattern with finance cloud platform
▪ Conduct business analysis by eliciting, interpreting and analyzing the requirements from actuarial teams and producing specification of actuarial metrics & analysis
▪ Act as main liaison between business/actuarial teams and technical delivery team to drive realization of actuarial processes into proper execution, change management and BAU activities
▪ Create and maintain accurate and up to date documentations
▪ Support the migration of pricing tools in terms of technical accuracy and efficiency
▪ Support the actuarial control cycle through assisting the valuation team in the reserving exercise and strategic planning exercise
▪ Provide monitoring updates on profitability trends to senior stakeholders. This includes inflation studies, actual vs expected studies for all products, understanding the key profitability/loss drivers and providing recommendations.
Skills Requirement:
▪ Must have high technical proficiency with Python and Google Big Query SQL skills
▪ Present actuarial recommendations and reports to senior management, effectively translate complex actuarial codes in a clear and concise manner
▪ Highly experienced within Life or Health Insurance domain, preferably with 5-10 years’ experience
▪ Business Intelligence/Data Warehousing/ETL experience
▪ Excellent analytical skills, with the ability to analyze complex data sets and derive actionable insights.
▪ Detail-oriented mindset, focusing on accuracy and precision in actuarial calculations and analyses.