Eif Trainee

**EIF Posting**:
The **European Investment Fund** (EIF) is seeking to recruit for its **Operations and Information Management Department - **Cash** Flow Management (OIM-CFM)** **Division **at its headquarters in Luxembourg**, **a **Trainee - Cash Flow Management - Data Management**

Duration: five (5) months & Starting date: April 2023

**Specific Post Environment**:
The Cash Flow Management (OIM-CFM) Division prepares and analyses all cash flow transactions generated by EIF operations (at transaction and mandate level, with the exception of fees) for execution by Financial Control. The sensitivity of cash flow transactions is high. As a result the activity is guided by strict internal processes and procedures.

That includes - for instance - the analysis, calculation and recording of:

- guarantee calls, clawbacks, recoveries, loans and repayments related to debt financial instruments;
- drawdowns and repayments including equalisation related to equity financial instruments;
but also extends to:

- the compilation of disbursement forecasts and payment requests;
- the conception and calculation of waterfalls, the monitoring of the deployment of tranches;
- the calculation of return of funds related to mandates.

The OIM-CFM team is dealing with a large number of transactions thus far. New mandates such as the European Guarantee Fund are currently starting to be implemented in addition. This means that efficient data management, data deployment and the automation thereof are key to the OIM - CFM division and the EIF at large.

Working at the OIM-CFM Division will allow you to be exposed to a broad range of cash flow management aspects at EIF while participating to the improvement of the existing data management and the continuous automation connected thereto.

**Overall objective**:
Your overall objective is to assist the CFM team in further automating cash operations, by means of assisting in data management targeted at automation (i.e., entry, reconciliation and monitoring).

**Responsibilities**:
Under the responsibility of a (Senior) Officer, you shall:

- Contribute to the automation of ongoing and future mandate data management in e-front, such as mandate payment instructions;
- Participate to system enhancements, by means of populating additional fields on cash operations regarding (equity) mandates and in this respect contribute to the finalisation of historical input of mandate data in e-front, where applicable.
- Using the existing data pools, contribute to the calculation, the enhancement of monitoring as well as data processing and reporting by means of building relevant dashboards in Business Objects and Tableau, Power Query and Alteryx as the case may be.

**Expected outcome**:
The traineeship will allow you to:

- obtain an in-depth overview of EIF’s lines of business (mandates, debt and equity transactions) as well as their interactions;
- More specifically you will learn about EIF cash flow processes and procedures (drawdowns, repayments, guarantee calls, recoveries, capital calls, returns of funds, waterfalls etc.) in the context of data monitoring and automation;
- In addition, you will be able to get a first-hand experience on several data storage, reconciliation and reporting systems e.g. e-Front, Business Objects, Tableau, Accurate etc.

At the end of the traineeship, you will have contributed to the progress of our division-wide project of data automation, reconciliation and monitoring.

**Qualifications**:
**Competencies**:
**Technical/Professional Knowledge & Skills required**
- Advanced knowledge in Microsoft Office suite, notably Excel;
- Knowledge and understanding of EIF’s mission and activities;
- Knowledge of Business Objects and/or e-Front would be a plus;
**Experience required (if applicable)**
- Excellent written and spoken English. Knowledge of other EU languages considered an asset.

**Key Competencies required**
- Good interpersonal skills,
- Ability to work meticulously and efficiently;
- Analytically-minded and detail-oriented with a problem-solving attitude;
- Team player but also capable to work autonomously under well-defined guidelines and given objectives.