Freelancer profile translated to English.

Description

Analytics Engineer with 8 years of experience, specializing in data engineering and expert in data modeling, transformation, and pipeline optimization. Focused on performance and data quality, I combine technical expertise with strategic vision.

Industry field of expertise

Languages

French
Native or bilingual
English
Native or bilingual
Spanish
Fluent

Workplace preferences

Can work on-site

Paris (up to 50km)

L'ORÉALGROUP
Analytics Engineer
March 2023 - February 2025 (1 year and 11 months)
Clichy, France
CONSUMER PRODUCT DIVISION
Designed a comprehensive analytical solution with Google Cloud Platform for ETL and pipelines, and Power BI (consolidating multiple dashboards within one application) for detailed on-demand data analysis for the Budget Media, Advocacy & Influence, and Data Collection & Websites teams.
Modeled and integrated Google Analytics and CRM data into Power BI (via GCP) to track traffic, conversion rates, and user journeys.
Centralized expenses and rules of engagement within the Media dashboard to increase budget efficiency by 40% through better media spend allocation.
Ingested social media API data into GCP and designed a Power BI dashboard allowing CPD division brands to monitor their position in the global beauty market.

LUXE DIVISION

Optimized the data model in BigQuery to prevent the global database from slowing down Power BI data loading.
Optimized Power BI report performance (model compression, DAX optimization for a 50% reduction in loading time).
Wrote detailed documentation within Confluence (semantic model architecture, explanation of DAX measures and calculated KPIs, user guide to facilitate dashboard adoption).
Capgemini
Data Consultant
May 2022 - May 2023 (1 year)
Issy-les-Moulineaux, France
BNP PARIBAS
Optimized the semantic model and Power BI designs, leading to a 60% growth in dashboard adoption rate through an intuitive interface that meets business needs and optimized DAX measures for reduced data loading time.
Optimized Talend workflows and parallelization to decrease data processing time by 40% (Talend Data Profiler, identification of long sequential tasks, removal of redundant tMaps, addition of tParallelize to reduce extraction waiting time).
MINISTERE DES ARMEES

Designed and developed a QlikView model for integrating confidential SAP data into an interactive dashboard.
Normalized and structured data using QlikView Scripting.
KLINT
Data Consultant
January 2020 - February 2022 (2 years and 1 month)
Levallois-Perret, France
AIR CARAIBES
Extracted, transformed, and cleaned data using TALEND and managed flows via GitHub as part of a data migration from multiple sources (various databases, flat files, and APIs).
Ingested migration data into Snowflake, managed resource consumption using Snowflake Resource Monitors, and adjusted clusters via Snowflake Query Profiling.
CCI ILE DE FRANCE
Designed Power BI dashboards for migration project management to visualize project stages, timelines, and alerts using Power Query and Jira.
Designed an automated data cleaning process for migration data using Python (Anaconda IDE).