Internship - Data & Reporting Support (Credit Risk / GIP - Workout Team)(M/F)

Founded in 1856, Banque Internationale à Luxembourg is the oldest multi-business bank in the Grand Duchy. From its foundation, the BIL has always played an active role in the development of the Luxembourg economy. It currently operates in retail, private and corporate banking, as well as on major capital markets. Employing more than 2 000 people, BIL is present in the financial hotspots that are Luxembourg, Switzerland, and China.
As a major player in Luxembourg's finance industry and as a signatory of the UN Principles of Responsible Banking, BIL is committed to handing over a responsible and sustainable bank to future generations.

Mission
You will support the Head of Gestion Intensive & Préventive (GIP / Workout) and the team on data consolidation, reporting, and materials used to steer the NPL / watchlist portfolio and key initiatives (notably Workout portfolio follow-up and task-force execution).

The role is data-oriented but sits in a credit risk environment, so financial curiosity and rigor matter are both welcome.

Make portfolio monitoring more reliable and faster by (i) producing recurring reporting packs, (ii) automating manual Excel work through macros, and (iii) improving visualizations and committee-ready presentations.

Main duties:
1) Portfolio data consolidation & quality
* Extract, consolidate, and clean portfolio datasets (exports, trackers, inputs from team members).
* Maintain data quality controls (completeness checks, exceptions, reconciliations, versioning).
* Document sources and logic to ensure traceability.

2) Reporting & dashboards (Excel)
* Produce recurring reporting (weekly/monthly) used for portfolio steering:
* pipeline of actions / next steps / deadlines,
* prioritization views (workload, bottlenecks, key risk flags),
* progress monitoring for task-force initiatives (e.g., annual reviews catch-up).
* Build clear charts and trend views that highlight what matters for decisions.

3) Automation (macros / VBA)
* Create or improve macro-enabled workbooks to reduce manual processing:
* automated imports / refresh routines,
* standardized templates,
* exception reports and controls.
* Troubleshoot and maintain existing tools.

4) PowerPoint governance packs
* Prepare committee-ready slides (clear storyline, key messages, charts, action plan tracking).
* Ensure consistency of templates and visual quality across recurring packs.

5) Ad hoc analytical support
* Quick analyses for portfolio deep-dives (segments, top exposures, early-warning indicators, action effectiveness).
* Support preparation for internal governance discussions when needed.

Profile:

* Data/Business Analytics student (min Master 1 ), applied economics, engineering, or quantitative finance.
* A strong finance student is also suitable if they can demonstrate Excel/VBA automation capability and data handling discipline.

Technical skills:
* Excel advanced: pivot tables, structured tables, robust formulas, charting.
* Macros/VBA: ability to build and maintain automation (practical, not theoretical).
* PowerPoint: ability to synthesize, structure slides, and produce clean visuals.
* Strong comfort with large datasets and imperfect extracts.
* Power Query (strong asset), Power BI/Tableau, basic SQL/Python. - would be a plus
* Familiarity with credit risk / financial statements / banking products. - would be a plus

Working style
* Strong attention to detail and "data hygiene" mindset.
* Ability to deliver on recurring timelines with minimal supervision.
* Discretion and professionalism (confidential credit information).
* Pragmatic: focuses on useful outputs, not over-engineering
BIL offers a broad range of challenging projects and a huge choice of career paths .We will assist you in finding the one that best meets your skills and expectations. Your personal development is our priority and we greatly encourage you to dive into different business areas for the broadest possible experience.
BIL is firmly of the opinion that diversity & inclusion contribute towards increasing the collective performance of the Bank. We are committed to creating a culture of inclusion that encourages individual development with equal opportunities for all.

NB: The selected candidate will be asked to provide an extract from the criminal record (no.3) as evidence of integrity and justified with regard to the specific needs of the position to be filled. Other documents will be collected, to the extent legally permitted, to perform background checks.