Analyzing Job Postings; A Cross Country Comparison

[This article was first published on Florian Teschner, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here)
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.

Writing my first post about the German data scientist job market, I was surprised to find such a low number of open positions. The scripts are easy to extend to a cross-country comparison. To simplify the analysis, this time I focused on the Indeed website only.

As a baseline, I scanned the websites for the number of open positions which contain the term “Excel”.

plot of chunk unnamed-chunk-2

We see a higher number of results for both search terms in the UK. The number of results are highly correlated (r=0.98)

plot of chunk unnamed-chunk-3

This is confirmed by looking at a scatter-chart. However, we see that Germany is already below the linear regression line (red).

fit <- lm(Positions.y ~Positions.x,data=m)
predict(fit, newdata = data.frame(Positions.x=c(28279)))
##        1 
## 261.1218

If we expect a linear relationship between both numbers and plug in the number of open “Excel”-Positions (28279), we see that Germany places well below the expected number (261). Moreover, the difference to the current number is with 74 missing positions quite big.

Another way to illustrate this missing number of positions is by charting the ratio between open Excel and Data Science positions. In the Netherlands, for 100 “Excel”-results, we get 2 “Data Scientist”” results.

plot of chunk unnamed-chunk-5

Germany ranks way at the bottom. Even France, usually a country which is not known to easily adapt English words (looking at you “ordinateur”), outranks Germany in terms of relative number of open Data Scientist positions. To sum up, the first impression that there are actually relatively few data jobs in Germany is supported with this analysis. It looks like there is media/press hype about data and analytics in Germany which does not manifest when looking the current job market.

Given the importance of data and analytics, let’s hope German HR is catching up soon.

I am curious to see if and how terms change in popularity, as before I intent to run this analysis on a regular basis. And finally, in case you are looking for a job; have a look over here.

To leave a comment for the author, please follow the link and comment on their blog: Florian Teschner. offers daily e-mail updates about R news and tutorials about learning R and many other topics. Click here if you're looking to post or find an R/data-science job.
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.

Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)