After taking a turn in the secession game I decided to start up my own fort. Two and a half years in, I have seen a weremoose attack (two dead, infected militia commander is trapped in a walled-off section of the fort), and just now an Etten (a giant two-headed humanoid creature). The Etten died without too much disaster, but it has dropped a tablet which turns anyone who reads it into a necromancer.
for FUN, you could let someone read it, then set them up in an office as a permanent manager/bookkeeper who never needs to eat.
you could also set up a resurrection chamber where you take newly deceased citizens (or citizens you "deceased" on your own). This chamber would have an adjacent room with some sort of enemy in it, with view blocked by a wall of fortifications and a drawbridge. Necromancer is in the room, you drop the bridge so they see the enemy. They panic, and resurrect the nearest corpse. There's a chance this resurrected corpse is an intelligent undead. Do this 10-20 times and you have a squad of soldiers who never get tired and never have to stop training to sleep or eat.
Necromancers can be lots of fun, or lots of FUN.
In short, you want him to create the dwarven version of Ainz Ooal Gown.