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

Benjamin Amiot

Data Analyst

€600/day
Senlis, FR
8-15 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Benjamin

After 10 years in permanent contracts, across industry, healthcare, and the public sector, I chose independence to rediscover meaning, continue learning, and invest myself where my skills have a concrete impact.

Today, I want to positively impact society and the companies that drive it by helping them to:
📊 structure their marketing data (CRM, web, campaigns),
📈 build clear dashboards (Power BI or others),
🤖 automate reporting,
🔍 and above all, transform data into useful decisions.

My style? Pragmatic and pedagogical.
I like to understand your challenges, simplify if necessary, and propose simple, robust solutions that stand the test of time.

✔️ Do you lack time to analyze your performance?
✔️ Do you have tools (CRM, web analytics, Power BI) but they don't speak to you?
✔️ Do you feel your campaigns could target or convert better?
I can help you. Seriously, without unnecessary jargon.

📍 Based in France, I work remotely and am available for video calls or in-person meetings if needed.
  • French

    Native or bilingual

  • English

    Conversational

Can work on-site
Senlis (up to 50km), Rouen (up to 50km)

Experience

  • CETIM
    Marketing Data Analyst
    RESEARCH
    January 2023 - Today (3 years and 5 months)
    Senlis, France
    Context:
    Cetim wanted to structure its marketing and data management to better target, personalize, and evaluate its actions with industrial clients.

    Objectives:

    Track multi-channel marketing performance (emailing, web, CRM)
    Generate insights to guide campaigns and prospecting
    Industrialize data collection, visualization, and exploitation processes

    Actions taken:
    📊 Creation and automation of dashboards in Power BI to manage campaigns, content, leads, and web performance
    🤖 Leading an AI working group on use cases in communication and marketing
    🔍 Statistical studies to guide strategic decisions (segmentation, behaviors, scoring)
    🌐 Advanced web analytics via Matomo (user journey tracking, conversion rates, GDPR compliant tracking)
    🧠 Structuring lead generation processes through Data Marketing approach (scraping, targeting, scoring, CRM enrichment)
    🔄 Participation in optimizing customer journeys (CRM + website interactions)

    Results:

    ✔️ Improved campaign relevance:
    +1 point click-through rate on emails
    +8 points open rate instead of 21%
    ✔️ Dashboards adopted by operational teams and decision-makers
    ✔️ Reduced manual analysis time through automation of extractions and visualizations

    Stack & tools:
    Power BI · Dynamics 365 CRM · Matomo · Python (scraping) · SQL · Customer Insights · CustomerVoice · Generative AI (OpenAI)
    SQL Microsoft Power BI VBA Python Dynamics 365
  • CCMO
    Statistical Study Officer
    HEALTH AND WELLNESS
    March 2022 - December 2022 (9 months)
    Beauvais, France
    Context:
    CCMO wanted to strengthen the management of its collective and individual health contracts, better respond to tenders, and ensure the reliability of its pricing strategy.

    Objectives:

    Optimize the profitability of health portfolios

    Structure financial management tools

    Improve competitiveness in tenders

    Actions taken:

    📊 Actuarial analysis of financial risks on health contracts (individual / collective)

    💲 Pricing for prospecting and renewals (tenders)

    📈 Production and updating of strategic dashboards for financial management

    🧮 Preparation of client profit and loss statements (company level)

    🗂️ Data structuring with SAS EG, Predict Office, and Excel

    Results:

    ✔️ Improved responsiveness on tenders (+ commercial efficiency)
    ✔️ Enhanced decision support for the board of directors
    ✔️ Reliable financial management of health contracts

    Stack & tools:
    SAS Enterprise Guide · Predict Office · Excel · Actuarial analysis · Dashboards
    SAS SQL Microsoft Excel Actuarial Science
  • CRAMIF
    Statistician
    PUBLIC SECTOR
    July 2020 - March 2022 (1 year and 8 months)
    Paris, France
    Context:
    Structuring of a Statistics & Data department within a large public organization, with the objective of becoming a strategic support for internal departments (management control, marketing, fraud prevention).

    Objectives:

    Create a structured and useful internal data activity for business departments

    Respond to cross-functional analysis needs (management control, performance, CRM)

    Lay the foundation for data visualization within the organization

    Actions taken:

    🛠️ Co-construction of a Statistics/Data service in partnership with the manager

    📣 Internal promotion of the service, raising awareness among departments about data culture

    📊 Development of Power BI dashboards for business departments

    🧮 Responses to ad-hoc analysis requests (CRM, management, anomaly detection, fraud...)

    📈 Development of activity profiles for insured individuals / agents / processing flows

    Results:

    ✔️ Rapid adoption of the service by internal departments (+50 requests processed in 1 year)

    ✔️ First functional Power BI foundation deployed across several business areas

    ✔️ Concrete data valorization in business processes (management, optimization, control)

    Stack & tools:
    Power BI · SAS Enterprise Guide · SQL · Excel · VBA
    SQL SAS Microsoft Power BI Microsoft Excel Data Analysis

Recommendations

Be the first to recommend Benjamin

Help this freelancer shine by sharing your experience working together.

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

  • Bachelor's Degree in Statistics & Decision Support IT
    Université Toulouse 3 Paul Sabatier
    2012
    Statistiques descriptives Probabilités Statistiques inférentielles Bases de données SQL SAS C++ Python Java Perl SPSS Analyses de données

Skill set

Categories