Last month, I used AngelList data to analyze the technologies that startups use. After getting positive feedback on my analysis, I decided to dig into more AngelList data — this time looking at job postings. There is a lot of job posting data available via API, and Joshua Slayton from AngelList was kind enough to send me some additional data that is not available via API.
This series will consist of 3 separate blog posts:
Part 1: Basic stats about popular startup locations, job titles, vesting schedules, etc. [Full disclosure: this is the least interesting/actionable post in the series]
Part 3: Factors that contribute to successful job postings. [ETA October, assuming my data analysis skills are good enough to come up with useful insights]
I took a snapshot of all jobs on AngelList on August 31st, 2014. There were 12610 jobs posted at the time.
Please note that this is an analysis of companies found on AngelList, which creates some expected biases. For example, the data will be biased toward earlier stage startups, and away from startups in non-English-speaking countries.
Top 20 cities
|City||# of open jobs|
|New York City||1676|
Next, I removed all cities that had 3 or fewer jobs (about 5% of all jobs) and categorized the remaining cities into geographic areas.
Jobs in each major geographic area
|Geographic Area||# of open jobs|
|US (minus Silicon Valley, NY, SoCal)||2282|
Notable observations: SF, LA, and NYC make up almost 50% of all jobs on AngelList. Within Silicon Valley, 2/3 of all jobs are in SF and 1/3 are in Mountain View/Palo Alto/etc.
Openings per company
|# of openings at startup||# of startups|
Notable observations: About 60% of openings are at companies that list <=3 jobs, 35% are at companies that list 4-10 jobs, and the last 5% are at a handful of companies that have 11 or more open positions.
Job Opening Types
|Type||# of open jobs|
Most common vesting periods
|Vesting period||# of open jobs|
Most common vesting cliffs
|Vesting cliff||# of open jobs|
Notable observations: 4 year vesting with a 1 year cliff is by far the most common equity vesting set-up.
|Role||# of open jobs|
(The counts in the second column add up to a little more than 12610 because some jobs were tagged with multiple roles.)
Skills mentioned in at least 500 job openings:
|Skill||# of open jobs|
|Ruby on Rails||1211|
|Sales and Marketing||1089|
|HTML5 & CSS3||952|
|User Experience Design||816|
|Social Media Marketing||604|
|Amazon Web Services||503|
Skills mentioned in 250-499 openings: Angular.JS, Objective C, Sales, UI/UX Design, HTML/CSS/PHP/MYSQL, Product Development, Ruby, Mobile Application Design, Mobile Development, User Interface Design, SQL, Backbone.js, Django, PostgreSQL, Linux, Git, APIs, Sales Strategy and Management, Product Marketing, Mobile, Data Analysis, RESTful Services, and Social Media.
Skills mentioned in 100-249 openings: Big Data, Graphic Design, Hadoop, Adobe Photoshop, Web Design, Web Development, Redis, C++, Mobile Application Development, Photoshop, Product Management, Machine Learning, Software Engineering, SEO/SEM, iOS, REST APIs, Customer Service, noSQL, Twitter Bootstrap, Front-End Development, C, Databases, SaaS, AngularJS, JSON, Business Operations, C#, Growth Hacking, Marketing, Scala, Analytics & Reporting, Adobe Illustrator, Online Marketing, AJAX, Communication Skills, Project Management, E-Commerce, Customer Relationship Management, Full-Stack Web Development, Web Analytics, Sales/Marketing and Strategic Partnerships, Coffeescript, Business Strategy, Account Management, Community Management, Content Marketing, Writing, Backend Development, Amazon EC2, Advertising, .NET, Visual Design, Agile Software Develoment, Software Development, Google Analytics, Adobe Creative Suite, Heroku, and Algorithms.