Job Market Analysis

NLP-driven insights into Calgary's Data Analyst landscape using SerpApi and Google Jobs.

SerpApi Pandas Matplotlib Seaborn NLP

Project Scope

Using Python-based scraping and API integration, I analyzed 72 live job postings for Data Analyst roles in Calgary, AB. The goal was to quantify the "Skill Gap" by extracting technical requirements and soft skills directly from unstructured job descriptions.

72
Postings
Calgary
Region

Analysis Methodology:

  • Data Extraction: Automated gathering via SerpApi Google Jobs engine.
  • Text Mining: Pattern matching for technical keywords (SQL, Python, etc.)
  • Co-occurrence Analysis: Identifying common skill bundles (e.g., SQL + Power BI).

Market Insights

The Foundation

Excel and SQL remain the absolute non-negotiables for entry and mid-level analyst roles.

The BI Evolution

High demand for Power BI indicates a shift towards self-service reporting and dashboarding.

Skill Bundling

SQL + Power BI (16 jobs) is the most frequent technical "bridge" in modern listings.

Data Visualizations

Most Requested Technical Skills

Technical Skills Chart

Demand for Soft Skills

Soft Skills Chart

Correlation: Skill Co-occurrence Heatmap

Skill Heatmap

Visualizing which tools are most frequently requested together in a single listing.