McFadden was in charge of the first grade team for three seasons – a time that was successful by current standards – before he stepped down before the 2017 season.
But he stayed on as assistant to Stephen Kearney for two years, before moving to his current role with Canberra, working under Ricky Stuart for the past four seasons.
He helped the Raiders reach the 2019 grand final and the preliminary final a year later.
McFadden also has an association with incoming Warriors head coach Andrew Webster. Webster was an assistant coach under McFadden at Mt Smart in 2015 and 2016.
"He has a great affinity with the club and with New Zealand," said Warriors chief executive Cameron George. "He's driven now to step away from coaching at NRL level and step into the critical area of recruitment, development and pathways.
"We've invested heavily in development and pathways while being based in Australia for the last three years and we have even bigger plans in this space with our full football operation coming back to New Zealand from next season. Part of his role will be to identify and mentor young coaches in our system."
Hodges had a close association with former coach Nathan Brown and was always unlikely to be a long term prospect at the Warriors after Brown left the club.
"He has wonderful qualities and has made a fantastic contribution but he still has a strong desire to coach so unfortunately, with no position here, he is looking for opportunities in Australia," said George.
