The SNP politician was a key figure in the Scottish government's response to the Covid pandemic.