Even after common tools were changed to add warnings about accessing private data, there were still many ways to go around them. All engineers have access to user databases as well as the thousands of other data sets that contained user data.
The reason why most employees wouldn't abuse their power is the fear of getting caught (not due to any actual internal security). From this article, it's not clear how the fired employee accessed private data. So I can't say if they did something too obvious or if they put any effort in making sure they had plausible deniability if caught. This article doesn't indicate whether internal security actually caught the data access violation. It sounds like they only found out after the accusations appeared on twitter.
Given that anyone on the team who had been around for a while would have known this I am assuming the security engineer who was shown the door was either an intern or new to the team as most others would have known that they would eventually be caught.