Sidi A.

Within the DATA team of the group's technical department, my role is part of a finance-contract data squad. The scope of this team includes providing the necessary data for financial reporting (sales), commercial steering, and sales-related variable compensation. ROLE / ACTIVITY: ◼ Participate in the development of user stories in collaboration with Product Owners. ◼ Design and maintain analytical models via dbt ◼ Create and maintain dags on Cloud Composer / Airflow ◼ Optimize the performance and costs of processing. ◼ Participate in the selection of tools and technical solutions on GCP ◼ Creation of clear and consistent KPIs ◼ Enhance data quality observability and monitoring with Elementary ◼ Industrialize the deployment of data products with CI/CD. ◼ Document technical and functional processes on data products via Confluence. ◼ Participate in the creation of Prototypes on RAG applications.

As part of the BETIQ "Beauty Engagement Touchpoints" project, I was involved in setting up the data warehouse and reporting system for monitoring and measuring the performance of marketing campaigns. ROLE / ACTIVITY: ◼ Define business needs and identify use cases in collaboration with data product owners (DPOs) to create functional specifications for marketing campaign tracking. ◼ Collect online and offline data sources for the creation and modeling of datasets and tables used in BigQuery analysis according to the medallion architecture. ◼ Create different cubes/datamarts for various business stakeholders (online + offline). ◼ Industrialize and automate data processing pipelines (ELT) via CI/CD. ◼ Create reports/dashboards containing KPIs for the different marketing teams. ◼ Detect and correct anomalies in marketing campaigns. ◼ Onboard DPOs for skills development in reporting production. ◼ Develop functional/technical documentation materials with code production on the data warehouse and reporting.

CONTEXT: Within the Data Cloud Solutions team, my role was to participate in the design and development of the "Data Insight" platform to analyze the ROI on marketing campaigns and cosmetic product sales. ROLE / ACTIVITY: ◼ Analyze business needs and design the technical architecture for various use cases from different business teams. ◼ Create, orchestrate, and deploy processing (ELT) pipelines for data modeling in the data warehouse. ◼ Predict and estimate expenses/quantities/ROI of advertising campaigns. ◼ Perform ad-hoc analyses and product segmentation for marketing/sales teams. ◼ Create reports and dashboards on business KPIs. ◼ Automate infrastructure provisioning and deployment (IaC) with a continuous improvement approach via CI/CD. ◼ Document developments according to organizational standards. ◼ Work in Agile Scrum mode.