Holt previously played for city rivals Dundee between 2015 and 2018