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.
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.
Even if the employee gets caught, most companies (or fired employees) wouldn't announce it publicly. The only reason we know about this case is because this person bragged about it to someone else who made it public.
Google once also had a case like this. What speaks for FB (and Google) that these things happen so rarely. Their processes (including hiring) and monitoring must be quite good to be able to have a workforce that large and yet so few incidents of this kind (at least, that we hear about).