Author: Jaime M. Shaker
Email: jaime.m.shaker@gmail.com
Website: https://www.shaker.dev
LinkedIn: https://www.linkedin.com/in/jaime-shaker/
Dataset Created By: Luke Barousse (LinkedIn | YouTube)
Dataset: Data Analyst Job Postings [Pay, Skills, Benefits]
This SQL project is based on Data Analyst Job Postings [Pay, Skills, Benefits] dataset by Luke Barousse hosted on Kaggle.
This repository provides an SQL analysis of employment listings scraped from Google job search results. The dataset spans from November 4, 2022 through September 9, 2023 using PosgreSQL within a Docker container.
The goal of this analysis is to gain insight into the skills that are frequently mentioned in the job descriptions, frequency of job postings and basic salary statistics.
- SQL Analysis (Markdown File)
- Build SQL Tables (SQL File)
- SQL Analysis (SQL File)
The complete, updated daily dataset can be found on Kaggle. Github restricts file sizes to under 100mb. Because of this restriction, I have split the current CSV (2022-11-04 through 2023-09-09) into standard calendar quarters (Q1, Q2, Q3, Q4).
- gsearch_jobs_2022.csv:
- gsearch_jobs_2023_q1.csv: (Jan/Feb/Mar 2023)
- gsearch_jobs_2023_q2.csv: (Apr/May/Jun 2023)
- gsearch_jobs_2023_q3.csv: (Jul/Aug/Sep 2023)
❗ If you find this repository helpful, please consider giving it a ⭐. Thanks! ❗