Technical Actuarial Analyst

  • Job Reference: 638544
  • Date Posted: 1 July 2024
  • Recruiter: ShareForce
  • Location: London
  • Salary: £65,000 to £70,000
  • Sector: IT and Telecomms
  • Job Type: Permanent

Job Description

A compelling opportunity at a leading speciality insurance firm, who are rewriting the way insurance services are delivered globally through a major digital transformation programme, based here in the London HQ. As a Technical Actuarial Analyst, you will utilise your technical skills and actuarial knowledge to assist the reserving team in managing the SQL server database and enhancing processes as new reserving transformation projects commence. 
 
Responsibilities: 
  • Provide Python and SQL Server infrastructure support to the reserving team during intra-quarter periods and peak cycles, referring to key actuarial principles. 
  • Create custom reporting scripts and stored procedures in SQL Server Management Studio, PyCharm, or VSCode to meet team reporting requests. 
  • Enhance current data ingestion processes using Python. 
  • Implement effective environmental controls to separate DEV and PROD servers. 
  • Introduce version control for team scripts using Azure DevOps or GitHub. 
  • Redesign the existing DEV server with modern database principles. 
  • Automate routine actuarial calculations using Python and/or SQL Server to extend the codebase.  
Skills and Experience:  
  • Demonstrable experience within the reserving team of the actuarial function. 
  • Advanced T-SQL querying skills and strong knowledge of database design, indexing, and performance optimisation, including reading execution plans. 
  • Demonstrated experience managing small-scale on-premise SQL Server databases with database administration concepts. 
  • Advanced Python programming skills in data science. 
  • Experience using Python with SQL Server, including pyodbc/sqlalchemy and MS Excel. 
  • Exposure to Power BI reporting skills and actuarial business knowledge.  
Additional Information:
  • Salary Range: £65k-£70k
  • Location: Hybrid / London
  • Benefits: Private medical, pension, and bonus
  • Applicants must hold the right to work in the United Kingdom without sponsorship