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

Lyes Berchiche

Consultant Data Manager / Quality Management

€650/day
Metz, FR
3-7 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Lyes

Consultant Data Analyst Senior • Data Quality & Management Expert

**Need business decisions based on reliable data**? I help companies make their databases reliable and industrialize their reports to effectively steer their business.
With 5 years of experience gained within demanding major clients (**L'Oréal, Enedis, Valeo**), I am involved in the entire data value chain.

🛠️ My key expertise:

  • **Data Quality & Governance**: Audit, cleaning, and remediation of data (completeness, consistency).
  • **Modern Data Stack**: Migration to the Cloud, complex modeling and querying (GCP BigQuery, SQL).
  • **Business Intelligence**: Creation of impactful decision-support dashboards (Power BI, Tableau).
  • **Automation**: Automation of data flows and API connection (n8n).
  • **Facilitation**: Gathering business needs, facilitating workshops, and change management.

🎯 Why work together?

Graduated fromSkema Business Schooland the University ofParis 6 (Sorbonne Université -formerly Université Pierre et Marie Curie), I combine the technical rigor of a scientist with the strategic vision of a manager. I am fluent in English and available for missions in **Full Remote**, in **Île-de-France**, or in **Luxembourg**.
Let's discuss your project! Contact me directly to talk about your Data challenges.
  • French

    Native or bilingual

  • English

    Fluent

Can work on-site
Metz (up to 50km), Paris (up to 50km), Luxembourg (up to 50km)

Experience

  • L'Oréal
    Consultant Data Manager & Data Quality Expert
    FASHION AND COSMETICS
    November 2024 - Today (1 year and 7 months)
    Saint-Ouen, France

    ​💻 Mission Context

    1.5-year mission as a Data Manager Consultant within the Research & Innovation (R&I) department of L'Oréal in Saint-Ouen. My role was to support the digital transformation of teams by ensuring the reliability of databases and industrializing the presentation of business KPIs.

    ​🛠️ Achievements and Responsibilities

    • **Digitalization & Cloud Migration**: Migration and enrichment of historical databases from Excel formats to robust Cloud environments on GCP (Google Cloud Platform) to optimize data utilization.
    • **​Architecture & Data Preparation**: Drafting functional specifications for data provisioning. Design and structuring of data sources on GCP BigQuery (modeling of analytical tables/views) for reporting purposes.
    • **​Data Quality Management**: In-depth analysis of data quality (completeness, consistency, cleaning) and management of remediation efforts to correct anomalies at the source.
    • **Business Intelligence**: Building and deploying decision-support dashboards on Power BI to monitor data quality and performance.
    • **​Governance & Facilitation**: Scoping needs, organizing, and facilitating workshops with business and scientific teams in R&I on key data topics.

    ​📊 Technical Environment

    GCP (Google Cloud Platform), BigQuery, SQL, Power BI, Excel, Data Quality, Data Governance.
    Google Big Query Microsoft Power BI Data Quality Management SQL Requirements Gathering and Formalization
  • ENEDIS
    Consultant Data Analyst & Data Governance
    ENERGY AND UTILITIES
    March 2021 - October 2024 (3 years and 7 months)
    92800 Puteaux, France

    ​💻 Mission Context

    3.5-year mission as a Data Analyst / PMO Consultant for Enedis (via Alten) in Puteaux. Within a large-scale IT environment, I managed the entire data lifecycle, from integration to governance, while supporting business teams.

    ​🛠️ Achievements and Responsibilities

    • **Data Management & ETL Processes**: Design and management of extraction, transformation, and loading (ETL) flows. Operational management of the entity's Cloud storage spaces.
    • **​Data Governance & Quality**: Implementation of data governance and quality rules to secure strategic reporting. Maintenance in operational condition (MCO) of business IT tools.
    • **Business Intelligence & KPIs**: Modeling, preparation, and integration of data for the production of performance indicator dashboards on Power BI and Tableau for steering committees.
    • **​Scoping & Specifications**: Organization and facilitation of workshops to gather and specify needs from business departments.
    • **​Change Management & Leadership**: Leading launch webinars for BI tools and change management to maximize user adoption. Responsible for the integration and onboarding of new consultants in the team.

    ​📊 Technical Environment

    Power BI, Tableau Software, ETL Processes, Data Governance, Data Quality, SQL, Excel/Access, Project Management/PMO.
    Microsoft Power BI Tableau Software Data Governance ETL Project Planning and Organization
  • Valéo Group
    Data & Business Performance Project Manager
    AUTOMOBILE
    January 2020 - January 2021 (1 year)
    La Verrière, France

    ​💻 Mission Context

    A one-year mission as aJunior Data Project Managerwithin the Thermal Powertrain (TPT) division of Valeo Group at the La Verrière site. In a highly international context, I managed the deployment and monitoring of financial and operational key performance indicators (KPIs) for all projects in the division.

    ​🛠️ Achievements and Responsibilities

    • **KPI Implementation & Monitoring**: Modeling and deployment of key performance indicators (KPIs) dedicated to monitoring the launches of all industrial projects in the TPT branch.
    • **​International Coordination**: Facilitation and cross-functional coordination of directors and project managers based in several global geographical regions (Europe, Southeast Asia, China, North America, South America).
    • **Financial & Business Reporting**: Production and consolidation of monthly project management reports (monitoring by site, by region) in direct collaboration with management control and finance teams.
    • **Data Portal Management**: Administration, updating, and structuring of the global collaborative portal (Google Sites) dedicated to the division's programs and projects.

    ​📊 Technical Environment

    Data Project Management, Business KPIs, Reporting (Google Workspace / Google Sites), Financial Reporting, Management Control, English (international context).
    Requirements Gathering and Formalization KPI & Dashboarding Project Planning and Organization English Microsoft and Google Tools

Recommendations

Be the first to recommend Lyes

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

  • Master - Project and Program Management
    Skema Business School
    2021
    Spécialisation en gestion de projets complexes, management de la performance et stratégie d'entreprise.
  • Master in Engineering, Sciences and Technologies (Chemistry Specialization)
    Université Paris 6 - Pierre et Marie Curie (Sorbonne Université)
    2019
    Formation supérieure scientifique d'excellence axée sur la modélisation moléculaire, la formulation et l'analyse de données de recherche. Ce cursus m'a apporté une forte culture de la donnée à travers la mise en place de plans d'expériences rigoureux, le traitement statistique de résultats complexes et une solide capacité d'analyse et de résolution de problèmes scientifiques.

Certifications

Categories