Adam Jouini

Assistant Data Analyst @Publicis Media

Ville de Paris, FR

Publicis Group is the second largest communications group in the world and a leader in marketing, communication, and digital business transformation.As a Data Analyst Apprentice at Publicis Media, I contribute to the development and automation of data-driven marketing solutions for major brands, leveraging Python, SQL, Excel to optimize campaign performance and streamline workflows. Key Contributions:• Automated data processing by developing Google Cloud Functions in Python, integrating client product data (Samsung, Castorama) into BigQuery and applying rule-based filtering via Firebase.• Conducted ad hoc marketing analysis for Bouygues Telecom, using Excel & Python to extract insights and improve advertising strategies.• Managed Amazon Marketing Cloud (AMC) queries, extracting raw data and creating custom audience segments using SQL.• Led data analysis projects for L’Oréal, including full-funnel analysis and buyer recruitment studies, translating results into actionable PowerPoint reports.• Designed and built an internal React module to automate Excel data processing and generate ready-to-use visualizations, enhancing efficiency for internal teams.This experience allows me to work at the intersection of data engineering and marketing analytics, combining technical development, data-driven insights, and automation to optimize digital advertising strategies.