Freelancer profile translated to English.
Back to original languageAbout Louis
Analytics Engineer/Senior Data Analystwith over 5 years of experience, specializing in building, structuring, and ensuring the reliability of data pipelines for analytical and product use cases.
I work across the entire data chain: multi-source ingestion (APIs, events, files, existing databases), data transformation and modeling (dbt), job orchestration (Airflow, Spark), up to the creation of analytical tables usable in production by Product and Business teams.
My work focuses on data quality and maintainability: clear and shared definition of metrics, source traceability, documentation, and consistency checks. The goal is to ensure that the indicators used are reliable, understandable, and correctly interpreted.
I also support Product and Business teams on analytics topics: KPI monitoring, A/B test setup and analysis, behavioral analyses, and dashboard creation.
My background has allowed me to work in data environments with varying levels of maturity, from structuring emerging stacks (startups, public sector) to optimizing established data platforms (large corporations). I bridge the gap between technical constraints and functional needs, in close collaboration with Product, Tech, and Data Platform teams.
Main Stack: SQL, Python, dbt, Airflow, Spark/PySpark
Cloud & Infrastructure: AWS (Athena, S3, Glue), GCP (BigQuery, Cloud Functions), Terraform
Visualization: Tableau, Metabase, Quicksight
French
Native or bilingual
English
Fluent
Spanish
Native or bilingual
Portuguese
Conversational
German
Conversational
Can work on-site
Paris (up to 10km), Tours (up to 20km)
Experience
- KoletAnalytics EngineerTELECOMMUNICATIONSFebruary 2026 - Today (4 months)Paris, FranceeSIM B2B2C startup (traveler connectivity) – Freelance missionTransition mission on a production data stack (BigQuery / dbt / Metabase), following the departure of the historical builder. Role focused on run, ensuring the reliability of the analytical layer, and preparing for takeover by the new Head of Data.Involved in critical models used by Finance, Operations, BizDev, and CRM teams.DATA MODELING & ARCHITECTURE- Maintenance and evolution of dbt models for revenue, network costs, data consumption, and margin scopes- Refactoring towards a more robust architecture (staging, intermediate, marts): clarifying grains, stable keys, reducing fragile joins- Harmonization of heterogeneous sources: payments, B2C/B2B revenue, network costs, partner data, eSIM- Optimization of BigQuery performance and costs (incremental models, partitioning)- Development of dbt macros to factorize recurring logic- Documentation of models, business rules, and financial indicatorsDATA QUALITY & RELIABILITY- Implementation of dbt tests and consistency checks on critical models- Implementation of snapshots and monitoring of source freshness (monitoring & alerting via GitHub Actions)- Financial reconciliations: internal revenues vs. payment exports, internal costs vs. supplier invoices, variance analysisBI & REPORTING- Creation and maintenance of Metabase dashboards for operational and financial steering**Stack**: SQL, dbt, BigQuery, Airbyte, GitHub Actions, Metabase, Git
- Le Bon CoinSenior Data Analyst / Product Analyst - Real Estate VerticalE-COMMERCEJune 2025 - January 2026 (7 months)Paris, FranceFreelance mission as a product-oriented Senior Data Analyst for theReal Estatevertical of the leboncoin group, providing analytical support to Product and Tech teams.Involved in several strategic feature teams (Maps, Rental, Buyer/Seller), covering the entire real estate journey, with the goal of steering product performance, ensuring reliable KPI interpretation, and supporting decision-making.ANALYTICS & PRODUCT
- Definition and reliability of product KPIs: structuring business needs, documenting definitions, identifying biases and limitations
- Setup and analysis of A/B tests with Spotify Confidence: scoping, creation of experiment metrics, results analysis
- Behavioral analyses of user journeys and support for product decision-making
- Data referent for tagging plans (Piano Analytics): validation of specs, quality control of events
- Design and maintenance of Tableau dashboards in production
DATA ENGINEERING- Creation and modeling of analytical tables in production (fact tables, aggregated metrics for A/B tests)
- Development of Airflow DAGs with Spark jobs for populating dashboards and experiments
- Coordination with the Data Platform Engineering team for enriching analytical sources (defining and validating specifications)
**Stack**: Python, SQL, Spark, AWS Athena, Airflow, Tableau, Piano Analytics, Spotify Confidence. - Beta-GouvAnalytics Engineer | Data Analyst - Public Commons for Ecological Transition of Local AuthoritiesPUBLIC SECTORNovember 2024 - June 2025 (7 months)Paris, FranceMission within a public program aimed at simplifying the digital ecosystem for the ecological transition of local authorities, particularly through service interoperability and data schema alignment.Data Engineering & Analytics Scope
- Design and management of acentralized database, integrating projects from heterogeneous sources(CSV, APIs, existing databases)
- Development of acustom ELT pipelinefor data extraction, loading, and transformation
- Data modeling and standardization with dbt to ensure consistency, quality, and analytical usability
- Implementation of quality controls and structuring of analytical tables used in production
- Design ofMetabase dashboardsfor project steering and analysis
GenAI Component Integrated into the Data Chain- Development of anautomatic classification toolfor projects according to two business taxonomies (ecological transition levers, local authority competencies), based on aLLM with a Python backend
- Iterative development from a POC: prompt engineering, evaluations with business experts, user testing
- Implementation of anautomated post-processing step in Pythonto check the quality and relevance of classifications
- Deployment of aproduction application(React module integrated into collaborative tools like Grist)
- Provision of asingle classification APIand abatch processingcapability for categorizing large volumes of projects
This mission combineddata pipeline construction, analytical modeling, and reliable data exposurefor operational and decision-making uses in a public context.**Impact**: Data platform and classification tool used in production by local authorities to facilitate access to digital services for the ecological transition.
Reviews
Recommendations
FU
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
- Engineering Degree (Applied Mathematics, Computer and Data Science)École Centrale de Lyon2019Diplôme d'ingénieur généraliste Majeur : Mathématiques et Décisions Mineur : Business Development Major : Data Science, Applied Mathematics and Risk Engineering Minor : Business development, Entrepreneurship
- Bachelor's degree, Applied mathematicsUniversité Paris Dauphine2015Licence de Mathématiques appliquées, option Economie-Finance-Actuariat Bachelor's degree in applied mathematics Studied clases : Probability and measure theory , Optimisation , Inferential and test statistics , functional analysis, differential equations, micro-economics, derivatives and risk management, numerical analysis