Goodman began the 2023 season with the Double–A Hartford Yard Goats, playing in 91 games and batting .239/.325/.523 with 25 home runs and 78 RBI. He was then promoted to the Triple–A Albuquerque Isotopes, where he hit .371/.418/.903 with 9 home runs and 33 RBI across 15 games.[9] On August 27, 2023, Goodman was selected to the 40-man roster and promoted to the major leagues for the first time. At the time of his promotion, he was the minor league leader in home runs, with 34.[10] He singled twice in four at bats in his MLB debut later that afternoon in a 4–3 win over the Baltimore Orioles at Camden Yards. He drove in a run with his first hit off Jack Flaherty in the sixth inning. He eventually scored the deciding run in the ninth after a leadoff infield single off Yennier Canó with the score tied at 3–3.[11] In 23 games for Colorado in his rookie campaign, he batted .200/.247/.386 with one home run and 17 RBI.
Goodman was optioned to Triple–A Albuquerque to begin the 2024 season.[12]
On June 15 2024, Goodman went 4 of 5 batting, 2 home runs and 5 Runs batted in a 16-4 win against the Pittsburgh Pirates.