Deadline:
As soon as possible
Location(s)
Luxembourg
Overview
Details
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.
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.
Opportunity is About
Eligibility
Candidates should be from:
Description of Ideal Candidate
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
Dates
Deadline: As soon as possible
Cost/funding for participants
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.
Un-save Opportunity
Internships, scholarships, student conferences and competitions.
