📊 Explore the data job market with a focus on data analyst roles! This project uncovers 💰 the highest-paying positions, 🔥 the skills most in demand, and 📈 where strong demand intersects with top salaries in data analytics.

🔍 Curious about the SQL queries? Find them here: project_sql folder.

This project cuts through the noise of the data analyst job market. By identifying the most lucrative and high-demand skills, it offers a clear roadmap for job seekers aiming to land top-tier roles.

The dataset, sourced from Luke Barousse's SQL Course, includes detailed information on job titles, salaries, locations, and required competencies.

1. What are the top-paying jobs for my role?
2. What are the skills required for these top-paying roles?
3. What are the most in-demand skills for my role?
4. What are the top skills based on salary for my role?
5. What are the most optimal skills to learn?

For my deep dive into the data analyst job market, I leveraged a focused set of tools to power the analysis:

• SQL – The core of my analysis, used to query the database and surface meaningful insights.

• PostgreSQL – The relational database system I used to store and manage the job postings dataset.

• Visual Studio Code – My primary environment for writing and executing SQL queries, as well as managing the database.

• Git & GitHub – Essential for version control, tracking changes, and sharing my SQL scripts with the community.

This project is divided into specific questions, with each one aimed at uncovering a different piece of the data analyst job market puzzle. Here’s how I went about answering them.

To pinpoint the top-paying opportunities, I filtered data analyst positions by average yearly salary and location, focusing on remote jobs. This query highlights the high paying opportunities 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 = 'Data Analyst'
 AND salary_year_avg IS NOT NULL
 AND job_location = 'Anywhere'
ORDER BY
 salary_year_avg DESC
LIMIT 10;

Here's the breakdown of the top remote Data Analyst jobs in 2023:

• Wide Salary Range: Top 10 paying roles span from 135,000ドル to 650,000,ドル with a massive outlier at the top and most roles clustered in the 140ドルk–165ドルk range.
• Diverse Employers: Companies range from tech giants like Uber to recruitment firms (CyberCoders, Get It Recruit), financial services (EPIC Brokers), and specialized firms (Mantys), showing broad industry interest.
• Remote-First Opportunity: All positions are fully remote ("Anywhere") and full-time, indicating strong demand for location-flexible data talent.
• Consistent Premium Tier: The median salary sits at 145,000,ドル with 8 out of 10 roles falling between 135,000ドル–165,000ドル—suggesting this is the realistic high-end benchmark for remote Data Analysts.
• Outlier Exception: The 650,000ドル role at Mantys stands alone, likely requiring specialized expertise far beyond typical Data Analyst expectations.

Top Paying Jobs Bar graph and box plot visualizing the top 10 paying Data Analyst jobs in 2023; Gemini generated this graph from my SQL query results.

By combining job postings with skills data, I pinpointed which abilities drive the highest salaries and what employers truly seek.

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 = 'Data Analyst'
 AND salary_year_avg IS NOT NULL
 AND job_location = 'Anywhere'
 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 demanded skills for the top 10 highest paying data analyst jobs in 2023:

• SQL is the only universal requirement – 100% of top-paying roles demand it; without SQL, you're eliminated from every high-value position.

• Python and R are the programming backbone – Python leads at 90%, while R remains critical for statistical work at 60%.

• Cloud & big data skills are essential – Azure, AWS, Snowflake, and Databricks appear in 50% of top roles, signaling that cloud expertise is a major differentiator.

• Tableau remains the visualization leader at 70%, though Power BI is gaining ground as a strong alternative.

• Data science libraries are increasingly valued – Pandas and NumPy appear in 30% of top roles, showing the shift toward advanced analytics.

• Excel is relevant – appears in 30% of top roles, proving legacy tools persist in high-paying environments.

• Collaboration & DevOps tools are emerging – Jira, Confluence, Git, and GitLab appear in 30% of top roles, indicating that technical communication and version control are table stakes.

Top Paying Skills Bar graph visualizing the count of skills for the top 10 paying jobs for data analysts; Gemini generated this graph from my SQL query results.

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 demanded skills for data analysts in 2023:

• Data management is dominated exclusively by SQL, establishing it as the foundational competency.
• Analytical processing is split between traditional spreadsheet manipulation, reflected in Excel’s significant presence, and programmatic automation via Python.
• Business communication is heavily weighted toward visual storytelling, with Tableau and Power BI constituting a substantial portion of the requirement matrix.

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

