Data Scientists’ Salaries
This project was done to analyze the salaries of data scientist jobs from 2020 to 2023. The questions I aim to answer are:
1) What are the top 10 paying data scientist jobs?
2) What countries are most employing companies located in?
3) What is the average salary at each experience level?
4) Are there more remote employees than onsite employees?
This project was done using Microsoft Excel and Tableau.
The stages involved in this project are
· Collection of Data
· Processing
· Analyzing and Visualization
· Report Writing
Collection of Data
The data set was gotten from Kaggle [click here to see the dataset] and loaded into Microsoft Excel.
The data contains 11 columns and 3,755 rows of data.
Processing
Upon loading the data into Excel, I noticed how untidy the data was so the next step was to clean it.
Some of the columns had data input in abbreviations such as the experience level and company size. With further research, I found what each of the abbreviations meant and corrected them to make the data clearer.
Both columns containing countries’ names had the countries input with their ISO code, making it hard to know what country was being referred to.
The data contained no headers and the salaries column was not formatted.
ML Engineer and Machine learning engineer were listed as two separate job titles though they were the same
The data cleaning was done using Power Query on Microsoft Excel.
Analyzing and Visualization
This was done on Tableau. I imported the clean data into Tableau to get more insight into the data and create charts to visualize the data.
Question 1: What are the top 10 paying data scientist jobs?
Based on the average salary earned, data science tech lead is the highest-earning data science job title followed by cloud data architect and data lead. The other top 10 earning job titles are shown above.
Question 2: What countries are most employing companies located in?
Most of the companies are in the USA with the country having a total of 3,040 total companies followed by Great Britain and then Canada.
Question 3: What is the average salary at each experience level?
Entry-level typically denotes a position normally assigned to a recent graduate or person without prior experience in the field or profession. It usually requires 0 -2 years of experience.
Mid-level requires 2- 5 years of experience, and Senior-level requires 5–10 years.
Executive-level positions are responsible for leading a company by overseeing its financial well-being, setting a vision and creating a growth strategy for a business. it requires at least 10 years of experience.
The employees at the executive level earn more than everyone else at each company size followed by those at the senior level then mid-level with the entry-level employees coming in last.
Question 4: Are there more remote employees than onsite employees?
51.21% of the employees work on-site with 43.75% working remotely. The employees with hybrid roles make up 5.03% of the total percentage.
Conclusion
The followings are the findings in addition to the answers gotten from the analysis done:
1) The data set contains data on only 94 data scientists’ job titles.
2) Most of the employees (3,004 out of 3755) are in the United States of America
3) Most of the employees are full-time employees
4) 83.97% of the employing companies are medium-sized.
Limitations:
The data set contains only 92 data scientist job titles located in 72 countries with a total of 3755 employees which might not be an accurate representation of data scientists’ jobs globally.
