You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Côme CahenCC

Côme Cahen

Data Analyst | BigQuery - DBT - Looker - Analytics

€490/day
8 projects
Marseille, FR
3-7 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Côme

Hello!

As a freelance Data Analyst, I can help you with data analysis tasks such as:
ᐉ Building dashboards for KPI monitoring (Looker Studio (Data Studio)/PowerBi / Tableau/Metabase).
ᐉ Data analysis to address your business challenges (= data visualization).
ᐉ Data exploration to uncover actionable insights.
ᐉ Web analytics for your website performance (Google Analytics & Search Console).
ᐉ Data cleaning / updating / managing your database.

Why choose me?
▸ Young with extensive experience in B2B and B2C companies.
▸ Sociable and very curious, I look beyond the numbers to understand the context of your business/company.
▸ Reports and dashboards are created in a graphical, precise, and concise manner.
▸ Ability to analyze and reflect on product and business topics.
▸ Adaptable to all subjects and environments within your company.

My background:
After an MSc in Data Sciences / Digital Marketing and several supplementary professional experiences, I have been working as a freelance Data Analyst for over 4 years.

My other skills:
Beyond technical data analysis skills, I have extensive experience as a Digital Marketing consultant, which allows me to bring a marketing perspective to my analyses.

Additionally, I particularly enjoy website creation and video editing.
  • English

    Native or bilingual

  • Italian

    Conversational

Can work on-site
Marseille (up to 50km), Lyon (up to 10km), Paris (up to 50km)

Experience

  • Jimmy Fairly
    Data Analyst
    RETAIL (SMALL BUSINESS)
    April 2023 - Today (3 years and 1 month)
    Paris, France
    Jimmy Fairly, an optician offering high-end glasses at affordable prices.
    + 144 stores in France, UK, Belgium, Spain & Italy.

    ᐉ Creation of dashboards on Looker Studio
    - "Retail" Dashboards for daily store monitoring (Revenue, LFL, Volumes, etc.).
    - "Ops" Dashboard for monitoring the manufacturing process, lead times, and deliveries.
    Result: + 400 sessions per day

    ᐉ Data cleaning & database structuring
    - Cleaning commercial data in DBT
    - Structuring models & data checks on existing tables

    Stack: Google BigQuery, Looker Studio (Data Studio), DBT, Fivetran
    Data Sources: Retail Software (Keyneo), Payment (Octave, Adyen), GSheets
    Big Query DBT Data Analysis Data Visualization Dataviz Looker Studio Google Data Studio Data Studio Fivetran
  • Brut.
    Data Analyst
    PRESS AND MEDIA
    February 2023 - Today (3 years and 4 months)
    Paris, France
    ᐉ Data cleaning & dashboard on Looker
    - Dashboard on audience data (FB, IG, TK, YT, SP)
    - Dashboard on follower & demographic data.

    ᐉ Automation of reports with GSheet, Looker (Look ML) & Looker Studio
    - Automation of reports for Sales & Brand teams (Backend data + GSheet to an automated report for campaign analysis).
    - Automation of monthly audience reports for the entire company.

    ᐉ Exploratory analyses:
    - Demographic analyses of Facebook fans
    - Audience projections at the end of each month.

    Stack: Google BigQuery, Looker / Look ML, DBT Cloud, Github
    Data Sources: Backend, Social Networks, Google Sheet, Lucca
    Looker DBT Big Query BigQuery Data Analysis Audience Analysis Data Visualization Google Data Studio Looker Studio
  • Convelio SAS
    Data Analyst
    IMPORT AND EXPORT
    September 2021 - October 2022 (1 year and 1 month)
    Paris, France
    ᐉ Analysis and visualization of data to find actionable insights:
    - HR team dashboards to track recruitment activity and funnel.
    - Dashboard (scorecard) for scoring key KPIs to monitor market health from different perspectives (Business / Clients | Team / Ops)
    - Analyses within the framework of a sustainable development project (carbon emission compensation for transport methods within the GLEC framework).

    ᐉ Exploratory analyses:
    - Forecasting metrics such as "Revenue Forecast" for the BD team.
    - Impact of seasonality on sales
    - NPS and eNPS

    ᐉ Reorganization of the data warehouse structure and data flow.

    Stack: Google BigQuery, Data Studio, Airflow, DBT, Github
    Data Sources: Backend, Salesforce, Front, Lever, Lucca
    Big Query SQL Google Data Studio Data Analysis Airflow DBT GitHub Data Visualization Data Mining Web Analytics Looker Business Intelligence

Reviews

4.4

Out of 7 ratings

C

Cyprien

TOUS MES DROITS

Reviewed on 9/24/2020

Excellent mission: BigQuery setup + Data Studio Dashboard. Côme delivered very high-quality work, he was efficient, and all the work he provided is 100% reusable (clean and well-documented).
A

Arthur

Jimmy Fairly

Reviewed on 6/1/2023

Recommendations

Camille DugastCD
Johan AradanJA
FU
+1
Camille Dugast and 3 other people have recommended Côme

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • DUT GEA (Business and Administration Management)
    Université Lyon 1, Lyon
    2017
  • L3: Bachelor's Degree in Economics and Management - Operational Diagnosis of Companies track
    Ostfold University College, Halden, Norway
    2018
    Licence en anglais avec des sujets comme: Marketing, Economie & Finance internationale. Par ailleurs, j'ai pu assister à des cours de communication digitale, d'entreprise et inter-culturelle.

Certifications

  • HTML/CSS Bootcamp
    Le Wagon, Shanghai
    2019
    CSS JavaScript HTML
  • Intermediate SQL
    DataCamp
    2020
    SQL Server SQL

Skill set

Categories