Freelancer profile translated to English.

Description

🎯 Experienced Data Analyst specializing in statistical analysis, data structuring, and interactive data visualization.

I help companies build reliable data pipelines and analytically enhance their data for faster, more informed decision-making.

With a background in Chemical Engineering and a degree in Data Science, I combine scientific rigor, data acumen, and technical mastery of modern analysis tools: Python, R, SQL, BigQuery, dbt, Streamlit, Looker Studio, Airflow, Dataiku.

---

🧠 What I offer:

🔹 Data Structuring & Reliability: integrating heterogeneous sources (APIs, CSVs, databases, datalake...), cleaning and transforming data using Python (Pandas, NumPy) or R (tidyverse), implementing automated pipelines with ELT (dbt) and Airflow.

🔹 Advanced Modeling & Analysis: statistical studies (correlations, ANOVA, mixed-effects models), supervised/unsupervised learning (classification, clustering, NLP), model evaluation and interpretation.

🔹 Data Visualization & Reporting: creating interactive dashboards with Looker Studio, Tableau, Streamlit, designing scientific visualizations (ggplot2, Plotly), automated reporting connected to BigQuery.

🔹 Industrialization & Performance: optimizing SQL queries, historization on BigQuery, managing flows and orchestration with Airflow, cloud deployment (AWS, GCP). Developing pipelines on Dataiku.

---

📊 I work in various contexts:

Health & Clinical Research: structuring and analyzing scientific studies

Finance & ESG: ensuring the reliability and dissemination of sustainable performance indicators

General Data Analytics: exploration, reporting, and automation

💡 Goal: Transform your raw data into robust analytical systems and actionable insights, by combining statistics, algorithms, and data engineering.

Industry field of expertise

Languages

French
Native or bilingual
English
Fluent

Workplace preferences

Can work on-site

Marseille (up to 50km)

ARKÉA ASSET MANAGEMENT
DATA ANALYST
BANKING AND INSURANCE
September 2022 - September 2025 (3 years)
Brest, France
Design, development, and maintenance of a comprehensive tool for calculating and disseminating extra-financial (ESG) indicators.
The objective: to centralize, validate, and automate the management of data used in ESG reporting and analysis.

🔹 Development and automation of ESG indicator calculation

Implementation of a data processing and calculation pipeline from multiple sources (APIs, flat files).
Orchestration and scheduling of processes via Airflow and internal ELT (dbt type).
Creation and maintenance of complex SQL queries for aggregation, filtering, and historization of data on BigQuery.

🔹 Data environment organization and architecture

Structuring the BigQuery data warehouse and defining analytical data models.
Development of internal data management tools and technical documentation of flows.
Support for business teams in understanding, visualizing, and interpreting ESG data.

🔹 Visualization & insight dissemination

Creation of dynamic dashboards in Looker Studio, directly connected to the data warehouse.
Implementation of automated reports for internal and external dissemination of extra-financial indicators.

🔹 Innovation & Data Science

Execution of Proofs of Concept (POCs) for integrating Dataiku as an internal data analysis and modeling platform.
Statistical and inferential analyses on financial and extra-financial topics (correlations, regressions, explanatory models), with a focus on exploration, quality, and understanding of data in a rapidly evolving field.

Stack: Python • SQL • BigQuery • Airflow • Dataiku • Looker Studio • ETL • API • Pandas • NumPy

Data Analyst, Data Pipeline, ESG, BigQuery, Airflow, Dataiku, Python, SQL, Data Visualization, Docker, Looker Studio, Automated Reporting, Statistical Analysis, Data Cleaning
Python Big Query Looker Studio Airflow Dataiku DSS
Laboratoire Interuniversité de Biologie de la Motricité
STUDY MANAGER / DATA ANALYST
RESEARCH
July 2020 - July 2022 (2 years)
Saint-Étienne, France
Participation in the structuring, analysis, and valorization of clinical data within a research laboratory affiliated with a University Hospital Center.
Collaboration with research teams, PhD students, and professors to transform raw data into actionable and publishable results.

🔹 Data cleaning and structuring

Processing large datasets from flat files (CSV) and MySQL databases, preparing them for statistical analysis.
Development of scripts in R and Python for data cleaning, transformation, and quality improvement (data cleaning & structuring).

🔹 Exploratory analysis and statistical modeling

Conducting univariate, bivariate, and multivariate analyses to understand observed phenomena.
Design of statistical models: correlations, ANOVA, significance tests, mixed-effects models, inferential analyses, and scientific interpretation.

🔹 Data visualization and scientific reporting

Creation of clear and rigorous visualizations in R (ggplot2, RStudio).
Writing study reports, interpreting results, and contributing to the writing of published scientific articles.
First author on one publication and co-author on several peer-reviewed studies.

🔹 Collaboration & support

Assisting in structuring study protocols and in the statistical understanding of results for researchers.
Popularization of complex analyses and interdisciplinary communication between scientific and technical teams.
📚 Scientific Publications: https://www.researchgate.net/profile/Franck-Le-Mat

Stack: R (RStudio, ggplot2) • Python • SQL • MySQL • Pandas • Data Cleaning • Statistical Modeling • Data Visualization

Data Analyst, R, Python, SQL, MySQL, Data Analysis, Data Cleaning, Data Structuring, Statistical Modeling, ANOVA, Visualization, ggplot2, Scientific Publication, Clinical Studies.
RStudio MySQL Scientific Article Writing Python Statistical Analysis