There has to be a hand-in-glove fit to the team for these roles to be effective, which means interviews often get delayed because someone key can't be there... then later, another key person is out, and the cycle turns into a crisis and finally interviews happen and the role gets filled.
But, as you know, AI has seriously cut into your niche and hiring has been very minimal for over a year in data-related roles. Non-data people can do so much more with the help of an AI that can read CSV output from common data sources that I'm seeing people get more benefit from directly being able to work with the sources themselves and ask questions rather than get a report made from the BI team.
I would consider widening your search into other domains, adding AI to your workflow and make it front-and-center.
I clicked on your LinkedIn profile and you are wearing the most casual outfit I have ever seen on a LinkedIn profile, so I would consider finding or taking a photograph that looks like a typical job seeker. I would then remove any recent activity from my profile: without logging in, your first post is about difficulties you are facing and the third is a "hot take" that some companies would not appreciate. I'd cut all personal information that wouldn't get me hired.
Lastly, I'd make a more memorable and higher resolution main graphic. Right now, if this is an example of the quality of your work output, it is very blurry on my 15" laptop and doesn't give a great impression in that regard. None of this is a complaint or attack - I heard your desire for input and am sharing my feedback as a person who has been in hiring roles for 2 decades.