Sweeper would be actually very rare, even in the real football world where they just have a very deep back line.
Or it should actually be an ability on the keeper (to replace the useless penalty stopper).
With a sweeper keeper, it may allow your team to push further up and less vulnerable to long ball counter attack