Skip to main content

Reserving Data Analyst

The role

To own the processing of month-end claims and premiums data into the Reserving SQL database, including the reconciliation process, for all lines of business as part of the quarterly reserving exercise.
To satisfy internal and external auditors that the Reserving database, models and processes adhere to relevant internal and external governance requirements.

To contribute to ongoing process improvements by designing and implementing solutions to automate existing manual processes, and improve performance of already automated processes.
To develop an understanding of relevant data sources and systems used by the Actuarial team in order to fulfil data requests both internally and externally from the wider Aspen organisation.

To become an expert in the key procedures, tables and objects within the SQL database that are used during the quarterly reserving exercise and be able to identify how the code has generated the final datasets.

Key accountabilities

  • Develops a good understanding of the evolving quarterly
    reserving exercise, including changes to the sources of
    premiums data processing and the reconciliations.
  • Assist in the design and implementation of improvements
    to the Reserving systems, to ensure these are in line with
    business requirements and reflect key priorities, and are
    delivered in the agreed timeframes.
  • Determines own work priorities and activities in line with
    agreed plans to ensure the achievement of the function's
  • Develops expertise in the key procedures, tables and objects
    within the SQL database that are used during the quarterly
    reserving exercise and is able to identify how the code has
  • Use appropriate version control of the code and models
    when developing new solutions.
  • Perform UAT on code changes as part of Aspen change
    control process, under guidance of Reserving Systems
    Developer or Manager of Reserving and Financial Data.

Skills & experience

  • Basic SQL knowledge
  • Intermediate VBA knowledge
  • Basic knowledge of computer
    hardware/software systems
  • Basic London Market Insurance
  • Understanding of both internal business
    drivers and industry dynamics
  • Understanding of underlying needs of
    the business and how own role
    contributes to these
  • Advanced user of MS Excel
  • Intermediate user of MS Access
  • Basic user of SQL, with desire to get more
  • Understands the fundamentals of query writing
    in SQL
  • Eager to learn and develop, and train others
    environment across geographies
  • Strong numeric and analytic capabilities
  • Effective verbal and written communication
  • Able to work independently
  • Ability to adapt in a fast changing environment
  • Specific professional qualifications (e.g.
    computer science, management of
    information systems or similar)

Reserving Data Analyst

London, UK
Full time
Lloyd's of London Market
bonus & benefits

Published on 01/14/2022

Share this job now