What technological occupations are essential to any colony?

It depends upon the colony. You have to have farmers, traders, merchants, soldiers, tailors, doctors, pharmacists, and people who handle horses. As you become more organized and official, you would need lawyers and political leaders, as well as some sort of police and some sort of court system.