Reserving Systems Analyst

Reserving Systems Analyst

Location: London (Hybrid working)

Keywords: SQL database, data visualisation, actuarial data, collaborative team, process improvement, stakeholder engagement, insurance industry, PowerBI reporting, governance standards, supportive environment

Aspen is seeking a Reserving Systems Analyst to join their Group Actuarial division in London, offering you the opportunity to become an integral part of a highly respected and collaborative actuarial data and performance information team. This role is perfect for someone who thrives on working with complex data systems, enjoys automating processes, and values being at the heart of critical business decision-making. You will play a pivotal role in ensuring the accuracy and reliability of Aspen's reserving data, supporting both internal and external stakeholders, and contributing to ongoing process enhancements.

Join Aspen's renowned Group Actuarial team in London, where your analytical skills will directly support key business functions and strategic objectives across all lines of business.

Benefit from a culture that encourages continuous learning, professional development, and knowledge sharing-empowering you to grow your technical expertise in SQL, VBA, PowerBI, and more.

What you'll do:

As a Reserving Systems Analyst at Aspen in London, you will immerse yourself in managing complex actuarial datasets that underpin vital business decisions. Your day-to-day activities will involve processing large volumes of claims and premium data into robust SQL databases while ensuring every step meets rigorous governance standards. You will collaborate closely with actuaries and other stakeholders across departments to answer queries swiftly and accurately-particularly during high-pressure quarterly reserving periods.

• Own the monthly processing of claims and premiums data into the Reserving SQL database for all lines of business as part of the quarterly reserving exercise, ensuring accuracy through thorough reconciliation processes.
• Satisfy internal and external auditors by maintaining strict adherence to governance requirements for the Reserving database, models, and processes.
• Design and implement solutions to automate manual processes within the reserving function, continually seeking ways to improve performance of existing automated workflows.
• Develop a deep understanding of relevant data sources and systems used by the Actuarial team to efficiently fulfil internal and external data requests across Aspen.
• Become an expert in key procedures, tables, and objects within the SQL database used during quarterly reserving exercises, identifying how code generates final datasets.
• Act as a key point of contact for the Reserving Team by responding promptly to queries-especially during critical quarterly cycles-and providing clear explanations of results.
• Contribute to developing additional analytical capabilities and reporting tools for use within the Actuarial team and wider organisation, leveraging data visualisation techniques to create actionable insights.
• Assist in designing improvements to reserving systems so they align with evolving business requirements while meeting agreed timelines.
• Perform user acceptance testing (UAT) on code changes as part of Aspen's change control process under guidance from senior colleagues.
• Maintain regular contact with stakeholders to ensure models operate efficiently while helping foster a service-oriented culture within the Actuarial Data team.

What you bring:

To excel as a Reserving Systems Analyst at Aspen, your background should include hands-on experience working with SQL databases-ideally within an insurance or financial services context-where you have demonstrated strong problem-solving abilities. Your comfort with VBA programming will allow you to automate repetitive tasks efficiently while maintaining high standards of accuracy.

• A basic understanding of computer hardware/software systems supports troubleshooting efforts when issues arise within reserving models or databases.
• Familiarity with London Market Insurance practices or commercial lines insurance terminology helps contextualise your work within Aspen's broader business objectives.
• Advanced user skills in Microsoft Excel allow you to manipulate large datasets efficiently while producing accurate analyses for stakeholders.
• Ability to create reports using Microsoft PowerBI or SQL Server Reporting Services demonstrates your capability with modern data visualisation tools.
• Strong numeric and analytic abilities enable you to interpret complex datasets accurately while maintaining attention to detail throughout all processes.
• Excellent verbal and written communication skills ensure you can explain technical solutions clearly-even to audiences without IT backgrounds-and document changes thoroughly for peer review.
• Proven ability to collaborate effectively within teams across different geographies fosters positive relationships with colleagues throughout Aspen's global network.
• Adaptability in fast-changing environments allows you to respond constructively when priorities shift or new challenges emerge.

What sets this company apart:

Aspen stands out as a leading global insurance provider known for its commitment to excellence, innovation, and employee development. The company fosters an inclusive culture where collaboration is encouraged at every level-ensuring that everyone's voice is heard regardless of their background or experience. At Aspen, employees benefit from access to cutting-edge technology platforms alongside comprehensive training opportunities designed to support both personal growth and professional advancement. The organisation places great emphasis on flexible working arrangements wherever possible so that staff can achieve a healthy work-life balance without compromising on career progression.

What's next:

If you are ready to take your career forward by joining a collaborative team at one of London's most respected insurers-apply now!

Apply today by clicking on the link provided; don't miss this chance to become part of Aspen's outstanding actuarial community.

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.