Data Science · BI · Data Visualization

Marius Delavoët

I build dashboards, data pipelines and analyses that turn raw data into decisions.

Data Science student · Exchange year at the University of Illinois Springfield · Springfield, IL

Resume (PDF) Email LinkedIn
Marius Delavoët
Degree BUT Data Science · IUT2 Grenoble
2026–2027 Exchange year · UIS
Latest role BI Intern · Amundi
Languages French (native) · English B2
01 About

I am a Data Science student at IUT2 Grenoble (Université Grenoble Alpes), specializing in data visualization and decision-support tools. I am spending the third and final year of my degree at the University of Illinois Springfield.

What I enjoy most is the full chain: collecting and cleaning raw data, modelling it, and delivering something a decision-maker can read at a glance. During my internship at Amundi, Europe's largest asset manager, I put that into practice with Power BI dashboards and an automated Python pipeline that are now used in production.

I care about accuracy, clear documentation and tools that people actually use after I leave.

Python R SQL Power BI Excel Tableau DAX Power Query Pandas VBA KNIME Shiny ArcGIS
Degree Bachelor of Technology (BUT) in Data Science
IUT2 · Université Grenoble Alpes · expected 2027
Exchange year University of Illinois Springfield
Fall 2026 – Spring 2027
Languages French (native)
English B2 · Cambridge B2 First (169) · Duolingo (120)
Location Springfield, IL · Grenoble, France
02 Experience
Business Intelligence & Data Pipeline Intern
Amundi ESR (Amundi Group) · Alixan, France
DatesApr – Jun 2026
TeamBeneficiary Services
StatusCompleted
ToolsPower BI · Python · VBA
2Power BI dashboards deployed to production
10+undocumented database tables mapped and modelled
Dailyautomated Python pipeline replacing a manual consolidation
Context

Amundi ESR runs employee savings and retirement plans for companies and their employees. Its Beneficiary Services department generates a large volume of data (calls, emails, complaints) but had no suitable reporting tools.

No data dictionary existed, so I learned the data model by working directly with the business teams and documenting what I found.

What I delivered
  • Two Power BI dashboards (Club & non-Club clients) with KPIs by division, validated and used by the account management teams
  • Redesigned the Power BI data model and reverse-engineered the business logic of the Genesys contact-center tables to resolve join ambiguities
  • Service quality dashboard: answer rate against 90% / 80% targets, first-contact resolution and quality KPIs, in validation at the end of the internship
  • Daily report automation: a VBA proof of concept, then a scheduled Python pipeline running in production every morning
Power BI Power Query DAX Python VBA
Daily report pipeline - end-to-end automation
Source
Outlook email
daily .xls attachment
Extraction
Python · win32com
automatic retrieval · Windows Task Scheduler
Indexing
JSON cache
date parsing · import tracking
Consolidation
Historical database
Excel output · 31 fields
Reporting
Managerial dashboard
by division and total · Power BI
Runs every morning · timestamped logging · no manual entry
Earlier experience
Summer Intern, Data & Client ManagementJul – Aug 2024
Amundi ESR · Valence, France

Processed 800 to 1,500 client data update requests per day on the Alto ESR platform, following internal banking procedures with strict accuracy and confidentiality requirements.

Youth Group Leader, holiday campsOct 2023 & Oct 2025
Town councils · Drôme, France

Supervised groups of children during two 2-week sessions; coordinated with the leader team and ran daily activities under time pressure.

03 Selected projects
2024–2026
Course project · Survey analysis
Studying in the age of generative AI - interactive R Shiny app

An R Shiny web app presenting a survey of about 4,000 university students on how they use generative AI, across 4 themes: usage, trust and ethics, learning methods and digital skills.

  • Univariate and bivariate charts, filterable by school
  • Multiple correspondence analysis and clustering of student profiles, with dynamic axis selection
  • Modular code with shared recoding and chart-building functions
RShinyFactoMineRggplot2dplyr
2026
Client project · University campus planning
Tram crossing inventory and compliance dashboard

For the Université Grenoble Alpes campus planning department: wrote the requirements, built a field data collection tool in ArcGIS Online, collected data on site, then delivered reporting dashboards, cost estimates for compliance work and a StoryMap presented to the client.

ArcGIS OnlineField data collectionDashboardsStakeholder presentation
2026
Course project · Business intelligence
Data warehouse for a transportation company

Designed a data warehouse for a school transportation company (customer profiles, monthly sales, failed payments): data dictionary from CSV, Excel and XML sources, star schema, ETL flows in KNIME, MySQL implementation and analytical SQL queries.

SQLMySQLKNIMEETLStar schema
2025
Course project · Forecasting
NYC taxi demand forecasting

Analyzed 3.9 million New York City taxi trips (NYC TLC, April–May 2023): identified weekly seasonality, decomposed trend and seasonality, compared regression with Holt-Winters exponential smoothing, selected the model by RMSE and produced a 7-day forecast.

RTime seriesHolt-WintersModel selection
2025
More projects
Finance Desk - investment decision tool2025 – 2026
Personal project

Started as a Python script automating stock and ETF price history with comparative charts, then rebuilt as a multi-page Dash app on a SQLite database, with market data from yfinance and reconciliation against my brokerage export. Core logic covered by 40+ automated tests.

PythonPandasDashSQLitepytest
Carbon footprint analysis2024 – 2025
Course project · Open data

Cleaned open datasets and applied regression models in R to analyze CO2 emissions; built interactive Tableau dashboards and a technical report.

RRegressionTableau
Automated web data collection2025
Course project · APIs

Collected data from the Rebrickable (LEGO) REST API in Python, handling pagination, and generated static HTML reports by theme from an interactive menu.

PythonREST APIHTML/CSS
GDPR compliance audit2025
Course project · Data governance

Audited the data collected in the previous project against GDPR (EU data protection) obligations, with a risk analysis and a recommendations report.

Data privacyRisk analysis
04 Education
University of Illinois Springfield2026 – 2027
Exchange year (Université Grenoble Alpes partnership) · Springfield, IL

Fall 2026 courses: Data Visualization (CSC 562), Introduction to Database Systems (CSC 472), Data Structures and Algorithms (CSC 385), Money, Banking and Financial Markets (ECO 335), Introduction to Macroeconomics (ECO 202).

IUT2 Grenoble · Université Grenoble Alpes2024 – 2027
Bachelor of Technology (BUT) in Data Science · Data Visualization & Decision Support track · expected 2027

Relevant coursework: reporting tools and business intelligence systems, SQL database design and data warehousing, data preparation and integration, automated statistical programming, hypothesis testing, linear models for decision support, factor analysis and clustering, web programming.

05 Skills
Reporting & BI
Power BI Power BI · DAX
Excel Advanced Excel
Tableau
R Shiny
KNIME (ETL)
ArcGIS Online
Programming & data
Python Python
Pandas Pandas
R R
MySQL SQL · MySQL
PostgreSQL PostgreSQL
NumPy NumPy
Matplotlib Matplotlib
VBA
Tools
Jupyter Jupyter
HTML HTML
CSS CSS
06 Documents
Resume October 2026 · PDF Open →
Cambridge B2 First English certification · score 169 · PDF Open →
Duolingo English Test English certification · score 120 · PDF Open →
07 Outside of work
Chess

1600 Elo on Chess.com; strategy and long-term planning, playing since 2021.

Strength training

Five years of consistent training, including calisthenics.

Guitar

Self-taught since 2025, weekly practice.

Contact

Let's talk.

delavoet.marius@gmail.com → LinkedIn → Resume (PDF) →