#jobs #jobs #jobs | Exploring trends in data jobs postings

The exploration of trends in data job postings on dbt's Slack #jobs channel reveals several key insights, notably the growth in job postings paralleling the expansion of dbt's user base and Slack community. Since 2021, the channel has consistently featured over 100 job postings per month, with a significant shift towards remote work opportunities, rising from 20% before 2021 to over 50% thereafter. Analytics engineering roles have seen notable growth, increasing from 6% in 2019 to 32% in 2022. The data was extracted using Phantombuster to pull messages into a CSV file, which was uploaded to Google Sheets and integrated into a Postgres database via Fivetran. The unstructured nature of text necessitated SQL queries for data analysis, including filtering out non-relevant threads and extracting information about roles, remote status, and visualization tools mentioned.