Freelancer profile translated to English.
Back to original languageAbout Mathias
Data Analyst, I support companies in steering their commercial performance through data collection, structuring, and analysis. I focus on defining KPIs, reporting, conversion rate analysis (contact -> response -> appointment -> closing), target segmentation, and identifying optimization levers to improve commercial effectiveness.
My goal: to transform data into clear and actionable indicators to aid decision-making, better qualify opportunities, and concentrate efforts on the most effective channels, messages, and segments.
I also develop monitoring dashboards and automated reports to provide a precise view of the pipeline, channel performance, and results evolution over time.
Tools: Excel, Power Query, SQL, Power BI, CRM (HubSpot, Pipedrive, or others), LinkedIn Sales Navigator if needed for data structuring or enrichment.
French
Native or bilingual
English
Native or bilingual
Can work on-site
Pau (up to 50km)
Experience
- Lëc MédiaBusiness AnalystCONSULTING AND AUDITSAugust 2025 - Today (1 year)Paris, FranceAnalysis of prospect needs and business challenges, qualification of opportunities, and populating the sales pipeline through multichannel prospecting (LinkedIn, email, phone). Contribution to CRO / conversion optimization offers through a structured, performance-oriented approach and relevance of opportunities.
- Brasserie AussauData Analyst / BI (Excel/Power Query & Power BI)AGRICULTUREJanuary 2026 - February 2026 (1 month)Pau, FranceData / BI mission within a brewery: automation and reliability of operational reporting from ERP exports and Excel files. Implementation of a data preparation process (Power Query) and development of steering tools for production, inventory, and forecasting.Key achievements:
- Automation of imports and transformations (cleaning, normalization, multi-source consolidation) via Excel / Power Query
- Development of monitoring tables and operational dashboards (raw materials/finished goods inventory, needs, forecasting)
- Implementation of alert indicators (minimum stock levels, risk of shortage, missing items) and consistency check rules
- Production of steering reports/dashboards (Power BI / Excel): stock KPIs, consumption, needs, variances, periodic monitoring
- Documentation and iterations with the team to make the tool simple, robust, and maintainable
- Volt CafeData & Automation ConsultantAGRICULTUREMarch 2025 - April 2026 (1 year and 1 month)Capbreton, FranceData structuring, automation, and steering mission for a retail/restaurant company. The objective was to ensure reliable financial and operational monitoring by automating the collection, transformation, and exploitation of data from management tools.Interventions carried out:
- Retrieval and structuring of accounting and operational data
- Automation of data flows to limit manual operations
- Data transformation and cleaning with Power Query
- Implementation of monitoring tools for treasury and activity management
- Creation of clear reports to facilitate indicator reading and decision-making
Result:More reliable, faster, and clearer monitoring, with an automated working base allowing for better daily activity management.Tools: Excel, Power Query, Power Automate
Reviews
T
Tomasz
Truck1 Sp. Z O.O.
Reviewed on 1/31/2023
Great job!
Guillaume
Guimzu
Reviewed on 7/31/2023
Recommendations
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Professional Data Analyst Certification (RNCP level 6/ Bachelor's degree +3-4)OpenClassrooms2026Formation Data Analyst (OpenClassrooms) : collecte et préparation de données (CSV/Excel, parfois open data), nettoyage et transformation des données, contrôle qualité, analyse exploratoire (statistiques descriptives, corrélations, détection d’outliers), requêtes SQL (jointures, agrégations) et bases de données (ex : PostgreSQL), data visualisation et création de reportings/dashboards, analyse multivariée (ACP) et segmentation (clustering : CAH, k-means), initiation au machine learning supervisé (classification : régression logistique, KNN, Random Forest) avec évaluation des performances (matrice de confusion, précision/recall), et restitution des résultats avec recommandations pour un public non-tech. Outils principaux : Python (pandas, matplotlib, scikit-learn), SQL/PostgreSQL, Excel/Power Query et Power BI.
- BTS, Management of Commercial UnitsFormaDKLé2020BTS, Management des Unités Commerciales
Certifications
- Digital MarketingGoogle2020