It depends really. Knowing how to put sounds in a game will never hurt you but when freelancing, sometimes clients will only want you to make content that they'll plug in themselves. Other times, it can definitely be a selling point to help you land more jobs!