Data Job Market Analysis (SQL)

This project dives into the data analyst job market to uncover which skills are most in demand and which roles offer the highest salaries. By analyzing real job posting data, I aimed to find where high demand meets high pay—helping both myself and others target the right skills for breaking into data analytics.

View all SQL queries here

Background

As I transition into data analytics, this project helped me pinpoint top-paying roles and high-demand skills, cutting through the noise to focus on what actually matters when landing a job.

The data comes from Luke Barousse’s SQL for Data Analytics course, which includes job titles, salaries, locations, and technical skills.

The questions I wanted to answer through my SQL queries were:

1. What are the top-paying data analyst jobs?
2. What skills do these top-paying jobs require?
3. Which skills are most in demand for data analysts?
4. What skills tend to lead to higher salaries?
5. What are the most optimal skills for me to learn?

Tools I Used

To explore the data analyst job market and practice real-world SQL, I used the following tools:

• SQL: The core of my analysis—used to write queries, clean data, and extract insights directly from the database.
• PostgreSQL: My database of choice for this project. It handled all the job posting data and made querying efficient and reliable.
• Visual Studio Code: My go-to code editor for writing and running SQL queries with ease.
• Git & GitHub: I used Git for version control and GitHub to track progress and share my SQL scripts—great for documenting my learning and showing my work.

The Analysis

Each SQL query in this project explored a different aspect of the data analyst job market, answering practical questions that helped me align my skill development with high-demand roles.

1. Top Paying Data Analyst Jobs

I started by identifying the highest-paying data analyst roles. I filtered for jobs with non-null average yearly salaries and focused on remote positions, since that flexibility is important to me. This helped surface the most lucrative opportunities and gave me a benchmark for salary expectations in the field.

SELECT
    job_id,
    job_title,
    job_location,
    job_schedule_type,
    salary_year_avg,
    job_posted_date,
    name AS company_name
FROM
    job_postings_fact
LEFT JOIN company_dim ON job_postings_fact.company_id = company_dim.company_id
WHERE
    job_title_short = 'Data Analyst' AND
    job_location = 'Anywhere' AND
    salary_year_avg IS NOT NULL
ORDER BY
    salary_year_avg DESC
LIMIT 10;

Here's the breakdown of the top data analyst jobs in 2023:

• Wide Salary Range: The top 10 highest-paying data analyst roles range from $184,000 to $650,000, showing just how high the salary ceiling can be in this field.
• Diverse Employers: Companies like SmartAsset, Meta, and AT&T are offering top compensation, highlighting strong demand across industries—from tech to finance to telecom.
• Job Title Variety: High-paying roles span a wide spectrum of titles, from “Data Analyst” to “Director of Analytics,” reflecting the different levels of responsibility and specialization within the data analytics space.

Bar graph visualizing the salary for the top 10 salaries for data analysts; ChatGPT generated this graph from my SQL query results

2. Skills for Top Paying Jobs

To figure out what skills are actually required for the top-paying data analyst roles, I joined the job postings with the skills data. This helped me identify which tools and technologies employers are looking for when offering the highest salaries.

WITH top_paying_jobs AS (
    SELECT
        job_id,
        job_title,
        salary_year_avg,
        name AS company_name
    FROM
        job_postings_fact
    LEFT JOIN company_dim ON job_postings_fact.company_id = company_dim.company_id
    WHERE
        job_title_short = 'Data Analyst' AND
        job_location = 'Anywhere' AND
        salary_year_avg IS NOT NULL
    ORDER BY
        salary_year_avg DESC
    LIMIT 10
)
SELECT 
    top_paying_jobs.*,
    skills
FROM top_paying_jobs
INNER JOIN skills_job_dim ON top_paying_jobs.job_id = skills_job_dim.job_id
INNER JOIN skills_dim ON skills_job_dim.skill_id = skills_dim.skill_id
ORDER BY salary_year_avg DESC;

Here’s the breakdown of the most in-demand skills from the top 10 highest-paying data analyst jobs in 2023:

• SQL is leading with a count of 8.
• Python follows closely with a count of 7.
• Tableau is also very sought after with a count of 6. Other skills like R, Snowflake, Pandas, and Excel show varying degrees of demand.

Bar graph visualizing the count of skills for the top 10 paying jobs for data analysts; ChatGPT generated this graph from my SQL query results

3. In-Demand Skills for Data Analysts

This query helped identify the skills most frequently requested in job postings, directing focus to areas with high demand.

SELECT 
    skills,
    COUNT(skills_job_dim.job_id) AS demand_count
FROM job_postings_fact
INNER JOIN skills_job_dim ON job_postings_fact.job_id = skills_job_dim.job_id
INNER JOIN skills_dim ON skills_job_dim.skill_id = skills_dim.skill_id
WHERE
    job_title_short = 'Data Analyst' AND
    job_work_from_home = TRUE
GROUP BY 
    skills
ORDER BY 
    demand_count DESC
LIMIT 5;

Here's the breakdown of the most in-demand skills for data analysts in 2023:

• SQL and Excel lead, highlighting core skills in data querying and spreadsheets.
• Tools like Python, Tableau, and Power BI show the growing demand for programming and data visualization.

Skill	Demand Count
SQL	7,291
Excel	4,611
Python	4,330
Tableau	3,745
Power BI	2,609

Table of the demand for the top 5 skills in data analyst job postings

