Freelancer profile translated to English.

Description

Senior Data Engineer with over 5 years of experience in designing end-to-end cloud data platforms. Specialist in the modern data ecosystem: modeling and transformation with dbt, Snowflake warehouse, Apache Airflow orchestration, Databricks / PySpark distributed processing, on Azure (and AWS). Experienced in cloud migrations, Medallion layered architecture, data quality, and CI/CD practices. Certified Databricks Data Engineer Associate and Microsoft Azure Data Engineer Associate (DP-203).

Industry field of expertise

Languages

French
Native or bilingual
English
Fluent

Workplace preferences

Can work on-site

Paris (up to 50km), Nantes (up to 10km)

Saint Gobain
Azure Data Engineer
RAW MATERIALS INDUSTRY
January 2025 - Today (1 year and 7 months)
Paris, France
Design and industrialization of enterprise data platforms based on a Medallion layered architecture (Bronze / Silver / Gold), with a Snowflake, dbt, Apache Airflow, and Databricks stack, within the Data Analytics team.

Mobility Project— Migration of the data platform from SAP BW to Snowflake:
• Migration of the Mobility domain data platform from SAP BW to a modern cloud architecture Snowflake / dbt / Airflow, ensuring business reporting continuity.
• Analysis of existing flows and models in SAP BW, then re-design of target models in Bronze / Silver / Gold layers.
• Development of dbt transformations (staging → intermediate → marts) reproducing and validating business logic inherited from SAP BW.
• End-to-end orchestration of loads and transformations via Apache Airflow DAGs (dependencies, SLA, error recovery).
• Implementation of dbt tests and reconciliation controls between SAP BW and Snowflake to validate the equivalence of results.

Tesseract Project— Near real-time multi-region production monitoring:
• Collection of data from production sites in Asia, America, Europe, and Africa every 30 minutes for worldwide production monitoring.
• Design of incremental ingestion pipelines scheduled every 30 minutes, with distributed processing in PySpark on Databricks.
• Implementation of the Medallion architecture on Databricks: Bronze (raw data from sites), Silver (multi-region / multi-timezone harmonization), Gold (aggregated production indicators).
• Exposure of consolidated data to Snowflake and reporting tools for industrial performance management.
Technologies: Snowflake, dbt, Apache Airflow, Databricks, PySpark, Azure Data Lake Storage Gen2, SAP BW, Azure, SQL, Python, Azure DevOps, Git.
SQL PySpark Azure Databricks Python Microsoft Azure
Aéroport de Paris
Azure Data Engineer
AVIATION AND AEROSPACE
January 2023 - January 2025 (2 years)
Paris, France
SPA Project(Airport Performance Monitoring) — Migration of the data platform from SAP BODS to a modern cloud architecture Snowflake / Databricks.
• Led the migration of the SPA platform, ensuring minimal service interruption and data consistency throughout the transition.
• Implemented ingestion and flow orchestration via Apache Airflow and Azure Data Factory (DAGs, triggers, parameterized datasets, dependency management).
• Developed and optimized dbt transformation models and Snowflake workflows for large-scale analytical loads.
• Developed Databricks notebooks (PySpark) for heavy transformations and distributed processing of data from source systems.
• Implemented quality controls, validation rules, and dbt tests to ensure data compliance, accuracy, and reliability.
• Designed CI/CD pipelines for automated deployment to staging and production environments via Azure DevOps.
• Optimized SQL queries and transformation logic in Snowflake, and implemented monitoring, logging, and alerting for proactive incident management.
• Documented the architecture, deployment procedures, and data lineage for operational and audit purposes.
Technologies: Snowflake, dbt, Apache Airflow, Databricks, PySpark, Azure (ADF, Synapse, DevOps), SQL, Python, Git.
Azure Data Factory SQL PySpark Databricks Snowflake
Optima energie
Data engineer
ENERGY AND UTILITIES
January 2020 - December 2022 (2 years and 11 months)
Paris, France
**Project**: setup and structuring of the data platform around Snowflake.

• Design and development of data pipelines with Apache Airflow to orchestrate and schedule complex workflows (DAGs, dependency and error recovery management).
• Construction of ELT pipelines loading data from AWS S3 to Snowflake, and structuring the warehouse (schemas, stages, tables, views).
• Implementation of ingestion and transformation processes on AWS (S3, Glue, Lambda, Athena) to prepare analytical data.
• Deployment and management of containerized environments with Docker, and automation of CI/CD workflows via GitHub Actions.
• Development of Python scripts and APIs to process and expose data services to consuming applications.
• Integration of Salesforce data into the analytical ecosystem and construction of Power BI dashboards for KPI monitoring.
Technologies: Snowflake, Apache Airflow, AWS (S3, Glue, Lambda, Athena), Docker, Python, GitHub Actions, Power BI.
Snowflake Databricks SQL Python AWS