It refers to the chief of a production's special effects crew. The SFX supervisor is in charge of the artificial effects needed to create an illusion in a movie that are produced on the set, as opposed to those created in post-production (visual effects).