Optimization of RF- and DC-sputtered NbTiN films for integration with Nb-based SIS junctions