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

Franck Li

Supermalter

Cloud Data Engineer

€778/day
2 projects
Paris, FR
3-7 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Franck

☁️ Senior Data/Analytics Engineer, I have supported various groups (Cosmetics, Luxury..) in their migration to GCP ☁️

As a Data/Analytics Engineer, I have carried out the following tasks 🧾:
♦ Construction of several data warehouses (Data mesh logic)
♦ Gathering and analysis of needs (Data Product Owner, Business Owner...)
♦ Use of REST API on Cloud Run modules to ingest data
♦ Development of the platform with the following technologies: BigQuery, Cloud Workflow, Cloud Scheduler, Cloud Run, Cloud Build, Cloud Storage, Pub/Sub, Firestore...
♦ CI/CD management on Github for versioning with Cloud Build/Terraform to deploy all GCP resources
♦ Project managed in agile methodology (ServiceNow/Jira)
♦ Modeling with dbt (Jinja), implementing tests (dqtools / elementary)

👉 If you are looking for an autonomous, proactive person, attentive to client needs & specialized in different areas (Supply, Finance, Customer, Product...), do not hesitate to contact me
  • French

    Native or bilingual

  • English

    Fluent

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

Experience

  • Saint laurent
    Data/Analytics Engineer
    LUXURY GOODS
    June 2023 - Today (3 years)
    Paris, France
    - Setting up a Data Mesh architecture to scale data sharing across domains (Data as a Product)
    - Build of multiple Governed/Exposed Data Product in BigQuery
    • Used in PowerBI/ToucanToco Dashboard
    • As a self-service for end user (Data Analyst/Business team)
    - Affiliated to the Finance (retail) & Supply domain
    • Collecting and analysing requirements to calculate new KPIs
    • Week-to-date...year-to-date sales
    • Store comparability, Traffic in store
    • Stock on hand, in transit, in transfer
    • Orders movement (allocated, non-allocated..)
    - CI/CD through github & using Terraform to deploy GCP resources
    - With an ELT approach, using dbt as a tool (& as part of the CI/CD) to modelize our build/tests (SQL/Jinja)
    - Query optimization using build-in features in BigQuery (time/range partitioning, clustering, sharding)
    - Scrum agile methodology on Jira
    - Language: dbt (Jinja/Macro), SQL (BigQuery), Terraform (HCL), git, Python
    BigQuery Google Cloud dbt Terraform SQL
  • L'Oréal
    Consultant Data Engineer GCP
    FASHION AND COSMETICS
    January 2021 - June 2023 (2 years and 5 months)
    Paris, France
    Data Engineer GCP for a leading beauty company Migration from SAP to full GCP managed services for serverless solutions :
    - Build of multiple Data Warehouses (BigQuery with views, materialized views/ Cloud Workflow/Cloud Scheduler)
    - CI/CD on Github with Cloud Build/Terraform for versioning and also to deploy all related GCP resources
    - Call from APIs on Cloud Run to retrieve data coming from different sources (event driven/REST API)
    - Design and implementation of multiples data pipeline with REST APIs on GCP platform
    - Design/build of the use-case to produce different types of Analytics PowerBI report through KPIs with input coming from the business
    - Other GCP services used : Cloud Storage, Cloud Pub/Sub, Cloud Tasks, Firestore, Cloud Shell, Compute Engine, IAM
    - Scrum agile methodology on ServiceNow/Jira
    - Language: SQL, Python, Terraform (HashiCorp Configuration Language), bash
    - IDE: Visual Studio Code (IDE implemented in VMs/Cloud Workstations)
  • Allianz France
    Data Analyst
    September 2019 - September 2020 (1 year)
    92400 Courbevoie, France
    Production of KPIs for dashboards on outbound flows (SAS / Excel / VBA)
    - Handling of large and complex databases
    - Categorization of the different flows according to the insurance field (SAS - production of 6 differents dashboards) Build of data pipeline based on the publishing providers (SAS / Excel)
    - Analysis done through 5 dashboards
    - Implementation of pricing strategies with the providers Predictive analysis from the availability of stock and disparities (SAS) Automation of programs for invoice control (SAS) Capitalization and knowledge transfer to the business

Recommendations

Be the first to recommend Franck

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's degree, Data Science
    Université Paris-Est Créteil (UPEC)
    2020
    Master's degree in Data Science
  • Bachelor's degree in Econometrics
    Université Paris-Est Créteil (UPEC)
    2018
    Bachelor's degree in economy/statistics

Certifications

Skill set (29)

Categories