An analysis of average salaries by skill highlighted those that command the highest pay

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:

• Distributed & ML platforms (PySpark, Couchbase, DataRobot) occupy the highest tier, reflecting premium value placed on large-scale compute and model deployment.
• Engineering & orchestration tools (GitLab, Kubernetes, Airflow, Jenkins) form a secondary cluster, indicating that operational and pipeline-building responsibilities are compensated separately from analysis.
• Python data stack (Jupyter, Pandas, NumPy) shows consistent but plateaued returns, suggesting commoditization of core analytical proficiency.
• Cloud & collaboration platforms (Databricks, Elasticsearch, GCP, GitLab, Atlassian, Notion) appear alongside high salaries, functioning as proxies for role seniority and cross-functional scope rather than differentiators.

Table of the average salary for the top 10 paying skills for data analysts

Combining insights from demand and salary data, this query aimed to pinpoint skills that are both in high demand and have high salaries, offering a strategic focus for skill development.

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;

Here's a breakdown of the most optimal skills for Data Analysts in 2023:

• Python and Tableau dominate the optimal skill set with 236 and 230 job postings respectively, maintaining average salaries of 101,397ドル and 99,288ドル. These competencies deliver the strongest risk-adjusted return for career development.
• Cloud platforms demonstrate the strongest salary premium relative to demand volume, with Snowflake commanding 112,948ドル across 37 postings, Azure at 111,225ドル across 34, and AWS at 108,317ドル across 32. Cloud expertise elevates compensation by approximately 10,000ドル above market average.
• Big data technologies exhibit an inverse demand-to-salary relationship where niche specialization commands premium rates. Hadoop reaches 113,193ドル for only 22 postings, suggesting specialist strategies yield higher compensation but narrower opportunity sets.
• Collaboration tools signal senior-level expectations as Confluence at 114,210ドル and Jira at 104,918ドル appear among high-compensation roles, indicating technical leadership capabilities increasingly factor into premium salaries.
• Programming language diversity beyond Python shows measurable value, with Go at 115,320ドル across 27 postings and Java at 106,906ドル across 17, suggesting cross-language proficiency expands compensation ceilings.

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

Throughout this SQL project, I picked up some essential skills along the way:

• 🔗 JOIN Mastery: Learned to connect multiple tables (job_postings_fact, skills_job_dim, skills_dim) to uncover relationships between jobs, salaries, and required skills.
• 📦 CTE Power: Discovered how WITH clauses break complex queries into manageable chunks—turning tangled logic into readable, step-by-step analysis.
• 📊 Aggregation Game: Got comfortable with GROUP BY, COUNT(), AVG(), and ROUND() to summarize data and spot trends hiding in the numbers.
• 🎯 Filtering with Precision: Mastered WHERE clauses with multiple conditions to slice data exactly how I needed—location, salary, job titles, you name it.
• 💡 Question-Driven Analysis: Learned that a clear question beats fancy syntax every time. Defined 5 specific problems and let them guide my queries from start to finish.

The biggest lesson? Anything makes sense once you start asking the right questions.

From the analysis, several general insights emerged:

1. Top-Paying Data Analyst Jobs: Remote data analyst roles can reach up to 650,000,ドル but the realistic premium tier sits firmly in the 135,000ドル–165,000ドル range.
2. Skills for Top-Paying Jobs: SQL is non-negotiable—100% of top-paying roles demand it, with Python, Tableau, and cloud platforms following close behind.
3. Most In-Demand Skills: SQL dominates the market with over 7,000 job postings, while Excel, Python, Tableau, and Power BI round out the essential toolkit.
4. Skills with Highest Salaries: Niche tools pay big — PySpark, Bitbucket, and Couchbase command the highest average salaries, rewarding specialized expertise over generalist skills.
5. Optimal Skills for Job Market Value: SQL is the demand king, while Snowflake, Azure, and AWS sit at the sweet spot of solid demand and premium salaries. Go and Hadoop reward specialization with top-tier pay.

This project sharpened my SQL skills and gave a clear roadmap of the data analyst job market. The findings cut through the noise — prioritize SQL, Python, and Tableau, add cloud expertise to stand out, and consider niche tools for premium pay. For anyone breaking into data analytics, these aren't just nice-to-haves; they're the keys to positioning yourself competitively.

Most importantly, this exploration reinforced that the field rewards continuous learning and adaptability. Trends shift, tools evolve, but the ability to ask smart questions and extract insights from data will always be in demand.