Freelancer profile translated to English.

Description

Freelance Data Engineer specializing in Snowflake, with over 3 years of experience in designing and delivering end-to-end data platforms for clients in France, the UK, and the US.

I work across the entire data stack, from architecture to delivery — ingestion pipelines, data modeling and transformation on Snowflake (dbt, SQL, Python), production dashboards, and automated CI/CD deployment on AWS.

Before transitioning to data, I spent 5 years in corporate finance and venture capital at ArcelorMittal and Airbus Ventures — a background that allows me to understand the business challenges behind every data project.

Among my recent achievements: DETECT (detectnm.org), a data platform for the energy transition funded by the State of New Mexico, designed and delivered as Lead Data Engineer on Snowflake — now in production and presented at official conferences.

Available for new missions — remote or on-site, France, Europe, USA.

📩 marco.lopez(at)papermill.tech

Industry field of expertise

Languages

English
Fluent
French
Native or bilingual

Workplace preferences

Remote only

Primarily works remotely

EMNRD & New Mexico Tech (US)
Data Engineer – Energy Transition Data Platform (detectnm.org)
ENERGY AND UTILITIES
August 2025 - Today (1 year)
– Design and end-to-end delivery of the data platform as Lead Data Engineer (ingestion, Snowflake/dbt modeling, interactive dashboards)
– Multi-frequency pipelines (daily, weekly, monthly) across 4-5 federal and state sources covering energy production, emissions, and economic data
– Full CI/CD via GitHub Actions: automatic dbt deployment on Snowflake and Docker rebuild on AWS for each push
– Regular presentation of progress to institutional stakeholders (State of New Mexico, New Mexico Tech) — live public platform at detectnm.org
Snowflake Data Engineer Python Amazon Web Services Github Actions
GO7
Data Engineer – Aeronautics Data Platform
AVIATION AND AEROSPACE
June 2024 - Today (2 years and 2 months)
– Development of multiple automated ingestion pipelines to Snowflake (MySQL, Google Docs, various APIs) representing tens of millions of rows — including a Python/Docker scraper running daily
– Replacement of a critical billing process (3 people, several days) with a Streamlit/Snowflake app — reduced to half a day
– Reverse engineering of the SMS system to design data pipelines (MySQL, Snowflake, ThoughtSpot), replacing rigid Qlik/Excel reports
– Data Vault modeling on Snowflake to abstract the complexity of the source database and facilitate data usage by data analysts
Snowflake Docker Python SQL data vault
Préfecture des Bouches-du-Rhône
Data Engineer & Data Consultant – Territorial Data Collection & Centralization
PUBLIC SECTOR
February 2025 - June 2026 (1 year and 4 months)
– Conducting interviews with Community Social Action Centers to establish a strategy for transmitting residency data to the Prefecture
– Development of a Python API and Bash scripts to automatically centralize data in cloud storage (OVH S3), automated deployment via GitHub Actions CI/CD
– Creation of a Metabase dashboard to display data (operational and in production)
Python Bash Github Actions