4. Skills Based on Salary

Exploring the average salaries associated with different skills revealed which skills are the highest paying.

SELECT 
    skills,
    ROUND(AVG(salary_year_avg), 0) AS avg_salary
FROM job_postings_fact
INNER JOIN skills_job_dim ON job_postings_fact.job_id = skills_job_dim.job_id
INNER JOIN skills_dim ON skills_job_dim.skill_id = skills_dim.skill_id
WHERE
    job_title_short = 'Data Analyst' 
    AND salary_year_avg IS NOT NULL
    AND job_work_from_home = TRUE
GROUP BY 
    skills
ORDER BY 
    avg_salary DESC
LIMIT 25;

Here's a breakdown of the results for top-paying skills for Data Analysts:

• High Demand for Big Data & ML Skills:
  Top salaries are commanded by analysts skilled in big data technologies (PySpark, Couchbase), machine learning tools (DataRobot, Jupyter), and Python libraries (Pandas, NumPy), reflecting the industry's high valuation of data processing and predictive modeling capabilities.

• Software Development & Deployment Proficiency:
  Knowledge in tools like GitLab, Kubernetes, and Airflow shows a strong crossover between analysis and engineering, with a premium on automation and pipeline management skills.

• Cloud Computing Expertise:
  Familiarity with Elasticsearch, Databricks, and GCP highlights the growing demand for cloud-native analytics, suggesting that cloud proficiency significantly boosts earning potential.

Skill	Average Salary ($)
PySpark	208,172
Bitbucket	189,155
Couchbase	160,515
Watson	160,515
DataRobot	155,486
GitLab	154,500
Swift	153,750
Jupyter	152,777
Pandas	151,821
Elasticsearch	145,000

Table of the most optimal skills for data analyst sorted by salary

5. Most Optimal Skills to Learn

To pinpoint the most strategic skills for career growth, I filtered for those that are both in high demand and tied to high average salaries in remote data analyst roles.

SELECT
    skills_dim.skill_id,
    skills_dim. skills,
    COUNT(skills_job_dim.job_id) AS demand_count,
    ROUND(AVG(job_postings_fact.salary_year_avg), 0) AS avg_salary
FROM job_postings_fact
INNER JOIN skills_job_dim ON job_postings_fact.job_id = skills_job_dim.job_id
INNER JOIN skills_dim ON skills_job_dim. skill_id = skills_dim. skill_id
WHERE
    job_title_short = 'Data Analyst'
    AND salary_year_avg IS NOT NULL
    AND job_work_from_home = True
GROUP BY
    skills_dim.skill_id
HAVING
    COUNT(skills_job_dim.job_id) > 10
ORDER BY
    avg_salary DESC,
    demand_count DESC
LIMIT 25;

Skill ID	Skill	Demand Count	Average Salary ($)
8	Go	27	115,320
234	Confluence	11	114,210
97	Hadoop	22	113,193
80	Snowflake	37	112,948
74	Azure	34	111,225
77	BigQuery	13	109,654
76	AWS	32	108,317
4	Java	17	106,906
194	SSIS	12	106,683
233	Jira	20	104,918

Table of the most optimal skills for data analysts sorted by salary

Based on my analysis of job postings, here's a breakdown of the most optimal skills to focus on as an aspiring data analyst:

• High-Demand Programming Languages:
  Python and R are consistently sought after, with demand counts of 236 and 148. While the average salaries for these are around $101,397 (Python) and $100,499 (R), their wide availability in the job market slightly levels out their earning potential. Still, they remain essential technical skills in any analyst’s toolkit.

• Cloud Tools and Technologies:
  Skills like Snowflake, Azure, AWS, and BigQuery show strong demand paired with above-average salaries. These tools are increasingly central to modern data analytics workflows, especially in cloud-first companies.

• Business Intelligence & Visualization Tools:
  Tableau (demand count: 230, avg. salary: $99,288) and Looker (demand count: 49, avg. salary: $103,795) reinforce the importance of being able to translate complex data into actionable insights through dashboards and visual storytelling.

• Database Technologies:
  Whether it's traditional systems like Oracle and SQL Server or modern NoSQL databases, these skills are still highly relevant. With salaries ranging from $97,786 to $104,534, database fluency supports both data integrity and access in analytics workflows.

🔍 What I Learned

This project sharpened my SQL skills while giving me a data-driven view of what employers actually value. I practiced joining multiple tables, writing WITH clauses to simplify logic, and using aggregation functions like GROUP BY, COUNT(), and AVG() to uncover trends.

More importantly, it helped me turn vague career advice into focused, measurable goals. I now have a clear direction on which skills to prioritize based on real market demand and salary potential.

🎯 Key Takeaways

• 💼 Top Roles Pay Big: Remote data analyst jobs can reach up to $650K, showing the upper limits of the field.
• 🛠️ SQL is Non-Negotiable: It's the most requested and best-paying core skill.
• 📈 Python, Tableau, Cloud Tools: These consistently rank high in both demand and pay.
• 💰 Niche Tools Pay More: Skills like PySpark, Databricks, and Jupyter are tied to top salaries.
• 🎯 Best ROI: SQL stands out as the most strategic skill, balancing high demand with strong salary potential.

By focusing on high-value, high-demand skills, I’m better equipped to target the right jobs and invest my learning time where it counts.