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

Thomas Grammatico

Data Engineer Python SQL | Analytics Engineer dbt

€600/day
Lyon, FR
3-7 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Thomas

Data Engineer Python | SQL | Analytics Engineer

What if your data could become a real lever for impact, not a source of doubt?
I help tech-for-good startups to make their data reliable to amplify their social and environmental impact.

I am Thomas, a Data Engineer for over 5 years.

Is your data scattered across five tools and no one knows which one to trust?
Do you need to prove your impact, but the figures take three days to come out?
Do you want to automate, but every reporting is still done manually?

You are in the right place.

Specifically, I have supported as a freelancer:

- Quantification of flood risk for insurance companies. I designed a pipeline covering the whole of France from multiple sources. Collection time reduced from 10 hours to 1 hour. The visualizations created for the R&D team helped identify 2 bottlenecks that skewed the results.

- At covoiturage.beta.gouv, I analyze carpooling data and measure the effectiveness of incentive campaigns for local authorities, so they know, with supporting figures, whether their investments are paying off. I showed that less than 3% of trips compete with public transport.

I can help you with the automation of your data processes:
- Audit of the existing situation
- Collection of data from different sources
- Verification of data accuracy
- Construction of data warehouses and dashboards

In my free time, I volunteer on Data for Good projects such as potential solaire and OD&IS.

Need a data engineer or a dbt analytics engineer?
📩 Contact me today!

-------
Python, SQL, Git, CI/CD, Docker, Airflow, dbt, Duckdb, PostgreSQL, geospatial, GIS, SIG, DBT, ETL/ELT, Analytics Engineer, GCP, Google Cloud, Big Query, Bash, DuckDB, Datawarehouse, Data Warehousing, Data Modeling, dlt, Data Engineer, Analytics Engineer, Data Engineer Python, Analytics Engineer dbt
  • French

    Native or bilingual

  • English

    Fluent

  • Japanese

    Conversational

  • German

    Basic

Can work on-site
Lyon (up to 50km), Paris (up to 50km), Lille (up to 50km), Marseille (up to 50km), Bordeaux (up to 50km)

Experience

  • Worldskills France
    Data Engineer | Python | SQL
    CIVIC AND SOCIAL ORGANIZATIONS
    March 2026 - Today (5 months)
    Lyon, France
    Modernization of the data IS and industrialization of BI - Data Engineer Python | Analytics Engineer dbt assignment

    Built an automated daily data collection and update pipeline (PostgreSQL, dbt, n8n) from multiple business tools

    Developed financial dashboards and indicators, with automatic anomaly detection according to business rules. Reporting that used to take several days is now updated daily.

    Python · SQL · PostgreSQL · dbt · Metabase · n8n · database management · git · CI/CD · dlt - Data Engineer Python - Analytics Engineer dbt
    CI/CD Python SQL DBT PostgreSQL
  • Beta.Gouv
    Data Engineer Python | SQL | Analytics Engineer
    PUBLIC SECTOR
    September 2025 - Today (11 months)
    Lyon, France
    The state startup Covoiturage (Carpooling) assists local authorities, employers, and decision-makers in promoting short-distance carpooling. Among its services, the startup acts as a trusted third party for collecting and processing carpooling proof.

    Measurement of the impact of sustainable mobility policies
    Gathered needs from local authorities (AOM) and translated their questions into analyses and indicators, demonstrating the complementarity between carpooling and public transport and securing their investment decisions.

    Ensured the reliability of incentive data: quality controls, detection of double counting between operators, and resolution of trip attribution between territories.

    Modeled geospatial analyses combining trips, territorial perimeters, and incentive policies.

    Automation of analysis report production - production time went from several days to less than one day.

    Python · SQL · PostgreSQL · DuckDB · dbt · Metabase · ETL/ELT · geospatial analysis · git · public speaking Data Engineer Python - Analytics Engineer dbt
    Data Engineer Analytics Engineer Python SQL DBT Data Warehouse
  • ÆGIR
    Data Engineer Python | SQL | Analytics Engineer
    ENVIRONMENTAL
    March 2025 - July 2025 (4 months)
    Lyon, France
    Data Engineer Python Assignment
    → Assignment Objective:
    Automate the collection and analysis of geospatial and meteorological data to optimize flood risk forecasting at the national level.

    → Achievements:

    Designed an ELT pipeline covering the entire French territory, integrating heterogeneous sources to feed risk simulations, reducing collection and transformation time from ~10 hours to 1 hour.

    Developed quality control visualizations for developers and the R&D director, allowing the identification of 2 bottlenecks that skewed simulation results.

    Prepared and structured geospatial data serving as the foundation for damage estimations for insurers.

    Wrote documentation and designed the target architecture.


    Implemented intelligent scraping (Selenium**, **BeautifulSoup) to enrich datasets.

    → Technical Stack:
    Python, Airflow, dlt, dbt, PostgreSQL, PostGIS, DuckDB, BeautifulSoup, Selenium, HDBScan, Data Engineer Python, Analytics Engineer dbt
    Python ETL PostgreSQL Machine Learning Python Data Engineer Python

Recommendations

CP
Lilian AlvarezLA
Chloé Patrier and 1 other person have recommended Thomas

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

  • PhD in High Energy Physics
    Sorbonne University
    Doctorat en Physique des Hautes Énergies

Certifications

  • PhD
    Sorbonne University
    2022
    Data Scientist Python Data Scientist machine learning engineer Machine Learning Python Machine learning Data science CI/CD Data Engineer Data Scientist Pytorch Analytics Engineer
  • GDPR, AI Ethics and AI Act
    DataScientest
    Data scientist Artificial Intelligence (AI) artificial intelligence Data Scientist Python AI Act Data Engineer Python Machine learning Data science Data Engineer GDPR

Skill set

Categories