Sweeney was the Black Ferns Sevens assistant coach in 2016. He then Co-coached the Black Ferns Sevens team with Allan Bunting from 2019 until the Tokyo Olympics in 2021.[2][3] He was nominated with Allan Bunting for the Halberg Coach of the Year award in 2022.[4]
Following Bunting departure to take charge of the New Zealand women's fifteen-a-side team Sweeney became the sevens team's head coach.
During the 2022-2023 Sevens season he coached the sevens team to winning six straight tournaments, and 41 consecutive games to secure them that seasons title. For his efforts he was named national coach of the year at the New Zealand Rugby awards in December 2023.[5]
He coached the team to claim a back to back gold medal at the 2024 Paris Olympics. At the second tournament of the 2024-2025 Sevens season held in Cape Town on 7–8 December 2024 he celebrated coaching at his 50th tournament of the Sevens series.[6]