Cooney made his senior debut for Leinster in 2011 away to Ospreys before joining Connacht on a short-term loan deal. He made the move permanent ahead of the 2015/16 season before making the switch up to Belfast in 2017, signing a two-year contract at Kingspan Stadium. Cooney made an immediate impression at Ulster, winning Ulster Player of the Year, the Supporters Club Player of the Year and the Rugby Writers' Player of the Year in his debut season. He was awarded with a contract extension which will keep him at Kingspan Stadium until at least 2022, and his continued excellent form in the 2018-19 season led to him being named in the Guinness Pro14 Dream Team.