Raphael Arndt, the CEO of Australia's sovereign wealth fund, has announced his resignation from the role. His departure marks a change in leadership for the significant financial institution.