Berhault BenjaminSenior Data Engineer · Annecy
FR
Available immediatelyAnnecy, Rhône-Alpes, FranceTélétravail / Hybride / Sur siteCDI ou freelanceFrench (natif) · English (courant)

I build the data layer people still trust eighteen months later

10+ yrsbuilding integration and warehouse platforms
90+countries served by the ICRC data integration I ran
7+operational domains centralised in one warehouse
40M+establishments in a data platform I built solo

ODS · SSIS · CDC Kafka/Debezium · SQL Server · PostgreSQL+ production LLM, MCP and vector pipelinesICRC · City of Lausanne · Paris Fire Brigade

Data integration and warehousing engineer. I build the layer between operational systems and the people who have to decide on them: Operational Data Stores, ETL/ELT pipelines, CDC replication, enterprise data warehouses — and, for the last two years, the LLM and vector layer on top of them.

Data integration and warehousing engineer. I build the layer between operational systems and the people who have to decide on them: Operational Data Stores, ETL/ELT pipelines, CDC replication, enterprise data warehouses — and, for the last two years, the LLM and vector layer on top of them. Ten years of it in places where a broken flow has consequences: emergency services, humanitarian operations, government.

Data Integration · Data Warehouse · ETL design · Operational Data Store (ODS) · SSIS · SQL Server (2008R2–2022)

10+ yrsbuilding integration and warehouse platforms
90+countries served by the ICRC data integration I ran
7+operational domains centralised in one warehouse
40M+establishments in a data platform I built solo

Réalisations choisies · 9 preuves

Réalisations

Feb 2026 - present 2 sources

Built a 20-country job platform solo — ingestion, matching, salary data and a 40M-establishment employer map

20 countries with live ingestion, 40M+ geocoded establishments, ~$0.02 per full job analysis, 1,450+ backend tests — designed, built and operated by a team of one.

20countries
40M+establishments
1,450+tests
PythonFastAPIPostgreSQL
Lire l'histoire
Brigade de sapeurs-pompiers de Paris (BSPP) · Sept 2017 - 2021 2 sources

Enterprise data warehouse fed from a 250-system application landscape (Paris Fire Brigade)

An operational data warehouse centralising 7+ operational and management domains for an 8,500-person institution, feeding the Power BI reporting teams — and a monitored loading layer plus written…

~250source information systems
7+data domains
8,500+personnel
SQL ServerSSISPower BI
Lire l'histoire
Comité international de la Croix-Rouge (CICR) · Dec 2021 - Oct 2023 3 sources

Data integration for ICRC humanitarian programmes across 90+ countries (CRM Dynamics)

Three humanitarian programmes migrated and kept fed, Power BI analyst teams served from the integrated data, and the full SSIS estate upgraded to SQL Server 2022 with no interruption to…

90+countries
3CRM Dynamics programmes
SSISSSISDBSQL Server
Ville de Lausanne (SOI/SIL) · Nov 2023 - May 2024 1 source

CDC replication platform with four operating modes and its own monitoring stack (City of Lausanne)

A configurable, resilient CDC platform in operation across several environments, where replication integrity is proven by an automated source/target diff rather than assumed — and where a source that…

4operating modes
1upstream PR
Apache KafkaDebeziumKafka Connect
Lire l'histoire
Feb 2026 - present 2 sources

Designed an agent-native write surface — 50+ MCP tools over real career data, every mutation reversible

A live connector that a user's own assistant drives end to end: it searches, benchmarks, tailors a CV and publishes a public case study without the user opening the app.

50+tools
21writable fields on the showcase alone
MCP (Model Context Protocol)PythonFastAPI
2017 - 2026 (intermittent) 2 sources

Building-level emergency coverage engine — 3.3M buildings, GPU-accelerated, 5 cities

Coverage computed at building level over 3.3M buildings and 464k road segments for Paris / Île-de-France, against a legacy operational picture of 77 static sectors.

3.3Mbuildings
464kroad segments
5cities
C++17RoutingKitCUDA
Lire l'histoire
Brigade de sapeurs-pompiers de Paris (BSPP) · Sept 2017 - 2021 2 sources

Reconstructed call load and on-duty skills from raw switch logs — fine grain to multi-year zoom, for France's largest emergency call platform

