The name "Scorpia" in the book *Scorpia* by Patrick Weekes doesn't stand for anything. It's simply a name given to the character, a genetically engineered assassin.
The name itself is likely chosen to evoke a sense of danger and mystery, much like the scorpion itself. The word "scorpio" is the Latin word for scorpion, and the character's abilities and ruthless nature live up to the name.