Jobs in Response: COVID-19

Avatar
Posted on May 4, 2020

Background on COVID-19:

COVID-19 is a global pandemic that has affected close to 3.5 million people worldwide. It has been around for about 4 months in the US at this point and has completely altered the majority of the population's day to day lives. Businesses that have been deemed nonessential have been closed down or have had to change their schedules. Non-essential workers have been told to stay home and not take part in large gatherings. Even schools have been closed down, having teachers teach from home and students learn from home. Due to all of these changes many businesses aren’t doing well and have had to make cuts to stay afloat.

Unemployment during COVID-19:

The unemployment rate has gone up considerably since COVID-19 hit the US. According to the Bureau of Labor Statistics, as of March 2020, the unemployment rate has risen to 4.4 percent. This is 0.9 percent higher than it was in February 2020. As a reference, this is the largest over-the month increase in the unemployment rate since 1975.

Are all jobs declining?

The unemployment rate had me a bit worried, but it got me thinking about jobs that were more in demand due to COVID-19. Which job titles became more in demand because of COVID-19? Which companies are looking to hire these positions? What were their salaries? Which areas needed these jobs more?

Data Gathering:

In order to answer these questions I went to indeed.com, which is notably one of the biggest job posting sites. I searched for COVID-19 and left the salary range and location fields blank, so it would search solely based on COVID-19. I then scrapped 500 pages worth of job postings, which amounted to 5,000 jobs. I scraped for the job titles, companies, salary, location, summary, and requirements of the job.

Analysis of Data:

The first portion of the data I wanted to analyze was the locations that were looking to hire. The results are shown in the graph below.

Job Locations

After going through the analysis, it also got me thinking of what areas were most affected by COVID-19 and after some research I was able to find a map of affected areas as shown below.

COVID-19 Map

As we can see from the map and the graph from my analysis, the areas that seem to be looking to hire seem to correlate with the areas of the map that were heavily affected by COVID-19. NY seems to be one of the most affected areas and is listed twice in the graph. I also noticed that remote jobs were in the top 10, which makes a lot of sense since many people are expected to work from home.

The second portion of the data I analyzed was the job titles that were most in demand. The results are shown below.

Job Titles

As shown in the graph, the job that seems to be the most in demand is Universal Service Worker by an overwhelming amount. This makes a lot of sense, since Universal Service Workers are essentially all-rounders when it comes to patient care. They do everything from testing for COVID-19 to regular day to day tasks. After Universal Service workers, there are a variety of other medical profession jobs, such as medical assistants and registered nurses. The two that were surprising at first to me were sales representatives and java developers, but after thinking about it, more companies are probably looking for more sales representatives to take orders and run customer service remotely and java developers are needed to maintain e-commerce portals which are also vital at this point. Next, I moved on to which companies were looking to hire.

The results from my analysis of companies that were looking to hire are shown below.

Hiring Companies

As shown in the graph, the majority of companies that were looking to hire were medical facilities, such as senior living homes and healthcare programs, as well as IT consultant companies. This also makes a lot of sense because the universal workers would more than likely be working at these types of medical facilities. The IT consultant companies also make sense, since many companies would be trying to get remote setups for their workers at home as well as the IT infrastructure at the office along with IT support. There were also a few companies I was not expecting, such as McDonalds and Performance Columbus (which is a string of dealerships). I would assume this was due to the rise of UberEats and other food delivery services, fast food companies are looking for more delivery drivers, since many people are not leaving their houses. Finally, I looked into the salaries of the relevant COVID-19 jobs.

The results of my analysis are shown in the table shown below.

Salary Variance

As shown in the table there was extreme variance in the salaries of the jobs, especially since they were not all structured the same way. Some of the jobs were “by the hour”, while others were “a month”, or “a day”, and some had a range. In order to make the salaries more uniform, I converted all of the salaries to annual salaries. After doing so I ran some analysis to extract the following information:

Minimum Salary: $17,600

Maximum Salary: $176,000

Average Minimum Salary: $39,564

Average Maximum Salary: $42,377

Conclusion:

In conclusion, I was able to answer the questions I originally posed. The locations that are looking to hire people in response to COVID-19 are the locations that were affected the most from it such as big cities like New York. The job titles that were most in demand were Universal Service Workers, which made sense when looking at the companies that were hiring the most, since most of them were medical facilities. There were a few interesting jobs, such as Sales Representatives and Java Developers which I didn’t expect, but after doing a bit of research made more sense. As well as a few interesting companies, such as McDonalds and Performance Columbus. I was also able to compute a salary range for the sample of jobs that I analyzed, though there was a lot of variance. The median salary looked to be around $41,000 dollars annually, which corresponds with the number one spot in the top 20 table shown above or $20 an hour.

Future Analysis:

There are a few more things I still want to do with this analysis, such as utilize the summaries and job requirements to gain more insight of what type of qualifications employees would need for the jobs. I would like to use a date range from the time COVID-19 started to present to see if the types of jobs would change and if there are any trends in the types of companies and positions based on the timing.

About Author

Avatar

Anthony Ali

Anthony Ali has a background in Cyber-Security with a Bachelors degree in Network Forensics and Intrusion Investigation. He is a CISSP certified security analyst with industry skills in threat management, security risk identification and mitigation, and security infrastructure....
View all posts by Anthony Ali >

Leave a Comment

No comments found.

View Posts by Categories


Our Recent Popular Posts


View Posts by Tags

#python #trainwithnycdsa 2019 airbnb Alex Baransky alumni Alumni Interview Alumni Reviews Alumni Spotlight alumni story Alumnus API Application artist aws beautiful soup Best Bootcamp Best Data Science 2019 Best Data Science Bootcamp Best Data Science Bootcamp 2020 Best Ranked Big Data Book Launch Book-Signing bootcamp Bootcamp Alumni Bootcamp Prep Bundles California Cancer Research capstone Career Career Day citibike clustering Coding Course Demo Course Report D3.js data Data Analyst data science Data Science Academy Data Science Bootcamp Data science jobs Data Science Reviews Data Scientist Data Scientist Jobs data visualization Deep Learning Demo Day Discount dplyr employer networking feature engineering Finance Financial Data Science Flask gbm Get Hired ggplot2 googleVis Hadoop higgs boson Hiring hiring partner events Hiring Partners Industry Experts Instructor Blog Instructor Interview Job Job Placement Jobs Jon Krohn JP Morgan Chase Kaggle Kickstarter lasso regression Lead Data Scienctist Lead Data Scientist leaflet linear regression Logistic Regression machine learning Maps matplotlib Medical Research Meet the team meetup Networking neural network Neural networks New Courses nlp NYC NYC Data Science nyc data science academy NYC Open Data NYCDSA NYCDSA Alumni Online Online Bootcamp Online Training Open Data painter pandas Part-time Portfolio Development prediction Prework Programming PwC python python machine learning python scrapy python web scraping python webscraping Python Workshop R R language R Programming R Shiny r studio R Visualization R Workshop R-bloggers random forest Ranking recommendation recommendation system regression Remote remote data science bootcamp Scrapy scrapy visualization seaborn Selenium sentiment analysis Shiny Shiny Dashboard Spark Special Special Summer Sports statistics streaming Student Interview Student Showcase SVM Switchup Tableau team TensorFlow Testimonial tf-idf Top Data Science Bootcamp twitter visualization web scraping Weekend Course What to expect word cloud word2vec XGBoost yelp