Call load and on-duty skills readable at any zoom, from the finest grain to several years in a single view, with no wait at either end.

811,429calls
3emergency numbers
SQL ServerSSISMaster Data Services
Lire l'histoire
2019 - 2020 6 sources

Took a fire brigade's response-time problem to the Collège de France and an ENS Paris data challenge

The challenge opened in June 2019, ran to completion with three ranked winners, and is still hosted on ENS Paris's Challenge Data platform.

219ktraining records
3prediction targets
PythonMachine LearningOpen Data
2025 - 2026 Déclaré

Automated FX research pipeline — 16 years of tick data, walk-forward validation, 5 services running unattended

Three independent strategies validated out-of-sample across 16 years, running autonomously in paper trading with hourly cycles, weekly self-retuning and 5-minute monitoring — no manual intervention.

16years of data
8currency pairs
5services
Pythonscikit-learnXGBoost

Prouvé dans les réalisations

Expertise technique

  • Pythondans 6 projets
  • PostgreSQLdans 5 projets
  • Dockerdans 4 projets
  • Data Integrationdans 3 projets
  • ETL designdans 3 projets
  • SSISdans 3 projets
  • SQL Server (2008R2–2022)dans 3 projets
  • T-SQLdans 3 projets
  • FastAPIdans 3 projets
  • GitLab CI/CDdans 3 projets
  • Machine Learning (LightGBM, XGBoost, CatBoost)dans 3 projets
  • Data Warehousedans 2 projets
  • Power BIdans 2 projets
  • Apache Kafkadans 2 projets
  • SQLAlchemydans 2 projets
  • Redisdans 2 projets
  • Master Data Servicesdans 2 projets
  • Operational Data Store (ODS)dans 1 projet
  • LLM integration (Claude, GPT, Gemini, Grok, DeepSeek)dans 1 projet
  • Debeziumdans 1 projet
  • Change Data Capture (CDC)dans 1 projet
  • MCP (Model Context Protocol)dans 1 projet
  • Embeddings and vector search (pgvector)dans 1 projet
  • PostGISdans 1 projet
  • PowerShelldans 1 projet
  • Gitdans 1 projet
  • KingswaySoftdans 1 projet
  • Microsoft CRM Dynamicsdans 1 projet
  • Azure DevOpsdans 1 projet
  • Flaskdans 1 projet
  • C++17dans 1 projet
  • CUDAdans 1 projet
  • Prometheusdans 1 projet
  • Grafanadans 1 projet
  • MinIOdans 1 projet
  • JFrog Artifactorydans 1 projet
  • Bashdans 1 projet

Prouvé par l'expérience

  • JavaScript6 ans
  • Linux2 ans
  • Team Foundation Server2 ans
  • Snowflake<1 ans
  • Azure Databricks<1 ans
  • Apache Spark<1 ans
  • Portainer<1 ans

A aussi travaillé avec

LLM cost routingnginxdbt

Parcours

  1. Independent Data Engineer / Data Consultant

    Python · FastAPI · PostgreSQL · pgvector · Redis · Docker · GitLab CI/CD · Linux

    • Multi-source ingestion chain — 54 declared sources with daily indexing and health telemetry
    • Production data infrastructure deployed on dedicated servers (Hetzner)
    • AI-powered matching platform (web, mobile and automated agent)
  2. Data Consultant — Proof of Concept, energy sector · Energy-sector client (unnamed)

    Azure Databricks · Apache Spark · Kafka · GitLab CI/CD · Portainer · Snowflake

    • PoC data pipeline with Azure Databricks and Apache Spark for the energy sector
  3. Data Consultant — CDC / Data Replication Engineer · Ville de Lausanne (SOI/SIL)

    Apache Kafka · Debezium · Docker · Python · GitLab CI/CD · PostgreSQL · PostGIS · MinIO

    • CDC replication platform with four operating modes and its own monitoring stack (City of Lausanne)
  4. Data Consultant — Data Integration Engineer · Comité international de la Croix-Rouge (CICR)

    SSIS · SQL Server · Microsoft CRM Dynamics · KingswaySoft · Azure DevOps · Team Foundation Server · Git · T-SQL

    • Data integration for ICRC humanitarian programmes across 90+ countries (CRM Dynamics)
    • Data migration for Resolve — missing persons and human remains management (CRM Dynamics)
    • Data migration for Family Visit Program — management of Palestinian prisoner family visits
  5. Data Architect · Brigade de sapeurs-pompiers de Paris (BSPP)

    SQL Server · SSIS · Power BI · PostgreSQL · MySQL · Apache Kafka · Redis · Python

    • Enterprise data warehouse fed from a 250-system application landscape (Paris Fire Brigade)
    • Launched the DS4ES open-source initiative — data science for emergency services
    • Led the data team running the warehouse — including former firefighters retraining into technical roles
  6. Data Warehouse Developer / BI Developer · Brigade de sapeurs-pompiers de Paris (BSPP)

    SQL Server · SSIS · Power BI · Master Data Services · JavaScript · Python · PowerShell · Bash

    • Reconstructed call load and on-duty skills from raw switch logs — fine grain to multi-year zoom, for France's largest emergency call platform
    • Data challenge launched with ENS Paris on emergency unit response time prediction
    • Governed the telephony reference data with Master Data Services before any report was built on it
  7. IT / BI Assistant · Brigade de sapeurs-pompiers de Paris (BSPP)

    SQL Server · Power BI · Power Query · Python · T-SQL

    • Modelled an optimal resource deployment system for emergency services (engineering thesis)
    • Supported the warehousing and analytics programme of the steering, audit and control office, reporting to the brigade's high command

