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

Lilian Peguin

Supermalter

Data Analyst | Analytics Engineer

€600/day
4 projects
Paris, FR
8-15 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Lilian

With over 10 years of experience in Data, I design and deploy end-to-end analytical solutions, transforming raw data into concrete steering tools for business teams and decision-makers.

My areas of intervention:

➜ Transforming data into business value: data modeling, flux reliability, KPI definition, and creation of decision-making dashboards for activity monitoring.

➜ Collaboration with business teams: requirements gathering, structuring key indicators, and writing functional and technical specifications to translate business challenges into concrete data solutions.

➜ Design and industrialization of data solutions: development of reliable and high-performing pipelines, data models, and reporting, directly used for operational monitoring and decision-making.

➜ Data governance: repository structuring, business rule definition, and implementation of practices ensuring data quality, consistency, and traceability.

➜ Delivery and development best practices: experience in Agile, SAFe, and V-cycle environments, with integration of CI/CD, quality, and data solution industrialization practices.

➜ Work in demanding environments: ability to work independently, in small teams, or within larger organizations, facilitating collaboration between technical and business teams.

➜ Team support: sharing data best practices, structuring work methods, and highlighting individual contributions to strengthen collective impact.

Availability: Immediate.
  • French

    Native or bilingual

  • English

    Fluent

Can work on-site
Paris (up to 50km), Lille (up to 50km), Lyon (up to 50km), Toulouse (up to 50km), Montpellier (up to 50km)

Experience

  • Crédit agricole SA
    Data Analytics & Engineering Lead / Head of SI & Cybersecurity Dashboards
    BANKING AND INSURANCE
    January 2025 - January 2026 (1 year)
    Paris, France
    • Gathering and formalizing business requirements in close collaboration with business teams, designing, and developing group-wide Cybersecurity and SI decision-making Power BI dashboards.

    • Designing high-performance data models (star schema) and transforming data using SQL and Python to ensure reliability and usability.

    • Developing fast, intuitive, and user-oriented Power BI dashboards with quick navigation and efficient filter management.

    • Continuous improvement of reporting ergonomics and structure (UI/UX, graphic charter) to facilitate their evolution while respecting business needs.

    • Analytical and technical referent: mentoring, dissemination of best practices in modeling and data quality.
  • BNPP
    Data Analyst / Analytics Engineer
    July 2022 - December 2024 (2 years and 5 months)
    Paris, France
    • Designing strategic analytical reporting and dashboards for the Group Legal department using Tableau to facilitate activity steering and key indicator monitoring.

    • Designing high-performance semantic models: star schema modeling (fact and dimension tables) to organize relationships between tables and integrate data in a readable and optimized way into reports.

    • Advanced use of Alteryx: designing high-performance workflows, integrating and joining multi-source data, developing reusable macros, and automating processes via task scheduling.

    • Leveraging the AWS ecosystem to industrialize the ingestion and processing of data from heterogeneous sources (on-premise, PostgreSQL databases), implementing robust and scalable pipelines.

    • Manipulating and transforming large volumes of data within analytical environments on Teradata and Snowflake.

    • Preparing optimized datasets to address RLS, historization, and performance challenges.

    • Implementing versioning best practices with GitLab (version management, collaboration, and tracking of data pipeline evolutions).
  • Arquus Defense
    Data Analyst / Analytics Engineer
    DEFENSE AND MILITARY
    January 2021 - June 2022 (1 year and 5 months)
    Paris, France
    • Supply Chain and inventory management reporting with Power BI.

    • Modeling and transforming data pipelines in a Cloud environment based on Google Cloud Platform, with structuring and industrialization of analytical transformations via DBT.

    • Migration of reports from Tableau to Power BI:

    ➜ Reverse engineering of existing Tableau dashboards and adapting calculation logic to Power BI (rebuilding KPIs, translating Tableau formulas to DAX, optimizing data models)

    ➜ User training and acculturation: presentation of new Power BI dashboards and key differences with Tableau (navigation, filters, KPI logic)

    ➜ Operational support: assisting users, answering questions, and correcting misunderstandings during initial usage.

    • Designing interactive analytical applications with Streamlit to leverage AI model results and develop data application tools for business users.

Recommendations

Be the first to recommend Lilian

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

  • Equivalence Bac +3, Formation analyse de données
    WildCodeSchool
    2015
    Equivalence Bac +3, Formation analyse de données

Skill set (43)

Categories