Looking for VFX Designer

Hi, I’m creating rpg game and i need one visual effect, i’m looking for help to create or explain how to do this effect. I don’t have any idea how i can make it.