It's believed to be a toponymic surname, meaning it originated from a place name. The origin is likely from the town of "Sosa del Rey" in the province of Burgos, Spain.
So, while "Sosa" doesn't have a direct translation, it can be interpreted as "from Sosa" or "someone who is from Sosa."