A school staff member was charged with child sex offences while working at a school and has since resigned.