Job Market Analysis: Skills, Locations & Job Types
Built a data pipeline that collects 900 job postings from a public API, extracts technical skills from unstructured text with regex, models the data in a 3-table relational SQLite database (many-to-many), and analyzes skill demand by city, company, and work mode with SQL joins, CTEs, and window functions. Delivered a clean dataset, charts, and full documentation.
Tools: Python, SQL, pandas, BeautifulSoup, matplotlib.