With the rise of the Modern Data Stack, more and more people use dbt as the main tool for data transformations, aka data modeling. The folks at Fishtown create an amazing dbt Cloud offering suitable for smaller/simpler data teams. With dbt Cloud, any Analyst, seasoned or fresh, can easily start modeling and deploying data transformations pipelines to production.
A Physical Zettlekasten — Image from Wikipedia
Getting your way around an IDE is a vital part, whether you are an engineer or an analyst. Watching a senior developer jumping around in Vim or VSCode can be intimidating for people with less familiarity. However, I assure you that there is no magic here. It is all practice and Googling answers when you got stuck.
Email is still the core mode of communication in our work and personal life for many of us. When I started with my career, dealing with email is not an issue since I did not get that many emails. However, they started coming in more and more, and I started wearing different hats in my life. At one point, I started missing important tasks and forget details that I should have remembered. Our brain is terrible at keeping and organizing a lot of information. That is why many great productivity systems like GTD or Zettlekasten rely on capturing and organizing information off our brains.
We love dbt, and we use it for almost all of our consulting projects. There are so many cool pre-made packages in the dbt hub that dramatically improves your productivity. For example, Fivetran has created pre-made starter models for many common sources such as Hubspot, Salesforce, Google Ads, and Facebook Ads. Fishtown Analytics also created some great starters packages, such as dbt-utils, audit-helper, and code-gen.