Born in Elgin, he started his career at Derby County but after two years at Pride Park, he was released. Macaulay is the nephew of former manager Steve Paterson and was signed for the Dons by his uncle. He made his debut on 4 February 2006 against at Tynecastle.
In November 2006 he was loaned out to before signing a permanent deal with them on 31 January 2007. After leaving Peterhead in the summer of 2007, Macaulay was out of football for a few months until he signed for after a successful trial period. He scored for Alloa in February 2008 in a game against his former club Peterhead., BBC Sport, 26 February 2008.