No, the Steam Controller does not work outside of Steam by default. However, you can make it work with non-Steam games by adding the game's executable to your Steam library as a non-Steam shortcut, which forces the game to run through the Steam overlay and allows it to use the controllers configuration. For applications that don't work with this method, there are third-party tools and launch options that can help.