Creating a view that sorts the employees in order of their scores is easy.
Creating a function that gives the employee a rank based on the order of their scores sounds tricky, and maybe not possible.
Your first problem is to get all of the other employees scores available to each record. So you’ll need Linked Record columns for each employee. Like this (I’ve used players instead of employees here):
You are then going to need to Look Up fields to look up the scores of all of the employees:
The real problem you then have is to turn those scores into a rank. Airtable doesn’t seem to have a sorting formula, so you are going to need to come up with a fiendishly clever formula to solve this. It would probably involve all sorts of clever string and array operations. It might not even be possible. Good luck.
