Nicolas PLANCHON

Business Analyst & Data Analyst | PMO

Salary / Daily rate

Paris, France

Freelance

Can come onsite

Skills

SQL QueriesTableauProduct ManagementData EngineeringScrapingHRProduct StrategyData VisualizationPower BILookerData MiningETLBig DataData ScienceData AnalysisFinanceNotionStrategy & ConsultingTalent Acquisition

Languages

French (Native)English (Native)Spanish (Native)Turkish (Fluent)

About me

Intro

Business Analyst/Analytics Engineer acting as Chief of Staff Graduated from EDHEC and Centrale Lille 4+ YoE in Business Analysis (PowerApps, Tableau, Databricks; SQL, Python, Spark) 1 YoE in top tier strategy consulting

Links

Work experience

Business Analyst/Analytics Engineer acting as Chief of Staff

Airties

Mar 2022 - Present

4 years 8 months

İstanbul, Türkiye

Strategy Consultant

Strategy&

Mar 2021 - Mar 2022

1 year 1 month

Casablanca, Morocco

Data Engineer

Geoblink

May 2018 - Sep 2018

5 months

Madrid Area, Spain

Recently selected by Bloomberg as one of the 50 most promising startups in the world, Geoblink is a SaaS-based location intelligence solution that helps companies (in sectors such as Retail, Real Estate and FMCG) make informed business decisions that concern location. It combines advanced analytics and big data, together with a rich map-based UI to display multiple types of statistics in a way that is simple to use and easy to understand. Responsible for data acquisition through web-scraping. Skillset: - Python (BeautifulSoup, Selenium); - Javascript; - SQL.

Data Analyst

Deezer

Sep 2017 - Mar 2018

7 months

Paris Area, France

Deezer is the first music streaming service created in the world in 2007 in Paris, France. In 2018 Deezer is the #3 biggest music streaming service in the world. In the Data Analytics team I was responsible for providing analysis and dashboards to various teams and was the dedicated person for every issue regarding the PR teams on the global scale. Daily working on a Hadoop 2 ecosystem (mainly SQL related Hive, Spark also). Dataviz with Tableau and extensions.

General Assistant

Joliette Art Museum

Jun 2017 - Aug 2017

3 months

Joliette, QC, Canada

The Joliette Art Museum is recognized as Quebec’s most important art museum outside of the major cities. While pursuing the objectives of conservation, dissemination and research established over half a century ago by its founders, the Musée continues to expand its permanent collection, which currently comprises some 8,500 works held in four collections: Canadian art, European art, contemporary art and archaeology. At the same time it offers a wide range of programmes structured around the promotion of its permanent collection and the presentation of temporary exhibitions, as well as a host of educational and cultural activities for visitors of all ages. In the 'Administration' department I have been responsible for planning activities, exhibitions and other events in the museum till December 2017. In the 'Education' department I have been responsible for taking care of the day camp (55 children, 70 activities). In the 'Visitors' department I have been responsible for visitors welcome and museum monitoring.

Ed'Express, the hitchhiking race

Dec 2015 - Jun 2017

1 year 7 months

Lille Area, France

President

May 2016 - Jun 2017

1 year 2 months

Lille Area, France

Ed'Express, the hitchhiking race is the biggest student hitchhiking race in Europe. 2017 edition => Paris-French Riviera (by plane) -> French Riviera -> Chiavari, Italy -> Milano, Italy -> Venezia, Italy -> Bohinjska Jezera, Slovenia -> Ljubljana, Slovenia -> Pag Island, Croatia -> Plitvice Park, Croatia -> Split, Croatia - Managed a 32 person team to set up the biggest student hitchhiking race gathering 70 participants during 10 days across Europe (8 stages, 4 countries, 1500 km of hitchhiking); - Increased of 450% in the yearly budget; - Negotiated deals with key accounts (Air France, Salesforce, Henkel, LCL, Boursorama, Fortuneo, Bret's, La Potagère...); - Legal status reorganization hand in hand with a lawyer and the French administration; - Management of every interaction with authorities across Europe to make our event safe; - Cleaning of the financial situation; - Change in the organization (switch from a functional structure to a project oriented structure); - CRM implementation with accountancy integrated (Salesforce+Numm); - Creation of a brand new event to promote hitchhiking on a shorter timespan (48 hours); - First outsourced departure of the race on the French Riviera;

