I took a promotion from Lead DBA to Data Architect. As a hands-off role it wasn't good for me but did bring a decent salary (found out later I was paid £15K less than other architects). Through a strange route I ended up as a Lead Data Engineer and on to Principal Data Engineer. It is a varied role and strangely closer to when I first started my career as an analyst/programmer. Analyst/Programmers were expected to do a bit of everything, including talking to the people for whom we were writing software.
My current role has got me into the habit of learning. If you are in a comfy job in a stable company it is too easy to site back and flip the pages of your calendar. I really think you have to cultivate and nurture learning as a habit. Do it for yourself, but also encourage it in those who report to you. You will be serving them well.