Glassdoor Analysis:
Data Jobs In USA

๐Ÿ’ผ About the Project

The job market in data-related fields is rapidly evolving, with high demand for skilled professionals in various industries. This project aims to scrape job listings for Data Analyst, Data Scientist, and Data Engineer positions from Glassdoor in five major US cities: Seattle, Austin, Los Angeles, New York, and San Francisco. The collected data will be used for further analysis, visualization, and predicting trends in the job market.

Tools used

  • python 3.8
  • Sellenium

Project Repository

GitHub Repository

๐Ÿšฉ Problem Statment

The available public job datasets are not reliable for understanding the current job market as they become outdated within a short period of time.

To gain a more accurate understanding of the current job market trends, we aim to scrape the job board website Glassdoor, which provides up-to-date job postings. By analyzing this data, we can explore the current job market conditions and make more informed decisions about our future career paths.

๐Ÿง Research Questions

The project aims to answer the listed questions (Job titles selected in the interest of the author)

  • Which city has the most job openings?
  • How much expected salary of data analyst and data scientist differ by location?
  • Which data job offers the highest salary?

  • ๐Ÿ“ˆ Workflow

    1. Data Scraping
    2. Data Cleaning
    3. Data Analysis

    โ„น๏ธ Data Scraping

    Using browser automation package Seleninum to scrape the data from the glassdoor website. Below is example data table.

    ๐Ÿงผ Data Cleaing

    Data cleaning process aims to clean any null values or miss scraped columns using python

    ๐Ÿ“Š Data Analysis

    Data cleaning process aims to clean any null values or miss scraped columns using python
    In-depth analysis using NLP for Job title & Skillset

    ๐Ÿš€ Key Insights

  • New york city(NY) has the most job openings followed by Seattle(WA) and Austin(TX)
  • In terms of Data analyst jobs, New York offers the highest salary and Connecticut offers highest salary for the data scientist jobs
  • Information technology scetor shows the highest salary for both data scientists and analysts.