Andrew was born in Dundee, and educated there and at the University of St Andrews. He works for the Royal College of Organists as Director for Scotland and Northern Ireland. He became an Honorary Life Member of the College in 2023. He is also Deputy University Organist and Director of Music at All Saints Church in St Andrews, and Manager of the National Pipe Organ Register. He is a former chair of the Friends of the Caird Hall Organ in Dundee, and a former President of the Scottish Federation of Organists.