Portrait of Marcel Pauly

Marcel Pauly

Data journalist

About me

My name is Marcel Pauly, and I’m a data journalist based in Hamburg, Germany, with more than a decade of experience. Since 2017, I’ve worked at DER SPIEGEL, a leading German news magazine, where I’m part of the Data and Visualization desk.

My beat is political data: I investigate transparency and influence in German politics, analyze election results, calculate polling averages and simulate election outcomes. I code in Python, scrape websites and use LLMs to turn unstructured text and documents into structured datasets. I build automated dashboards and am responsible for the technology that updates election results on SPIEGEL.de in real time on election nights.

After studying communication studies, political science and German studies at Johannes Gutenberg University Mainz, I trained at the Henri Nannen School of Journalism in Hamburg. I honed my data journalism skills through the Lede Program at Columbia Journalism School in New York City.

I shared responsibility for the data reporting on investigations that have won awards, including the Georg von Holtzbrinck Prize for Business Journalism and the Helmut Schmidt Journalism Prize. Other projects were nominated for the German Reporter Award and the Grimme Online Award.

Portfolio

A selection of investigations and projects. Most of the articles are in German.

Coalition Calculator

Before elections, we calculate each coalition’s chances of winning a majority from current polls and their historical accuracy. Most recently for the 2026 Mecklenburg-Western Pomerania state election.

  • Elections
  • Polls
  • Data Analysis

Poll Tracker

To get a more stable picture of voting intentions, we average polls from different pollsters for the German federal election. Simulated election outcomes make the remaining uncertainty tangible.

  • Elections
  • Polls

Election Juggler

I built the tool that processes results data on election nights and feeds our live graphics, using FastAPI and real-time WebSocket updates. Most recently for the 2026 US midterms.

  • Elections
  • Automation

Population Change Since 1871

For the first time, we were able to show how the population of each city, municipality and municipal association in Germany has changed over more than 150 years.

  • Demographics
  • Data Analysis

The Nazi Card Index

We used AI to make the Nazi Party membership card index searchable, and we scraped additional archival material to provide further context.

  • Right-Wing Extremism
  • Data Analysis
  • Scraping
  • AI

Local Climate Change

Here, I’m responsible for the real-time data processing: For hundreds of weather stations, we show how current temperatures fit into the climate trend of recent decades.

  • Global Warming
  • Automation

Party Voter Profiles

Using data from the representative electoral statistics, I show how the parties’ voter bases were composed in the 2025 federal election and how they have changed since previous elections.

  • Elections
  • Data Analysis

AfD Assessment

We digitized more than a thou­sand quotes from AfD officials and made them searchable. The domestic intelligence service cites them as evidence that the party is anti-constitutional.

  • Right-Wing Extremism
  • Investigative
  • Scraping

How the TikTok Algorithm Works

In an experiment, we were able to show how TikTok’s recommen­dation algorithm works and how quickly it can steer users into problematic niches.

  • Social Media
  • Algorithms

Allegations Against the Destatis President

Employees of the Federal Statis­tical Office accused the agency’s then-president of a dehumanizing leadership style and of creating a “climate of fear.”

  • Investigative

Optimal Electoral Districts

Reducing the number of electoral districts, as is often discussed, would require redrawing the entire map. I met the mathema­tician who developed an algo­rithm for the optimal division.

  • Electoral System
  • Algorithms

Black Box Schufa

We uncovered how consumers can end up with a negative score at Germany’s most important credit bureau through no fault of their own — with consequences for cell phone, loan and rental contracts.

  • Algorithms
  • Investigative

Esotericism at Taxpayers’ Expense

For a cover story in DER SPIEGEL on questionable health seminars, I scraped and analyzed the course catalogs of hundreds of adult education centers.

  • Investigative
  • Data Analysis
  • Scraping

Contact

Email: marcel.pauly@spiegel.de

Secure channels

For confidential tips, you can also reach me via:

  • Signal: marcelpauly.01
  • PGP key: 2EE9 45FC F68D F60A C1CB 50D9 FD1D BC11 C392 53FD (.asc)