Ayoub B.

Establish a data lake within Servier's R&D department to facilitate data experimentation for biologists, chemists, and pharmacologists in the lab. Responsible for a project to collect and clean in-vitro data from external laboratories for ingestion into Servier's data hub.

● Conduct a POC and MVP for the Cro-Partner application

● Create pipelines that feed BigQuery tables for PowerBI reports

● Build and maintain robust and scalable data pipelines to feed our Data Lake and Data Warehouse

● Contribute to design workshops, code reviews, scrum meetings, and technical problem-solving.

Implement data pipelines orchestrated by Airflow to retrieve flat files containing user reviews of Renault dealerships in all countries where Renault operates. These pipelines ingest this data and make it available to the data platform teams. The teams can then use this data and generate reports on DataStudio to facilitate decision-making. The mission therefore consists of creating a solid infrastructure for collecting and processing this data to improve the company's commercial performance.

● Identify data sources

● Implement a scalable data processing pipeline, including ingestion, storage solution, calculations, volumes, and performance

● Implement and automate CI/CD pipelines on GitLab

● Contribute to design workshops, code reviews, scrum meetings, and technical problem-solving.

Provide solutions that meet the operational needs of BI and Data Science teams by enabling quick and efficient access to data stored in the Snowflake data warehouse, using the modern ELT (Extract, Load, Transform) architecture to ensure data quality and relevance, while automating task execution using Airflow to ensure efficiency and productivity of data processing operations.

● Mentor junior developers to improve their data development skills

● Provide the BI team with data related to the acquisition costs of different advertising platforms stored in Snowflake

● Extract B2B Sales data from the Zoho Desk API and store it in Snowflake tables via S3

● Implement Poetry for all Python projects in the Data Engineering team

● Analyze anomalies and produce deliverables to ensure data quality and relevance by identifying and correcting anomalies.