Job Description
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
objectives. - 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
knowledge - 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
exposure - 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)
