Waters graduated from Etowah High School in Woodstock, Georgia. As a senior, he batted .516 with 15 home runs and 40 RBIs, leading Etowah to a Class 7A state championship title.[1] After the season, he was named the Georgia Gatorade Player of the Year and the Metro Atlanta High School Player of the Year.[2][3] He committed to play college baseball at the University of Georgia for the Georgia Bulldogs.[4] His brother Zach Waters played college baseball for East Tennessee State and the University of Georgia and is the Assistant Coach of the varsity baseball team for Etowah High School.
Waters did not play a minor league game in 2020 due to the cancellation of the minor league season because of the COVID-19 pandemic.[18] He was added to Atlanta's 60-man player pool and trained with other players in the pool in Gwinnett County, Georgia over the course of the summer.[19][20] For the 2021 season, he was assigned to Gwinnett, now members of the Triple-A East.[21] In June, Waters was selected to play in the All-Star Futures Game at Coors Field.[22] Over 103 games played for Gwinnett, Waters slashed .240/.329/.381 with 11 home runs, 37 RBI, and 28 stolen bases.[23]
On November 18, 2021, the Braves selected Waters' contract and added him to the 40-man roster.[24] Waters began the 2022 season on the injured list for Gwinnett.[25] He was activated in early May.[26] Over 49 games with Gwinnett, he batted .246 with five home runs and 16 RBIs.[27]
On August 22, 2022, the Royals promoted Waters to the major leagues.[30] He collected his first career hit on August 24, with a single off of Arizona Diamondbacks starter Zac Gallen.[31] On September 5, Waters hit his first career home run, a two–run shot off of Cleveland Guardians starter Triston McKenzie.[32] In 32 games during his rookie campaign, he batted .240/.324/.479 with five home runs and 18 RBI.
Waters played in 98 games for the Royals in 2023, hitting .229/.300/.378 with 8 home runs, 32 RBI, and 16 stolen bases.[33] Waters was optioned to Triple–A Omaha to begin the 2024 season.[34]