Since Aspen was founded in 2002, we have become a leading, diversified specialty insurance and reinsurance company. We respond thoughtfully and creatively to find the best outcomes for our clients and business partners through carefully-tailored solutions.
We believe the way we work is just as important as the work we do, and we are guided by our core values of respect, honesty, trust and professionalism.
Aspen is a great place to develop your career offering an exciting and challenging environment where achievement is rewarded.
The Role
We are recruiting for a Reserving Systems Analyst to join our Group Reserving Team!
To own the monthly processing of 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 manual processes, and improve performance of existing 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
To be a key point of contact for the Reserving Team, responding to queries in timely fashion, particularly during the quarterly reserving exercise
To contribute to the development of additional analytical capabilities and reporting for use within the Actuarial team and more widely across Aspen, with a focus on using data visualisation techniques to create insights
Our Aspen Values are expected to be reflected in the delivery and performance of every role.
Key Accountabilities
Develops a good understanding of the evolving quarterly reserving exercise, including changes to the sources of data, and considers impacts on the month-end claims and 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
Ensures the Reserving database, models and processes adhere to relevant internal and external governance requirements at all times
Prioritises tasks that enable the Reserving Team to meet the timelines of the quarterly reserving exercise
Operates the month-end process with minimal oversight from the Manager of Reserving and Financial Data
Adapts the documentation and reconciliations to changes in the data sources feeding into the quarterly Reserving exercise
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 generated the final datasets
Uses appropriate version control of the code and models when developing new solutions
Performs UAT on code changes as part of Aspen change control process, under guidance of Reserving Systems Developer or Manager of Reserving and Financial Data
Identifies and/or supports improvement in responsiveness and reliability of the Reserving models and process so as to provide greater stability and improved user experience
Identifies and effectively communicates why datasets contain the current results in answer to queries from Reserving Team
Knowledge, Skills, & Experience
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 SQL, with desire to get more exposure
Understands the fundamentals of query writing in SQL, or other programming languages
Able to create reports in Microsoft PowerBI or SQL Server Reporting Services
Ability to build and maintain effective relationships with colleagues across departments while remaining committed to providing quality results with positive service
Able to explain technical solutions to audiences who don't have IT background
Ability to collaborate effectively within a team environment across geographies
Strong numeric and analytic capabilities
Effective verbal and written communication
Strong attention to detail
At Aspen we know that having a diverse and inclusive workforce is good for our people, good for our business and good for the environments in which we operate. We therefore welcome applications from people which allows us to draw on diverse cultures, perspectives, skills and experiences.