My conception of the position is that you can throw whatever data at me, but as long as you tell me the requirements I can get the data through with minimum cost and maximum accuracy.
I used to think knowing the business is important, but now I understand that it's impossible to know every business I'm in. I should rely on the BI for requirements and just do my job and do very well. I don't want to be a product manager or a manager so I prefer to stay in the technical side.
About the other questions, yes I automate as much as possible. I don't have any free time sadly as I'm just one man team (previously we have 6). I'm overwhelmed by this YAML engineering.
Anyway I'm starting interviewing soon.