Emmanuel Rambeau

🔽 Reporting to the Head of Data / COMEX, I am building the steering dashboard to monitor the migrations of the CARL BU (industrial software packages) to SAAS.

🟢 Gathering requirements and writing specifications (contract data, objectives, version tracking, etc.)

🟢 Creating the data pipeline (T-SQL procedures) to retrieve necessary data monthly

🟢 Data modeling in SQL and implementation of KPIs / business rules.

🟢 Data visualization on PowerBI

🔽 Reporting to the Customer Support Directorate, I am building the steering dashboard for customer support data analysis for the COMEX.

🟢 Gathering requirements and writing specifications (front-office and back-office flows, ticket stock analysis, productivity)

🟢 Creation and validation of data visualization mockups (Miro)

🟢 Creating the data pipeline (T-SQL procedures) to retrieve necessary data daily in delta

🟢 Data modeling in SQL. Pilot project on a medallion architecture (Bronze, Silver & Gold).

🟢 Advanced data visualization on PowerBI

🔽 Reporting to the Marketing team, I analyze advertising data and support the transition to a modern data stack.

🟢 Visualization of Marketing Ads data across 20 markets, with 1 to 10 brands per market, from 15 sources (Meta, TikTok, Google, YouTube…), at the Campaign, Adset, and Creative level as needed, via Marketing Cloud Intelligence or PowerBI.

🟢 Coordination with international agencies (USA, Vietnam, Germany…) to define taxonomy rules and ensure data quality and consistency.

🟢 Contribution to the selection and deployment of a new tool to replace Marketing Cloud Intelligence.

🟢 Management of the migration from Marketing Cloud Intelligence (all-in-one solution) to a modern stack: Adverity (ingestion), BigQuery (modeling), PowerBI (visualization), resulting in a threefold reduction in marketing data infrastructure costs.

🔽 Data Project Manager within the IT department, I support 4 brands (Etam, Maison 123, Undiz, Livy) in managing and analyzing their data, ensuring the consistency of visualizations and simplifying access to key information.

🟢 Restoration of Tableau dashboards that were no longer functioning due to excessive data volume - Data feed optimization

🟢 Coordination and synchronization around a unified design, ensuring data access rights management.

🟢 Audit of the data retrieval and analysis mechanism (SQL SAP HANA, Tableau Software Viz), identifying issues that hindered data analysis

🟢 Structuring data feeding processes for Data Analysis, implementing the Python / Prefect stack to aggregate data before exploitation in Tableau

🟢 Data manipulation and validation in SQL - SAP Hana then Snowflake

🟢 Project Management: Prioritizing brand needs, planning and monitoring project execution, with regular adjustments based on strategic objectives.

🟢 Creation of the first pipelines for Data Analysis, data modeling for Email or SMS marketing campaigns

🟢 Implementation of data integration solutions in Python/Prefect and management of Tableau Server rights and licenses.