Jonathan Makonnen

Expert Analytics & Data visualisation

Moves to Paris, Paris

  • 48.8546
  • 2.3477
  • Indicative rate €700 / day
  • Experience 2-7 years
  • Response rate 100%
  • Response time 4h
Propose a project The project will only begin when you accept Jonathan's quote.

Availability not confirmed

Propose a project The project will only begin when you accept Jonathan's quote.

Location and geographical scope

Location
Paris, France
Can work in your office at
  • Paris and 50km around
  • Paris and 10km around

Preferences

Project length
  • ≤ 1 week
  • ≤ 1 month
  • Between 1-3 months
  • Between 3-6 months
  • ≥ 6 months
Company size
  • 1 person
  • 2 - 10 people
  • 11 - 49 people
  • 50 - 249 people
  • 250 - 999 people
+2 autres

Verifications

Languages

  • Espagnol

    Full professional proficiency

  • Anglais

    Full professional proficiency

  • Français

    Native or bilingual

Categories

Skills (23)

Jonathan in a few words

Diplômé d'ESCP Europe, je travaille depuis +5 ans dans le secteur de la data.
Fort d'expériences acquises au sein de différents types de structures (agence, annonceur, prestataire technologique) et de différentes tailles (startups & grands groupes) dans le secteur digital, je souhaite aujourd'hui mettre à disposition mon expertise aux marques afin de les aider à mieux capitaliser sur leurs données et optimiser leur marketing digital. J'exerce auprès de tout types de structures (startups, grands comptes, PME, agences...).

Au cours de mes expériences, j'ai été amené à développer une expertise sur un grand nombre de problématiques et d'outils liés à l'usage de la donnée :
- Web Analytics : Google Analytics, AT Internet, Content Square
- Product Analytics : Amplitude, Mixpanel
- Data Visualization : Tableau, Data Studio, Metabase, Looker
- Data Collection : Google Tag Manager, Segment, Adobe
- Data Processing : Google BigQuery, Amazon Redshift, Snowflake
- Data Activation : SEA, Facebook Ads, RTB, Display, Retargeting
- Web & Mobile attribution : Eulerian, Mazeberry, Adjust, Appsflyer, Tune, Kochava
- Data Analysis : SQL, Python

J'apprécie notamment travailler en collaboration avec les équipes marketing et produit afin de les accompagner sur des problématiques d'acquisition, de rétention, d'engagement et de conversion.

Experience

MKN Data

Consulting & Auditing

Freelance Data Analyst

Paris, France

January 2020 - Today

- Data Collection : KPIs definition, tagging plan, tool configuration
- Data Storage & Processing on cloud-based data warehouses (BigQuery, Snowflake...)
- Data Analysis on business related-topics using SQL, Python or analytics tools (Google Analytics, AT internet...)
- Conversion Rate Optimization through analytics and A/B testing
- Data Visualization on tools such as Tableau, Data Studio, Looker, Amplitude, Mixpanel etc.
- Media Advisory (budget allocation, acquisition roadmap)
- Media Activation & Optimization (SEA, Facebook Ads, Display)

Cafeyn (ex-LeKiosk)

Press & Media

Senior Data Analyst

Paris, France

February 2019 - December 2019

- Partnered with developers and engineers to reshape and maintain a data architecture that best responds to business needs
- Built metrics and dashboards for business teams to help them better monitor their activities (product, marketing, finance)
- Run ad-hoc analyses to understand and tackle business issues LeKiosk was facing (churn, funnel, usage analysis...)


Tools :

• Dataviz : Tableau Software, Metabase
• Analytics : Amplitude, Google Analytics
• Tracking : Segment, Google Tag Manager
• Data Warehouse : Snowflake
• Database : Azure SQL, PostgreSQL

Rakuten - Rakuten

E-commerce

Data Analyst

Paris, France

October 2016 - February 2019

- Analyzed complex data from multiple sources to ensure advertising campaign performance
- Developed reports and metrics to provide actionable insights to both clients and top management 
- Worked closely with the science team to detect bias or anomalies in Rakuten prediction algorithms behaviour
- Managed controlled AB tests from design to execution and analysis, to validate new product features
- Worked on a data migration project that involved migrating Rakuten data from Redshift to GCP BigQuery

Tools :
• Acquisition : RTB, Facebook Analytics
• Analytics : Google Analytics, Adobe
• Attribution : Eulerian, Mazeberry
• Data Warehouse : Amazon Redshift & Big Query
• Data visualisation : Tableau Software, Data Studio

FIFTY-FIVE

Consulting & Auditing

Data Analyst

Paris, France

March 2016 - September 2016

- Realized ad-hoc analysis providing strategic recommendations to operational (55) and managing teams (clients)
- Designed and managed clients media-buying strategy (budget allocation, media-mix, roadmaps)
- Managed customer relations : held weekly meetings to understand their needs and identify areas of improvement
- Realized daily, weekly and monthly performance analysis through Tableau Software

Tools :
• Tableau Software
• Big Query
• Google Ads
• DCM / DBM
• Google Analytics
• Google Tag Manager
• AB Tasty

Addict Mobile

Digital Agency and IT company

User Acquisition Analyst

Paris, France

September 2015 - February 2016

- Run user acquisition and re-engagement campaigns through diverse acquisition sources (Adwords, Facebook, SSP, Ad Networks)
- Performed analyses to implement adjustments on campaigns and improve client’s ROAS
- Developed a thorough understanding of ad-attribution and tracking with app measurement tools

Tools :
• Adjust
• Appsflyer
• Tune
• Google Adwords
• Facebook Ads
• SSP

CANAL+ - CANAL +

Press & Media

Marketing Analyst

Paris, France

September 2013 - March 2014

• Realized advertising campaign reports using Mediametrie measurement tool
• Run analyses and benchmarks to help the marketing team rebuild Canal+ advertising offers

2 Malt project(s)

    (2 ratings)

    Jonathan Lipoff - Freewheel

    4/30/2020

    Jonathan et moi avons travaillé ensemble chez Rakuten. De nature curieuse et enthousiaste, Jonathan est une personne impliquée réalisant un travail de grande qualité. Il est doté d’une excellente capacité d’analyse et a une parfaite maitrise des mécanismes d’acquisition et de conversion. Je le recommande vivement à tous ceux souhaitant être accompagnés sur des sujets de collecte, d'analyse, de visualisation de données, ou encore d’activation média.

    Thomas Moulin - Transaction Connect

    3/30/2020

    Je recommande vivement Jonathan avec qui j’ai travaillé chez 55. Au delà de son excellente maitrise technique, Jonathan se distingue par sa finesse d’esprit et sa très bonne compréhension des enjeux métiers. Son sens du relationnel et sa rigueur font également de lui un élément précieux au sein d’une équipe !

    Education

    Certifications

    charter modal image

    Success is a team effort

    Contribute to this success and the community's professionalism by signing the Freelancer Code of conduct

    Sign the code