When I applied to and interviewed for this role, the job spec and interview process promised I'll be building self-service dashboards in Qliksense and working on bringing insights to the business as well as doing some forecasting work.
What the job actually involves is downloading reports off of a web server which are Excel files, pasting the data from one Excel file to another, doing some pivots, and pasting them into another file. I do not have access to the source database used by the web server to load the reports.
There is a datamart available that is supposed to be some source data with business logic applied, but none of the data I need is in there. Because of this insane system most of people's time is spend doing copy and pasting because there's no way to automate anything. And I can't for the life of me convince higher ups that as a data analyst I need access to source data to be able to automate.
How do I go about this? My immediate management is aware of this problem, but they can't seem to get through to the higher ups either. Any ideas on how to resolve that issue?