Here are more details from Chron.com:
Hayes, who held a similar position with the Denver Nuggets last season, will continue to evaluate NBA and other players for the Rockets, with some work in player development, Rockets vice president Gersson Rosas said.
“We value him not only as a player but his profile and his background is extremely valuable to what we do on the personnel side,” Rosas said. “He’s a guy who has a different perspective. He’s been in the league for 10 years, understands the game. He’s a guy that has known for a long time he wanted to do something in the league after his (playing) career was over and prepared accordingly.