Back to job search

MI Analyst

  • Location:

    City of London, London

  • Salary:

    Negotiable

  • Contact:

    Ben Stallard

  • Contact email:

    Ben.Stallard@oliverjames.com

  • Job ref:

    JOB-032021-138704_1622797132

  • Published:

    about 2 months ago

  • Expiry date:

    2021-07-04

MI Analyst - Insurance

Purpose of the Role

  • The role will involve building and developing the back-end infrastructure as part of the Future State Reserving project that is on-going within the business.
  • The Reserving team coordinates the reserving process and regulatory reporting requirements related to the SII Technical Provisions
  • The Insurance Data / MI Senior Analyst will report into the Reserving Projects Actuary who reports into the Head of Reserving.

Key Responsibilities

  • Understanding the internal Actuarial processes with a view to providing input around improvements of those processes
  • Maintaining and developing the SQL Server infrastructure that will form the basis of the future reserving processes Designing and creating custom reports
  • Advanced querying of existing SQL Server databases using TSQL
  • Understanding MI needs by working with the business

Skills and Experience

  • The candidate must have at least 3 years of experience using SQL Server in a BAU and build capacity
  • In addition, strong TSQL querying skills are required
  • Exposure using SSAS OLAP cubes in a BAU capacity, although build experience is not necessary
  • Experience with Power BI and integrating it into the Microsoft software suite, particularly MS Excel.
  • Previous experience working within Insurance required - preferably Lloyds Insurance experience

OJ Webinar | Breaking down barriers: How to inclusively hire, attract and onboard disabled talent

Secure your space on the next OJ Webinar

Breaking down barriers: How to inclusively hire, attract and onboard disabled talent | Wednesday 11 Aug | 1pm