À propos

Data integration and warehousing engineer. I build the layer between operational systems and the people who have to decide on them: Operational Data Stores, ETL/ELT pipelines, CDC replication, enterprise data warehouses — and, for the last two years, the LLM and vector layer on top of them. Ten years of it in places where a broken flow has consequences: emergency services, humanitarian operations, government.

What I care about is whether people still trust the numbers eighteen months later. Most of what I build that nobody asked for — load monitoring, source/target diffs, written practice — is aimed at that.

At the Paris Fire Brigade I led the data team that ran the warehouse, including former firefighters retraining into technical roles, and became the institution's internal referent on the Microsoft BI stack. The ICRC, Lausanne and Brigade engagements are documented in the proof cards above, each with links you can check yourself — so they are not repeated here.

Core stack: SQL (T-SQL, PL/pgSQL), SSIS, SQL Server, PostgreSQL/PostGIS, Python (8+ yrs), Apache Kafka, Debezium, Microsoft CRM Dynamics, KingswaySoft, Master Data Services, Power BI, Docker, GitLab CI/CD, Linux. AI: LLM integration (Claude, GPT, Gemini, Grok, DeepSeek), model routing and cost control, MCP, embeddings and pgvector. Also: dbt, Snowflake, Databricks, Spark, FastAPI, Redis, C++/CUDA.

Former Paris firefighter — seven years operational before teaching myself to code and earning a CNAM engineering degree. That background is why I build for the case where the system is degraded, not only for the happy path.

Based in Annecy, France. Open to permanent roles and freelance missions — on-site in Haute-Savoie / Geneva, hybrid, or remote. French native, professional English.

Diplômes · Certifications

  • Diplôme d'ingénieur — informatique, modélisation et optimisationConservatoire national des arts et métiers (CNAM)
  • DUT Génie électrique et informatique industrielleUniversité Paris-Sud (Paris XI)
  • Diplôme d'agent de préventionBrigade de sapeurs-pompiers de Paris
  • Certificat de chef de garde d'incendie et de secoursBrigade de sapeurs-pompiers de Paris
  • Diplôme de chef d'agrès de sapeur-pompier volontaireSDIS 78 — Yvelines
  • Titre homologué de chef d'agrèsBrigade de sapeurs-pompiers de Paris
  • Certificat de compétences de formateur de PSC 1Brigade de sapeurs-pompiers de Paris
  • Diplôme de formateur de premiers secours en équipe (PSE 1 et PSE 2)Brigade de sapeurs-pompiers de Paris
  • Moniteur de secourisme — formateur aux premiers secoursBrigade de Sapeurs-Pompiers de Paris — filière sapeurs-pompiers
  • Initiation à la prévention contre les risques d'incendie et de paniqueBrigade de sapeurs-pompiers de Paris

Échangeons.

Available immediately

Berhault Benjamin

Berhault Benjamin

Senior Data Engineer · Annecy