He transferred prior to his senior year to Notre Dame High School in West Haven, Connecticut.

[3] Ranked number 37 overall in his high school class by Rivals.com, Waters committed to LSU and coach Will Wade on June 5, 2017.

After the season, Waters entered his name in the 2018 NBA draft but did not hire an agent to preserve his collegiate eligibility.

[13] On July 12, 2019, Waters' father was found dead at a Super 8 Hotel room in West Haven, Connecticut in an apparent suicide.

The Celtics fell short to the Grizzlies and were eliminated from Summer League Championship contention despite a 16-point effort from Waters.

[13] On July 25, 2019, the Celtics announced that they had signed Waters to a two-way contract, splitting time with the Maine Red Claws.

[17] On January 9, 2020, Waters posted 30 points, seven assists and five steals for Maine in a 120-118 triple overtime win over the Capital City Go-Go.

[28] On March 1, 2022, Waters was selected with the first pick overall in the 2022 Baloncesto Superior Nacional draft by the Gigantes de Carolina[29] joining them after South Bay's season ended.

Tremont made his debut on April 11, 2022, powered Carolina's offense throughout the season, averaged 17.8 points and 8.0 assists 1.7 steals per game.

[31] On July 26, 2023, Waters helped the Gigantes to win their first BSN title against the defending champions Vaqueros de Bayamón.