Logistics Manager

Dec 2015 - May 2016

6 months

Lille Area, France

Responsible for the 2016 edition route. 2016 edition: Lille, France -> Bouillon, Belgium -> Luxembourg -> Strasbourg, France -> Konstanz, Germany -> Munchen, Germany -> Heiligenblut, Austria -> Ljubljana, Slovenia - Management of a 12 person team to set up the route of our hitchhiking race gathering 60 persons during 8 days across Europe (7 stages, 6 countries, 1200 km of hitchhiking); - Creation of the route; - Designing of the bill of specifications for my team; - Budget management to build the best event possible; - Event operational management: planning management -participants welcome, accommodation mangement on a daily basis, catering, sweeper cars management, safety management; - Built a GPS tool to ensure the safety of our participants; - Designed the association website; - Designed an e-commerce platform to improve the registrations;

Buy Side Intern

Leroy Merlin España

May 2016 - Aug 2016

4 months

Madrid Area, Spain

Leroy Merlin is a French headquartered home improvement and gardening retailer serving several countries in Europe, Russia, Asia, South America and Africa. Generally established on the outskirts of major towns and cities, Leroy Merlin stores are large centres (9000 m² on average) providing self-service and sales assisted services. The company is mainly focused on: DIY, gardening, building, sanitary equipment and interior decoration. In the Buy Side department, I have: - Revised a whole range of ceramic products and reported errors to more than 20 providers; - Monitored the fixes done by our providers; - Implemented a brand new range of ceramic products for the 2016 autumn term;

EDHEC Sailing Cup

Apr 2016 - Apr 2016

1 month

Roscoff, France

Logistics manager

Apr 2016 - Apr 2016

1 month

Roscoff, France

The EDHEC Sailing Cup is the European biggest student regatta. - Built a 20 000 m² village gathering 10 000 visitors and 3 000 participants; - Monitored the village and the lifeplaces for the event hand in hand with our service providers.

Head Commission

Apr 2016 - Apr 2016

1 month

Roscoff, France

The EDHEC Sailing Cup is the European biggest student regatta. The Head Commission is the crisis centre of the EDHEC Sailing Cup. - Live supervision of 100 organizers; - 1500 P+ party management (entrances, safety, video controlling, radio transmission system); - Collaboration with the police and our security company to maintain a very high level of safety during the event.


Education

Bilkent University

Full year exchange program, Finance

2019 - 2020

1 year 2 months

Centrale Lille

Master in Engineering, General Engineering, Mathematics, Algorithmics, OO programming, Mechanics, Thermodynamics

2015 - 2020

5 years 2 months

EDHEC Business School

Master in Management, Management, Corporate Finance, Statistics

2015 - 2020

5 years 2 months

Activities and societies: Représentant des élèves auprès de l'administration de l'école

CPGE Gay Lussac

Intensive preparation courses for top business schools

2012 - 2015

3 years 2 months

Grade: Vice-valedictorian

Activities and societies: Fondateur de l'association Alumni GayLu, création d'un site web support de l'association.


Licenses & certifications

TOEIC - 970

Issued: Mar 2019

-

MOOC Deep Learning

Issued: May 2018

Certified by Conservatoire National des Arts et Métiers

MOOC Hadoop Platform & Application Framework

Issued: Apr 2018

Certified by San Diego Supercomputer Center

MOOC Gestion de Projet avancée

Issued: Oct 2016

Certified by Centrale Lille

MOOC Fondamentaux du Big Data

Issued: Sep 2015

Certified by Institut Mines-Télécom (IMT)

MOOC Géopolitique de l'Europe

Issued: Apr 2015

Certified by Sciences Po

MOOC Espace mondial

Issued: Apr 2015

Certified by Sciences Po

Upper Intermediate Level - English as a foreign language

Issued: Aug 2013

Certified by Chichester College

The best place to find your next move

© 2026. All Rights Reserved.