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

Franck Li

Supermalter

Cloud Data Engineer

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

Average response time: 1 hour

About Franck

☁️ Senior Data/Analytics Engineer, j'ai accompagné divers groupes (Cosmétique, Luxe..) sur leur migration vers GCP ☁️

En tant que Data/Analytics Engineer, j'ai réalisé les tâches suivantes 🧾:
♦ Construction de plusieurs entrepôts de données (logique de Data mesh)
♦ Récolte et analyse du besoin (Data Product Owner, Business Owner...)
♦ Utilisation de REST API sur des modules Cloud Run pour ingérer de la donnée
♦ Développement de la plateforme avec les technologies suivantes : BigQuery, Cloud Workflow, Cloud Scheduler, Cloud Run, Cloud Build, Cloud Storage, Pub/Sub, Firestore...
♦ Gestion de la CI/CD sur Github pour le versioning avec Cloud Build/Terraform pour déployer toute les ressources GCP
♦ Projet géré en méthodologie agile (ServiceNow/Jira)
♦ Modélisation avec dbt (Jinja), en implémentant des tests (dqtools / elementary)

👉 Si vous êtes à la recherche d'une personne autonome, proactive, à l'écoute du besoin client & spécialisé dans différents domaines (Supply, Finance, Customer, Product...), n'hésitez pas à me contacter
Fashion and Cosmetics
Luxury Goods
Large Retailers
Consulting and Audits
Laundry, Home Care and Personal Care

  • 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
    Big Query 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
Check out Franck's experience

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

Signup to reveal

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

Franck's certifications are only visible to Malt Community members

Skill set (29)

Google cloud
Terraform
GitHub
Big Query
Python
SQL
CI/CD
Infrastructure as code
Git
REST API
SAS
Datawarehouse
Bash
ETL
Cloud computing
Cloud Engineer
VBA
noSQL
IAM
Data Lake
Firestore
PubSub
Cloud Build
Cloud Storage
Cloud Run
DBT
Jinja
Apigee
Data Mesh

Categories