Sorry it has taken me so long to chime in here - I’ve been a little busy today.
As @BrianJ mentioned, I am considered the BI Champion for my company. To provide some context here, we are a small (under 250 full-time employees), family-owned business-to-business sales company that thinks on a bigger scale (we just don’t have the larger budget 
).
I started working here a decade ago as an admin, quickly moved to position of personal assistant to the company president, and generally wore a LOT of different hats simultaneously (including IT, reporting, secretarial, event planning… ). Over time, my role evolved to analyst as I demonstrated skill in reporting and analytics - something the company hadn’t realized they needed.
Recently, I found myself as the only PowerBi developer in the company, tasked with taking over and understanding the PowerBi projects of a former employee, to ensure they continued to work. As I worked with that person’s manager, we realized that the company needed to have a team (even if that team consisted of only a few people) that were ‘in charge’ of PowerBi and reporting solutions. That is now my role - partially by default (last one standing), but partially by design (I have been campaigning for a larger more structured data role in the company for the past 5 years). I will be ensuring a smooth transfer of projects as people join and leave the company, and determining our reporting standards for the future.
Thank goodness I have the team here at eDNA to lean on, and learn from - because I am literally writing the book on how this job will be done in the future, and my crystal ball is a bit fuzzy right now