Sorry for the long post.
I'm working in an e-commerce firm. I have 4 years of experience working with SQL, Python and a handful of BI Tools that I have grown very comfortable working with. I feel that I have grown really well in technical terms. I can make complex customized reports/dashboards and do automations (fetching data from third party API, ftp server, google sheets etc.) and setting up crons/scheduler for those scripts.
Since I am working with a lot of stakeholders from different departments, I tend to get a lot of adhoc requests with varied requirements related to cohort analysis, customer retention and funnel performance. The main challenge I'm facing is I'm not getting the visibility despite putting a lot of effort into creating and maintaining these reports (I feel overwhelmed with work most of the days). The main reason for this lack of visibility is the managers (usually from the business teams) simply ask me to share the data or the query so they can export and analyse the data on their own.
The majority of those people lack the critical thinking required to do the analysis (I don't blame them since they usually have a different area of expertise and skillsets). So they end up doing their analysis (whether right or wrong) and present it to top management(who I have absolutely no communication with) who then take business decisions based on the story presented to them by these "middle men". It robs me of the learning opportunity which involves being able to meaningfully interpret the data and understand the business (I don't have an MBA, so I don't see how else I can get the business learning or expand my knowledge about the company).
On top of this, my manager(digital marketing director) rated me 2.5/5 for business understanding because he claims that I don't provide insights to our team or other depts. He doesn't understand that those teams don't want to discuss the data and build a story with me, they want to do it on their own and then do not even share credit with me which is super unfair to me, and results in a lot of negative feelings in me about those people and the colleagues in general. Also the company doesn't have a leader in analytics or a chief data officer who can become a voice for the analytics folks.
The condition is worse for freshers because the senior analysts such as myself don't see any rewards for teaching them the skills, meanwhile not getting anything from the company except the salary. I feel stuck and there is no-one who can add value in terms of the skills and knowledge that I am seeking or the recognition that I deserve.
How can I make my life better? The best case I'm seeing right now is to request my manager to give me more technical tasks for my own learning which would not stop him from getting credits for the work I'm doing the most heavy lifting in. I feel there's little I can do in this role and with so little authority despite being decently skilled and having the capability to work independently.