You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Simon LemaitreSL

Simon Lemaitre

Web Data Analyst | Digital & Data Analyst

€330/day
Lille, FR
0-2 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Simon

🎯 Losing confidence in your data? I help you regain control and maximize your decision-making.


As a data consultant, I support companies in steering and managing their business and marketing through data.

I work with prestigious clients (Honda, Coyote, DIM, Les Echos, Lulli, ...) who manage their businesses with reliable KPIs.


🚀 MY SPECIALTIES:

Business Intelligence:
  • Creation of tailor-made dashboards to steer your business (Looker Studio, Google Sheets)
  • Intuitive dashboards that transform your data into concrete actions
  • Robust data architecture: Data Modeling, Quality, Governance
  • Advanced tracking solutions (GA4, Server-Side, APIs)

Tracking & Analytics:
  • Google Tag Manager
  • Implementation and optimization of your web & app tracking journeys
  • Tailor-made tagging plans for usable and reliable data

BigQuery & Cloud:
  • Centralization and automation of your data flows
  • Tailor-made analyses and models for high-value insights


💡 UNIQUE APPROACH:

✅ Simplicity + Precision + Reliability = Effective marketing decisions
✅ Focus on business priorities
✅ Iterative construction with clear success KPIs
✅ Breaking down silos to optimize operational efficiency


🎖️ CONCRETE RESULTS:
  • Honda: Ultra-precise steering of advertising investments and dealer performance through Looker Studio reports adapted to the motorcycle sector.
  • Coyote: Tracking
  • Les Echos: Advanced analyses for the legal notice journal
  • Lulli: GTM and GTM server side
  • DIM: Steering of margins, advertising campaign performance, steering of different brands (DIM, Lovable, and Playtex)

🛠️ TECHNOLOGICAL STACK:
  • Data : BigQuery
  • Visualization : Looker Studio, Google Sheets
Marketing:
GA4, GTM, ADS(TikTok, Google , Meta)
  • French

    Native or bilingual

  • English

    Fluent

Remote only
Primarily works remotely

Experience

  • DBI (Dim, Lovable, Playtex)
    Data Consultant
    FASHION AND COSMETICS
    February 2025 - Today (1 year and 6 months)
    Lille, France

    📢 Omnichannel data centralization and analysis for Dim (DBApparel group)

    As part of the project for the Dim brand, development of a complete analysis ecosystem on BigQuery to monitor online marketing performance and multi-channel customer journeys.

    Key responsibilities:

    🔄 Aggregation of data from over 6 media and analytics platforms

    📦 Data quality assurance:

    Normalization tables
    Conversion processing

    📈 Creation of dynamic business views:

    Centralized + enriched KPIs
    Granular video analysis for Meta

    📊 Provision of automated reports for marketing teams & media agencies

    Technologies used:

    BigQuery (partitioned + clustered tables)
    Advanced SQL
    Automation with Google Sheets and Data Studio
    Enriched and multi-touch conversion analysis

    🎯 Objective: Provide Dim's teams with a unified and actionable view of advertising and user behavioral performance.
    Big Query Google Sheets Data Analysis Piwik Pro data marketing
  • - COYOTE -
    Data Consultant
    AUTOMOBILE
    February 2025 - Today (1 year and 6 months)
    Lille, France

    🚀 Data steering of marketing performance for Coyote

    As part of the Coyote project, I leverage an advanced analytical architecture on Google BigQuery to track and optimize the brand's digital campaigns.

    Key responsibilities:

    🔄 Multichannel data integration: Facebook, Google, Bing, Criteo, DV360, etc.

    🧠 Data structuring via BigQuery tables

    🎯 Acquisition & conversion analysis:

    Spend, clicks, impressions, ROAS
    Leads, purchases, engagements
    Multi-touch attribution (transaction_source_last_clic, affilation_last_click_anywhere tables, etc.)

    📊 Creation of business views (key KPIs)

    ⚙️ Automation of weekly & monthly reports for CRM, media & business teams

    Technical environment:

    Google BigQuery & SQL
    Partitioned + clustered data
    Multichannel centralization

    Marketing attribution, web tracking (GA4, Facebook Pixel, etc.)

    🎯 Objective: Centralize Coyote's marketing data for ROI-driven and granular steering of digital performance.
    Big Query data marketing Looker Studio Data Analysis Consulting
  • Honda Motor France
    Data Analyst
    AUTOMOBILE
    February 2025 - Today (1 year and 6 months)
    Paris, France

    🔧 Multichannel advertising performance analysis for Honda

    As part of the Honda project, I work on the exploitation and analysis of advertising data centralized in BigQuery, via a data pipeline designed to aggregate and cross-reference multichannel performance.

    Key responsibilities:

    🔍 Analysis of Honda advertising campaigns from multiple platforms (Meta, Google, Amazon, DV360, etc.)

    🧩 Cross-referencing traffic data with detailed conversion data.

    📆 Weekly and monthly performance monitoring:

    Advertising spend
    Clicks and impressions
    Specific conversions: leads, page views, purchases, social interactions

    📊 Creation of marketing steering dashboards: ROI, cost per conversion, click-through rates, generated value

    Technical environment:

    Google BigQuery
    Analytical SQL
    Data partitioned by date
    Automation via daily/weekly views and reports

    🔁 Objective: Monitor, optimize, and justify Honda's digital marketing investments with a focus on performance.
    Big Query Google Tag Manager Looker Studio Google Analytics Data Analysis

Recommendations

Simon OlivierSO
FU
FU
Simon Olivier and 2 other people have recommended Simon

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

  • RNCP LEVEL 5 (Associate Degree)
    OpenClassrooms
  • EXPERT IN INFORMATION TECHNOLOGY MASTER'S DEGREE
    EPITECH - European Institute of Technology
    2019

Certifications

  • Certificate of Achievement: Create a dashboard with your data
    Openclassrooms
    2021
    Data visualization Big Data
  • Certificate in CSS Animation
    Openclassrooms
    2021
    CSS3

Skill set

Categories