UK JOB MARKET TIGHTNESS INDEX (JMTI)
Built staging/fact dbt models (stg_jobs, fct_jobs, stg_job_skills, fct_job_skills) on PostgreSQL and implemented skills keyword extraction, processing and validating ~1,500 daily records from an external API before automating the run on a daily schedule. Rebuilt comparison logic to reconcile new, updated and removed records. Pipeline feeds a self-service Power BI dashboard built on a medallion-layer design, orchestrated with Airflow and containerised with Docker.
// INTERVIEW ENGINE