What 3,500 job postings say about city

Looking at city across the 3,500 postings in data-job-postings.

• San Francisco — 15.2% of postings
• New York — 14.1% of postings
• London — 12.5% of postings
• Bengaluru — 11.9% of postings
• Berlin — 9.5% of postings

The dataset is synthetic, so treat the levels as illustrative rather than as market data. What is not illustrative is the shape of the problem, which is built in on purpose: the distribution is lopsided, and a single summary number about it will be quoted in a salary negotiation by someone who did not see the spread.

select city, count(*) as postings
from data_job_postings
group by 1
order by postings desc;

The practical version, for anyone reading postings rather than analysing them: a posting is a wish list written by someone who is not going to get everything on it. Read the first three requirements as real and the rest as aspirational, and apply when you match roughly half.

The data career, mapped has the roles, the levels and the transitions between them.