Energy Jobline is the largest and fastest growing global Energy Job Board and Energy Hub. We have an audience reach of over 7 million energy professionals, 400,000+ monthly advertised global energy and engineering jobs, and work with the leading energy companies worldwide.
We focus on the Oil & Gas, Renewables, Engineering, Power, and Nuclear markets as well as emerging technologies in EV, Battery, and Fusion. We are committed to ensuring that we offer the most exciting career opportunities from around the world for our jobseekers.
Job Description
Job Title: Senior Reserving Systems Analyst
Location: London (hybrid working)
Role Overview:
* To oversee the monthly processing of claims and premiums data performed by the Reserving Systems Analyst, which covers all lines of business as part of the quarterly reserving exercise.
* To take responsibility for the production, accuracy, and design of the models and processes used by the Group Reserving Team to accomplish their analysis.
* To be the primary point of contact for the Group Reserving Team, responding to queries in timely fashion, particularly during the quarterly reserving exercise, and to remain cognizant of their deadlines.
* To solicit feedback from the Group Reserving Team on all aspects of the end-to-end reserving process, and curate this into well-defined improvements which can feed into the broader reserving transformation project.
* To become a recognised expert in the data sources and systems used by the Actuarial team, and use this knowledge to confidently respond to questions from other Aspen teams outside of Actuarial, such as Claims, Finance, or IT.
* To become an expert in the key procedures, tables and objects within the Reserving SQL database that are used during the quarterly reserving exercise and be able to identify how the code has generated the final datasets.
* To become an expert in the reporting capabilities of the Reserving SQL database and be able to advise which reports will be most appropriate when internal or external data requests are received.
* To contribute to the development of additional reporting and analytical capabilities within the Actuarial team and more widely across Aspen, with a focus on using data visualisation techniques to create insights.
* To contribute to the training of the Group Reserving Team on the tools available for investigation, analysis, and reporting.
* To be the expert on the controls framework governing the quarterly reserving exercise, and attest to the compliance of the SOx controls and reconciliation processes in line with the audit timelines.
* To satisfy internal and external auditors that the Reserving database, models and processes adhere to relevant internal and external governance requirements.
* To lead walkthroughs to internal and external auditors of the reserving process documentation and controls.
Key Accountabilities:
* Remains constantly up to date with the evolving quarterly reserving exercise, including changes brought about through the reserving transformation project, and anticipates impacts on the month-end claims and premiums data processing, the controls and documentation.
* Assist in the design and implementation of improvements to the Reserving systems, to ensure these are in line with business requirements, 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.
* Oversees the month-end process with minimal input from the Head of Reserving Data and Transformation.
* Maintains up-to-date documentation and reconciliations for all aspects of 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 can identify how the code has generated the final datasets.
* Uses appropriate version control of the code and models when developing new solutions.
* Creates appropriate test plans and oversees user-acceptance testing (UAT) for code changes to support the implementation of necessary bug fixes and general improvements as part of Aspen change control process.
* Identifies and/or supports improvement in responsiveness and reliability of the Reserving models and process 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:
* Relevant degree and/or professional qualification (e.g. mathematics, computer science, management of information systems or similar)
* Experience working as part of an actuarial team within the insurance industry, preferably within a reserving function
* Familiarity with jargon and practices in the Commercial Lines Insurance market
* Good London Market Insurance knowledge
* Excellent knowledge of typical end-to-end reserving process workflows
* Understanding of both internal business drivers and industry dynamics
* Understanding of underlying needs of the business and how own role contributes to these
* Basic knowledge of computer hardware/software systems
* Advanced user of MS Excel
* Intermediate user of SQL and VBA
* Understands the fundamentals of query writing in SQL, or other programming
* Able to create reports in Microsoft PowerBI or SQL Server Reporting Services
* Eager to learn and provide training to others
* 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 do not have an actuarial or IT background
We are committed to creating an inclusive recruitment experience. If you require support or adjustments to the recruitment process, our Adjustment Concierge Service is here to help. Please feel free to contact us at adjustments@robertwalters.com to discuss how we can support you.
This position is being recruited on behalf of our client through our Outsourcing service line. Resource Solutions Limited, trading as Robert Walters, acts as an employment business and agency, partnering with top organizations to help them find the best talent. We welcome applications from all candidates and are committed to providing equal opportunities.
If you are interested in applying for this job please press the Apply Button and follow the application process. Energy Jobline wishes you the very best of luck in your next career move.
#J-18808-Ljbffr