Learning about VFX Artist

Hi,

I want to create special effects for 2D games in Unity. What kind of artist should I look for? Also, what is the recommended pipeline for the same?

Best Regards,
Sahil Goyal