Freelancer profile translated to English.

Description

Analytics Engineer et Data Analyst avec plus de 8 ans d’expérience, j’accompagne les équipes métiers et décisionnelles dans la compréhension de leurs enjeux et la transformation des données en indicateurs fiables et actionnables.

J'interviens comme Analytics Engineer pour fiabiliser l'intégralité de la chaîne de valeur data.

-Cadrage & Analyse des besoins

-Identification des sources de données, nettoyage, transformation et modélisation

-Data visualisation

Force de proposition, rigoureux et proactif, doté d’un excellent relationnel, je travaille en étroite collaboration avec les parties prenantes afin de délivrer des analyses à forte valeur ajoutée et de soutenir la prise de décision stratégique.

Languages

French
Native or bilingual

Workplace preferences

Can work on-site

Paris (up to 50km)

Manutan
Analytics Engineer & Data Analyst
E-COMMERCE
November 2020 - Today (5 years and 9 months)
France
Context 1: Implementation of a new data platform (Azure, Snowflake, Dbt, Power BI, SQL)

o Participation in the design of a modern data platform based on Snowflake and Azure
o Identification of sources and definition of collection rules
o Design of the analytical data model
o Data integration into Azure ADLS with Fivetran
o Data transformation and modeling with dbt (bronze, silver, gold) following best practices
o Implementation of business rules (SQL, dbt, and Snowflake)
o Setup of data quality tests with dbt tests
o Documentation and traceability of transformations with dbt
o Experimentation and industrialization in a Datalab environment
o Development of complex DAX measures to meet advanced analysis needs
o Customer analysis and segmentation (RFM, customer lifecycle (New, Regain, and Retain), marketing targeting...)
o Migration of 300+ MicroStrategy reports to Power BI
o Optimization of report performance and data model structuring
o Close collaboration with stakeholders, including Data Engineering and Data Platform teams, to ensure the quality, scalability, and performance of data flows.

Context 2: Management of the Commitment 1 project rollout, with the onboarding of 6 new subsidiaries into the DWH and the deployment of a MicroStrategy reporting solution

o Scoping, source identification, and definition of collection rules
o Semantic layer design (MicroStrategy & SQL)
o Development of advanced reports for business monitoring (MicroStrategy & SQL)
o Delivery with Object Manager, testing with Integrity Manager, and management of multiple operations with Command Manager
o Administration: user and server management, and log analysis
o Run management via ServiceNow
o Report migration and modeling (Power BI, SQL)
Microstrategy Snowflake DBT Microsoft Power BI Azure Data Lake
Manutan France
Master Data Manager
January 2018 - October 2020 (2 years and 9 months)
• Execution of production tasks related to PIM product data – STEP
• Execution and validation of product reference process steps
• Creation of reports for Time to Market monitoring
• Profitability analysis
• Execute and validate maintenance process steps (PLC)
• Configuration of exports and exploration in Power BI
• Automation of maintenance to our interfaces and other systems (ERP)
• Extract discrepancies/anomalies into the ODS and ensure their distribution and correction
• Participate in process improvement
• Definition of product reference workflow management rules
• Daily support for the product marketing teams
• Pricing, analysis, and treatment of pricing discrepancies
• Ensure the display of production indicators (visual management)
Data Analysis, SQL, Data Visualization, Power BI Tale of Data PIM Step Pricing Dynamics AX
ENSOLFINA
Data Analyst
E-COMMERCE
May 2016 - December 2017 (1 year and 7 months)
• Development of complex SQL queries for product and pricing data extraction and transformation
• Data cleansing, normalization, and large-scale data enrichment
• Optimization of processing performance and SQL queries
• Data analysis: Transformation, modeling, and dataviz (Power BI)
• Project Management: ERP implementation project (OpenSI)
• Master Data Management with PIM – Akeneo
Pricing PIM Akeneo SQL Data Quality Microsoft Power BI