First off, there are a ton of human saints named Sophia, and nice ladies they all are.
However, in stuff like the church of Hagia Sophia (Holy Wisdom or St. Wisdom), we’re talking about the personified figure of God’s Wisdom. There’s a lot about Wisdom in the Book of Wisdom for you to read. Wisdom doesn’t come into the Book of Revelation at all; the figures there are the Bride (the Church) and the Mother of the Child (Mary/the Church).
Wisdom can be identified with any person of the Trinity. In early Christian times, she was usually identified with the Son, because we are told that Wisdom was there with God at the beginning of Creation. Nowadays, people often identify Wisdom with the Holy Spirit. You’re not wrong either way.
Wisdom is personified as a woman in Hebrew, Greek, and Latin, because the word for wisdom in those languages is of feminine grammatical gender.
It’s not correct to identify Wisdom as an angel, although angels can be wise, because they’re nothing like as wise as God.