Important person in a small group. Implies that in a bigger group that person would be less significant. (Compare to Small fish in a big bowl.)

“He resigned from a large corporation to work for a mom and pop company so he could be a big fish in a small bowl.”