Introduction:

I'm currently searching for jobs, and it feels like an impossible task. As someone who has dealt with data for many years through education and work, I couldn't help but use data to gain insight into future job openings—whether there will be more or fewer opportunities ahead. So, I used Snowflake to create a data warehouse and added a few tables from CSV files to explore and visualize some economic data. Although we don't necessarily require Snowflake for this task, I felt it was suitable for easily creating tables from CSV files and generating basic charts.

Data:

Lets start by plotting the Federal Funds Effective Rate

image.png

Next lets plot  Software Development Job Postings on Indeed in the United States

image.png

The individual charts clearly show a correlation between interest rates and job numbers. When interest rates dropped, the number of jobs increased rapidly. Conversely, we see a decline in job growth as soon as interest rates were raised again.

Now, let's combine both charts for a comprehensive view

image.png

After combining the charts, we can clearly see an inverse correlation between interest rates and software job openings.

Now, Lets bring in T-bills.

A T-bill, short for Treasury Bill, is a short-term debt obligation backed by the U.S. Treasury Department with a maturity of one year or less. T-bills are sold in denominations of $1,000 up to a maximum of $5 million and commonly have maturities of one month (four weeks), three months (13 weeks), or six months (26 weeks), 10 years.

Key characteristics of T-bills: