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

Karim Zhan

Data/Analytics Engineer — GCP

€670/day
Paris, FR
3-7 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Karim

Data/Analytics Engineer GCP specialized in designing scalable and governed Data Products, at the intersection of technical and functional. I work in direct collaboration with your business teams to transform your needs into production-ready data solutions — from collection to exposure in dashboards or self-service analytics.

What I bring you concretely:

Do you have complex SAP data, business teams expecting reliable KPIs, and a GCP infrastructure to evolve? This is exactly my field. I master the entire lifecycle of a Data Product: framing with stakeholders, BigQuery modeling, testing, CI/CD via GitHub Actions, infrastructure as code with Terraform — up to end-user adoption via PowerBI.

What sets me apart:

Most Data profiles are either very technical or very functional. My experience at Saint Laurent and L'Oréal has taught me to be both: I understand business challenges (Supply Chain, Retail & Sales, Finance) as much as technical constraints. I am also bilingual Mandarin/English, which has allowed me to work on international projects (Shanghai, Chinese market — Douyin, Alibaba) with cross-cultural teams.

Projects and deliverables I work on:

Design and build of governed Data Products in a Data Mesh architecture on GCP
ELT pipelines with dbt (SQL, Jinja, macros, unit tests) and automated CI/CD
SAP to GCP migration — serverless, scalable, reduction of operational costs
PowerBI analytical dashboards for Retail, Supply Chain, and Finance teams
BigQuery optimization: partitioning, clustering, sharding on large SAP datasets
GCP Infrastructure as Code with Terraform

Stack: BigQuery · dbt · Terraform · Python · SQL · GCP · SAP · PowerBI · GitHub Actions · Databricks
  • French

    Native or bilingual

  • English

    Native or bilingual

  • Chinese

    Native or bilingual

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

Experience

  • Saint Laurent
    Data/Analytics Engineer — GCP
    LUXURY GOODS
    October 2024 - Today (1 year and 8 months)
    Paris, France
    As a Data/Analytics Engineer at Saint Laurent, I sit at the intersection of technical expertise and business understanding — working in direct collaboration with Supply Chain and Retail & Sales teams to turn their needs into production-ready Data Products on GCP.

    Our source system is SAP, which requires a deep understanding of its data model to extract clean, meaningful and business-ready outputs. From there, I own the full lifecycle of each Data Product: scoping with stakeholders, modeling in BigQuery, testing, CI/CD deployment and end-user adoption.
    All Data Products are built within a Data Mesh architecture, treated as standalone assets — governed, documented, and exposed either through PowerBI / ToucanToco dashboards or as self-service analytics.

    Supply Chain :

    Availability Rate — product availability monitoring to proactively detect stockout risks
    Launch Planning — inventory readiness tracking aligned with collection go-to-market timelines
    Stock Visualization — stock level KPIs across products, regions and channels
    Weeks of Coverage — forward-looking indicator to anticipate replenishment needs

    Retail & Sales :

    Weekly/Daily Sales Overview — daily & weekly store performance KPIs
    Weekly Retail Performance — KPI tracking across regions and channels
    Wholesale Sellout — sell-out visibility from wholesale partners
    Shopping Insider — digital performance consolidation from Google Ads & Google Merchant Center

    Technical scope:

    Source system: SAP → ingested and modeled on GCP / BigQuery
    ELT pipelines with dbt (SQL, Jinja, macros) · CI/CD via GitHub Actions
    GCP infrastructure as code with Terraform
    BigQuery optimization: partitioning, clustering, sharding
    Agile / Scrum on Jira

    Stack: BigQuery · dbt · Terraform · Python · SQL · Git · SAP · PowerBI
    BigQuery Terraform SQL Google Cloud Platform (GCP) DBT
  • IBM France
    Data Engineer — GCP
    LUXURY GOODS
    January 2021 - October 2024 (3 years and 9 months)
    Paris, France
    As a Data Engineer at L'Oréal, I contributed to a large-scale SAP-to-GCP migration, transitioning legacy data infrastructure toward fully managed, serverless GCP services — improving scalability and reducing operational costs.

    Working closely with business stakeholders across Finance, Supply Chain and Customer domains, I translated business requirements into technical specifications and delivered end-to-end data solutions, from pipeline design to analytical reporting.

    Key contributions:

    SAP to GCP migration — implemented serverless solutions to replace legacy SAP data flows, improving scalability and cutting operational overhead
    Data Warehouse design — built multiple data warehouses using BigQuery, Cloud Workflow and Cloud Scheduler
    REST API pipelines — designed and implemented multiple data pipelines integrating REST APIs on GCP
    CI/CD — set up deployment pipelines using GitHub, Cloud Build and Terraform
    Analytical reporting — developed business reports in close collaboration with domain partners, ensuring alignment with Finance, Supply Chain and Customer data needs

    Technical scope:

    GCP services: BigQuery · Cloud Storage · Cloud Pub/Sub · Cloud Tasks · Cloud Workflow · Cloud Scheduler · Firestore · Compute Engine · IAM
    Infrastructure as code: Terraform
    Languages: Python · SQL (on Visual Studio Code, GCP VMs)
    Agile / Scrum on ServiceNow / Jira
    Terraform SQL Google Cloud Platform (GCP) BigQuery Microsoft Visual Studio
  • L'Oréal China
    Data Engineer — GCP
    LUXURY GOODS
    March 2023 - June 2023 (3 months)
    Shanghai, China
    As a Data Engineer embedded within L'Oréal China's Consumer domain, I worked on complex multichannel data challenges specific to the Chinese market — across offline stores and major online platforms including Douyin and Alibaba.

    Fluent in both Mandarin and English, I collaborated daily with cross-functional teams and Consumer domain analysts to ensure data solutions were tightly aligned with business objectives.
    Key contributions:

    Gift article mapping — designed and implemented data procedures to match 10,000+ gift items to their respective products across offline and online channels (Douyin, Alibaba), enabling accurate gift policy analysis and purchase behavior tracking
    Consumer analytics — integrated Consumer domain analyst requirements into scalable data solutions supporting strategic business initiatives
    Data quality — ensured data integrity through rigorous testing across GCP and Databricks environments
    Cross-cultural collaboration — bridged technical and business teams effectively across languages and time zones

    Stack: BigQuery · Databricks · GCP · Python · SQL
    BigQuery SQL Databricks Google Cloud Platform (GCP) Terraform

Recommendations

Be the first to recommend Karim

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 of Software & Information Systems
    EFREI Paris
    2021
    Master of Software & Information Systems
  • Associate's Degree in Computer Science
    IUT Paris Descartes
    2019
    Associate's Degree in Computer Science

Certifications

  • Google Cloud Certified Professional Data Engineer
    Google
    2021
  • Google Cloud Certified Cloud Engineer
    Google
    2021

Skill set

Categories