Kevin Hodson played junior hockey for the Sault Ste. Marie Greyhounds from 1990-91 until 1992-93. During his tenure there he led the OHL in shutouts (two), average (3.22), playoff wins (nine), and average (2.89) in 1990-91; in average (3.10) in 1992-93; and in Memorial Cup Tournament wins (three) and average (3.00). He was named to the 1993 Memorial Cup All-Star team and was also awarded the Hap Emms Memorial Trophy for the tournament's top goaltender that same year.
In June 1993, he was signed as a free agent by Detroit and reported to the Adirondack Red Wings. He played two full seasons in the AHL and in 1995-96 was rewarded with a chance to make his NHL debut when he appeared in four games with Detroit. He stayed with the Wings' organization, playing in six games in 1996-97 and 21 in 1997-98 when he was part of the Stanley Cup winning team. He came back for part of the following year with Detroit and was eventually traded to Tampa Bay. He made five appearances for the Lightning that season and 24 in 1999-2000, his last season of professional play to date.