Thanks Christophe for including the article, much appreciated!

When it comes to the analytics engineer, there is a good and very new episode on the data talks club on that topic: https://www.youtube.com/watch?v=C5UcxBwdCEg&ab_channel=DataTalksClub

As Robert Sahlin said well (he's a senior data engineer that I strongly recommend to follow on e.g. LinkedIn):

I think data engineering will end up in multiple T-shaped engineering roles, driven by the development of self-serve data platforms rather than engineers developing pipelines or reports. The data engineering domain is too big for one data engineer to cover all of it, sure the unicorn data engineer exists but it is very rare to find one.

When it comes to dbt, I think the biggest hurdle they need to overcome very soon is in the transition into streaming. As Chip Huyen evangelizes, e.g. ML is going real-time: https://huyenchip.com/2020/12/27/real-time-machine-learning.html?utm_campaign=The%20Data%20Science%20Roundup&utm_medium=email&utm_source=Revue%20newsletter

ELT isn't very good at supporting that at the moment.