This project analyzes real-world job market data to identify:
- 💰 Highest Paying Jobs
- 📈 Salary Trends
- 🏢 Top Hiring Companies
- 💼 In-Demand Skills
- 🌍 Remote Work Trends
- 📊 Skill vs Salary Relationship
The project combines SQL, Python (Pandas) and Power BI to transform raw job postings into business insights.
- Analyze salary distribution
- Discover high-paying data roles
- Identify top hiring companies
- Understand market demand
- Find the most valuable technical skills
- Create an interactive Power BI dashboard
| Tool | Purpose |
|---|---|
| Python | Data Cleaning |
| Pandas | Data Manipulation |
| SQL | Data Analysis |
| Power BI | Dashboard |
| Matplotlib | Visualization |
| Git | Version Control |
Raw Dataset
│
▼
Data Cleaning (Python)
│
▼
SQL Analysis
│
▼
EDA
│
▼
Visualization
│
▼
Power BI Dashboard
│
▼
Business Insights
A high-level summary of the job market, highlighting total job postings, salary trends, hiring patterns, and key business insights.
Displays the highest-paying job roles, helping identify the most lucrative career opportunities in the data industry.
Highlights organizations with the highest number of job postings, revealing the leading employers in the market.
Visualizes salary distribution across different job roles, making it easier to compare compensation levels.
Shows hiring demand across various data-related roles and identifies the fastest-growing job categories.
Provides an overview of the technical skills requested by employers across the job market.
Breaks down skills into categories such as Programming, Databases, Cloud, BI Tools, and Machine Learning.
Evaluates the availability and completeness of company website information within the dataset.
Compares average salaries across different job titles to identify the most rewarding career paths.
Illustrates salary variation across seniority levels using box plots, highlighting median salaries and outliers.
Examines how remote job opportunities have changed over time and their impact on the job market.
Explores the relationship between the number of required skills and expected salary.
Displays the most frequently requested technical skills across all analyzed job postings.
Identifies skills that combine high employer demand with above-average salaries, helping prioritize learning investments.
The project includes SQL queries for:
- Top Paying Jobs
- Top Paying Skills
- Most Demanded Skills
- Optimal Skills
- Salary Analysis
sql/
│
├── 1_top_paying_jobs.sql
├── 2_top_paying_job_skills.sql
├── 3_top_demanded_skills.sql
├── 4_top_paying_skills.sql
└── 5_optimal_skills.sql
- Senior Data Scientists receive the highest average salaries.
- Remote positions remain highly competitive.
- SQL is the most requested skill.
- Python dominates analytical roles.
- Power BI and Tableau remain the leading BI tools.
- AWS
- Azure
- BigQuery
are among the highest-paying cloud technologies.
Major recruiters include:
- Meta
- AT&T
- Mantys
- SmartAsset
- Snowflake
Job_Market_Trend_Analysis
│
├── README.md
├── data/
├── sql/
├── notebooks/
├── images/
├── dashboard.pbix
├── Job_Market_Analysis_Professional_Report.pdf
└── Job_Market_Analysis_Dashboard_Guide.pdf
- Machine Learning Salary Prediction
- Streamlit Dashboard
- Real-time Job Scraping
- AI-powered Career Recommendation System