Data Analytics Jobs: Where, When, and How to Find Your Dream Role
Data analytics jobs are in high demand across various industries and sectors, as they offer useful insights to enhance businesses, satisfy customers, and create positive changes in society. But what does it take to become a data analyst? What are the skills, qualifications, and expectations for this role? How much do data analysts earn and where do they work? When is the best time to look for data analysis jobs? These are some of the questions that I will try to answer in this article, using a real-world dataset of over 26,000 job postings for data analytics positions.
In my previous article, I showed you how I cleaned and prepared the data using Pandas, a powerful Python library for data manipulation and analysis. You can read that article here;
In this article, I will share some interesting insights I got from analyzing the data using PostgreSQL and Tableau. I will answer the following questions:
- How many jobs are there for each job title?
- Where are most data analysis jobs located?
- What are the top skills for data analysis jobs?
- What kind of work schedule do data analysis jobs offer?
- Which company offers more opportunities for data analysts?
- Which website has more data analysis job listings?
- When is the best time to look for data analysis jobs?
- How does the pay vary for different data analysis titles?
If you are curious to learn more about these questions, then keep reading. I hope you will find this article informative and engaging. Let's get started!
Data Source
This analysis is based on a Luke Barousse’s job postings dataset of 26,368 job postings with different job titles.
NOTE⚠️: The dataset is highly biased towards the Data analyst category, which accounts for 86% (23,731) of the total data. The other categories are much less represented, with the following percentages and counts:
Engineer/Scientist: 0.09% (24)
Analyst/Engineer: 1.59% (420)
Scientist: 3.05% (805)
Analyst/Scientist: 1.29% (339)
Engineer: 1.2% (316)
Other: 6.58% (1733)
What are the top skills for data analysis jobs?
-- Count the occurrence of each keyword in job descriptions, ordered by keyword count in descending order
SELECT UNNEST(description_tokens) AS keyword, COUNT(*) as keyword_count FROM job_data
GROUP BY keyword
ORDER BY keyword_count DESC;
The chart reveals common keywords in job descriptions. "SQL" is most frequent (14,102 times), followed by "excel" (9,328 times), "python" (7,814 times), and "tableau" (7,654 times). This indicates that job postings in data analytics frequently require programming and data analysis skills."
What kind of work schedule do data analysis jobs offer?
-- Count the number of jobs per schedule type
SELECT schedule_type, COUNT(*) as job_count
FROM job_data WHERE schedule_type IS NOT NULL
GROUP BY schedule_type
ORDER BY job_count DESC;
The chart displays job schedule types. Full-time is the most common with 20,316 jobs, followed by Contractor at 6,447 jobs, then Part-time with 281 jobs, and Internship with 150 jobs. This tells us that the majority of positions are full-time, yet there are also part-time, contract, and internship opportunities available.
When is the best time to look for data analysis jobs?
-- Count the number of job postings per month, ordered by the number of jobs posted
SELECT (EXTRACT(’month' FROM date)) AS month, COUNT(EXTRACT(’month' FROM date))
FROM job_data
GROUP BY month
ORDER BY count DESC;
The chart displays job postings by month, with January having the most (3,682), followed by December (3,329), October (2,892), and February (2,828). This suggests that the majority of job postings occur during the first quarter of the year.
Which company offers more opportunities for data analysts?
-- Count the number of job postings from each company
SELECT company_name, COUNT(company_name) FROM job_data
GROUP BY company_name
ORDER BY count DESC;
The chart lists top companies posting jobs. Upwork leads with 4,277 jobs, followed by Walmart (937), EDWARD JONES (730), and Corporate (607). This tells us that big companies tend to hire extensively for data analytics roles.
Which website has more data analysis job listings?
-- Count the number of job postings made through each posting channel
SELECT via, COUNT(via) FROM job_data
GROUP BY via
ORDER BY count DESC;
The chart shows job posting channels. LinkedIn is the primary channel with 8,767 jobs, followed by Upwork (4,258), BeBee (2,268), and Trabajo.org (1,993). This insight helps us focus our job search on the right platform.
How does the pay vary for different data analysis titles?
-- Calculate salary statistics (minimum, maximum, average, median) per title
SELECT title_group, MIN(salary_standardized) minimum_salary, MAX(salary_standardized) maximum_salary, ROUND(AVG(salary_standardized),2) average_salary,
PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY salary_standardized) AS median_salary
FROM job_data
WHERE salary_pay IS NOT NULL
GROUP BY title_group
ORDER BY minimum_salary;
The chart illustrates salary variations by job title. Analyst roles have a minimum salary of $18,720 and a maximum of $624,000. The highest average salary ($142,825) is for the "Engineer" title group, with a median salary of $136,508. Overall, data analytics jobs generally offer high salaries, with a median of $93,778 and an average of $94,615.
Where are most data analysis jobs located?
-- Count the number of jobs per state, ordered by the number of jobs in descending order
SELECT state, COUNT(*) AS count
FROM job_data WHERE STATE IS NOT NULL
GROUP BY state
ORDER BY count DESC;
The map displays job postings by U.S. state. Missouri (MO) has the most (3,158), followed by Oklahoma (OK, 1,752), Kansas (KS, 1,617), and Arkansas. It helps identify where to find data analytics jobs.
You can find all the resources, including the source code for the preprocessing steps, SQL queries used for creating the table and loading data, and Tableau visuals, in my GitHub repository.
Conclusion
In this article, we used SQL to ask questions and Tableau to create charts. These tools helped us learn more about data analytics jobs, such as the top skills required, salary information, companies hiring, the best times to look for jobs, locations with abundant opportunities, and where to find job listings. We can use this information to secure a promising job in data analytics.
For even more precise analysis, explore Luke Barousse’s datanerd.tech project, which has analyzed 1,432,812 jobs and is continually growing. This project served as the source from which our dataset was sampled. For further learning or if you have any questions, please check out his YouTube channel.
I hope you enjoyed this article and found it useful. Thank you for reading!
