Master's thesis in Software Development: Compile pension actuarial calculations from Excel formula’s to high-performing code (Project GROENpensioen)

This master’s thesis is part of the ‘Van GRIJSpensioen naar GROENpensioen‘ graduation project. With this project, we are giving the pension industry a digital boost by optimizing digital infrastructures and processes. In doing so, we are making pension funds more efficient and sustainable, with better data management, strong privacy protection, and personalized services.

Pension funds periodically perform actuarial calculations for all participants. Many of these actuarial calculations are developed in Microsoft Excel and then manually converted into code. Since these calculations are performed for everyone with a pension, they must be calculated efficiently.

Assignment

In this master’s thesis, you will research how these (compounding) calculations can be converted from Excel files to high-performance code. You will need to consider the following aspects:

• Automation: Develop a system to automate the conversion of actuarial calculations from Excel to executable code. This will minimize manual intervention, reduce errors, and improve lead time.
• Auditability: Ensure that the resulting high-performance code is human-readable, allowing it to be reviewed by developers and audited by external parties.
• Reliability and Testability: Enhance the reliability of actuarial calculations by ensuring the correctness and accuracy of the automated processes.
• Efficiency and Sustainability: Improve computational efficiency to reduce the environmental impact associated with high compute usage, contributing to a reduced carbon footprint for the pension fund’s operations.

Further explanation (in dutch):

https://www.verzekeraars.nl/media/6539/uniforme-rekenmethodiek-voor-dc-regelingen.pdf

https://pensioenmodellen.nl/format/standaardmodel-verbeterde-premieregeling/

Dataset: https://www.dnb.nl/voor-de-sector/open-boek-toezicht/sectoren/pensioenfondsen/dnb-publiceert-definitieve-scenariosets-bij-wet-toekomst-pensioenen/

About Info Support Research Center

We anticipate on upcoming and future challenges and ensures our engineers develop cutting-edge solutions based on the latest scientific insights. Our research community proactively tackles emerging technologies. We do this in cooperation with renowned scientists, making sure that research teams are positioned and embedded throughout our organisation and our community, so that their insights are directly applied to our business. We truly believe in sharing knowledge, so we want to do this without any restrictions.

Read more about Info Support Research here.

What does Info Support offer you during your graduation period?

Of course, we offer you an excellent package of graduation conditions with various options. These include:

• Laptop, all necessary tools, and development environments to successfully carry out your assignment
• A graduation allowance, where you have the choice of:
  • € 1000 gross per month
  • € 500 gross per month + lease car with fuel card
  • € 600 gross per month + accommodation in Veenendaal

During your graduation internship, you will be included in one of our business units and in our Research Center. This will give you a good understanding of the developments within our projects and our research projects.

In addition, Info Support offers you:

• A challenging master’s thesis at a solid, growing, and financially healthy company
• Professional and experienced guidance, hybrid working
• A graduation program with, among other things, training sessions, knowledge evenings, project visits, activities, and team, unit, and company outings
• Experimentation with new products and releases that are in the pre-release phase
• Brainstorming with other graduates and IT colleagues who are collegial and passionate
• Potential for a permanent position in our IT Top Traineeship program!

About Info Support

Info Support specializes in custom software, data/AI solutions, management, and training and is active in the Finance, Industry, Agriculture, Food & Retail, Mobility & Public, and Healthcare sectors. We provide solid and innovative solutions for complex and critical software issues. Our headquarters are located in Veenendaal (NL) and Mechelen (BE). At present, approximately 500 employees are employed by Info Support.

Info Support’s working method is characterized by a number of core values: solidity, integrity, craftsmanship, and passion. These core values are intertwined in our work and the way we interact with each other. This year, we were also named a Top Employer in the Netherlands!

To ensure that all employees are always up to date with the latest developments, Info Support has an in-house knowledge center that eagerly satisfies the hunger for more or different knowledge and skills.

B2 language proficiency in Dutch is required.