Job Description
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.