How is this best done through ADManager when automating? 

Would you simply have a csv export from the HR database with employeeNumber and Title? 

And how can you automate matching the users in AD based on that attribute or based on other attributes in order to update those types of other attributes?