Freelancer profile translated to English.

Back to original language

Description

Average daily rate → €520 net

In the description:

Data Analyst – 8 years of experience (Pricing, Data Quality, Master Data)

Work-study Carrefour (2024-2025) → BigQuery, Python, Streamlit, RPA, executive dashboards

Stack: SQL · Python · Power BI · Looker · Snowflake · Alteryx · GCP · Salesforce · SAP

Displayed daily rate: €520/day

→ Flexible €500 – €580 depending on duration and mission interest

Immediately available – short or long missions

Industry field of expertise

Languages

French
Native or bilingual
English
Conversational

Workplace preferences

Can work on-site

Paris (up to 50km)

CARREFOUR
Data Analyst Pricing
RETAIL (LARGE RETAILERS)
October 2024 - October 2025 (1 year)
Massy, France
• Analysis of customer verbatim and NPS via generative AI (Gemini, NotebookLM) with prompt engineering techniques to identify customer satisfaction insights
• Analysis of Distriprix indices (A3Distrib) to establish the price positioning of Carrefour Drive and LAD compared to competing brands (pricing strategy)
• Development of a Python linear regression model to predict missing LAD indices from Drive indices, enabling the creation of a standardized Drive-LAD index covering 100% of sales points
• Monthly automation of Drive-LAD index calculation via Jupyter Notebook (processing time reduced by 4h30) and visualization via Streamlit (Python)
• Data extraction and transformation via complex SQL queries in BigQuery (GCP) and Python (pandas, numpy, beautifulsoup4) on Google Colab and Anaconda
• Creation of interactive dashboards consulted by management with Looker and Google Sheets for customer "comparison basket" studies and specific campaigns.
• Development of an RPA robot with UIPath Studio in collaboration with GitLab to automate LAD price exports, saving 2h30 per day and deployed in production on VM
• Management and resolution of Jira tickets related to pricing errors with SLA < 48h
• Creation of visual technical documentation (draw.io, dbdiagram.io) and training of the new work-study student
Python SQL Git etl-processes exploratory-data-analysis
BERGERAT MONNOYEUR
Data Analyst Pricing
CIVIL ENGINEERING
February 2024 - September 2024 (7 months)
Saint-Denis, France
• Data extraction and transformation via SQL (DB2) and data profiling with Power Query
• Creation of Power BI and Excel reports (PowerPivot, PivotTable) for revenue reporting by activity/customer and commercial discount allocation
• Industrialization of data transformation processes via Access in preparation of the pricing band
• Management of the bi-annual pricing band review impacting €3M of annual revenue by global analysis of the repercussions of price increases/decreases by category using the following key performance indicators (KPIs): margin rate / variation rate / profitability / price elasticity / price variation coefficient (BM vs CAT)
• Management of backward margins with Caterpillar support and automatic imputation of credit notes via Power Automate
• Configuration of promotional operations in AS400 and resolution of order price blocks
PowerBI SQL etl-processes
NEWELL MAPA SPONTEX
Data Quality & Master Data Manager (Fixed-term contract)
RETAIL (LARGE RETAILERS)
October 2022 - October 2023 (1 year)
92700 Colombes, France
• Creation and enrichment of 2,000+ product sheets and logistical data in AS400 and SAP
• Reporting of missing and erroneous logistical data via Excel, Access, and Power BI
• Maintenance and evolution of the "Codification Workflow" application (PowerApps, Power Automate, SharePoint)
• Update of the France multi-channel purchase and sale price list (retail + professional) in SAP: application of inter-company prices, trade, cascading discounts, and market prices
• Simultaneous training of 2 replacement employees, ensuring service continuity
PowerBI bi-strategy PowerBI bi-strategy PowerBI