That depends entirely on toolchain that designer is using and complexity of design. For simple designs not really meant for volume production gerbers that are created by CAD software are usually ok. If you're going for high volume, then some postprocessing software will be needed. Examples of such software would be FAB3000, CAM350, Pentalogix. This way you can design very complex panel arrangements, tooling holes, transform pad shapes (you would be amazed by how much you can reduce assembly errors with clever paste shape). You can also design variants of PCBs with different components assembled (for example DPAK in place of D2PAK) or some of them not assembled at all -by removing unnecessary openings you save solder paste.
It's typically PCB designer who is responsible for SMT stencil engineering, not assembly process engineer.