hazembadran/SQL_Project_Data_Job_Analysis

An SQL-based analysis of the data job market in Egypt, exploring top-paying roles, in-demand skills, and the most strategic skills to learn for a career in data. # Egypt Data Job Market Analysis An SQL-based analysis of the data job market in Egypt, exploring top-paying roles, in-demand skills, and the most strategic skills to learn for a career in data. SQL queries used in this project: sql_project folder --- ## Background As someone entering the data field in Egypt, I built this project to answer a practical question: which skills and roles should I focus on? Rather than relying on global trends, I filtered the analysis specifically to the Egyptian job market to get locally relevant insights. The dataset comes from Luke Barousse's SQL Course and contains real job postings with titles, salaries, locations, and required skills. ### Questions this project answers: 1. What are the top-paying data roles in Egypt? 2. What skills are required for these top-paying jobs? 3. What skills are most in demand for data roles in Egypt? 4. Which skills are associated with higher salaries? 5. What are the most optimal skills to learn? --- ## Tools Used **Database & Querying:** PostgreSQL, SQL **IDE:** Visual Studio Code **SQL Techniques:** JOINs, CTEs, Aggregations, Subqueries, Window Functions **Version Control:** Git & GitHub --- ## The Analysis ### 1. Top-Paying Data Roles in Egypt To identify the highest-paying roles, I filtered job postings to Egypt only, removed nulls, and focused on four core data roles: Data Analyst, Data Scientist, Data Engineer, and Data Architect. ```sql SELECT j.job_id, j.job_title, j.job_title_short, j.salary_year_avg, j.job_location, j.job_posted_date, j.search_location, c.name AS company_name FROM job_postings_fact AS j JOIN company_dim c ON j.company_id = c.company_id WHERE j.search_location IN ('Egypt') AND j.salary_year_avg IS NOT NULL AND j.job_title_short IN ('Data Analyst', 'Data Scientist', 'Data Engineer', 'Data Architect') ORDER BY j.salary_year_avg DESC LIMIT 10; ``` **Results:** | Job Title | Company | Salary (USD/year) | |---|---|---:| | Data Scientist | Visa | $157,500 | | Da …