Thanks for that clarification Craig.

What I did in the end, and works great, is created a scheduled task to run every X minute(s), and for each user, I set their manager to the person who chose the manager position.

So I didn't actually need to set any roles, and now the manager has access to the Teams tab and can view the progress of their users.