Firstly, I'm assuming you mean can a councillor be a RFO (Responsible Financial Officer)?
The simple answer is yes but he/she cannot be paid for that role (a councillor cannot be "employed" by the council for which they are a member under the Local Government Act). You also need to take into account what would happen if that individual is not re-elected or resigns.