Darren Lehmann is set to take charge of the Leeds-based team in The Hundred tournament starting next year.
The 49-year-old, who was the head coach when the trio of Steve Smith, David Warner and Cameron Bancroft were banned, told Press Association Sport he was delighted to be returning to Yorkshire.
Lehmann was part of the Yorkshire side that won the County Championship in 2001, their first since 1968.
"It's great to be back. I hoped I'd get the chance when I heard about it and I'm so excited the opportunity came along," Lehmann told Press Association Sport.
"It was a great experience of my career to play here, where the passion for the game is second to none.
"The connection is strong, I have so many family and friends around and I was lucky enough to be involved in ending Yorkshire's long wait for a county championship win in 2001."
Lehmann, who underwent counselling after stepping down as Australia coach, told the BBC he had no interest in returning to coaching in international cricket.
"No, I've gone past that," said Lehmann, who coached Australia from 2013-18.
"It's more about tournaments and having a bit of fun.
"I'll certainly stay away from international coaching, I don't want to travel that much anymore."
Lehmann is excited that Smith, Warner and Bancroft have all been recalled to the national side following their bans and are playing in the Ashes series where the tourists lead by 1-0 after two Tests.
"I'm just looking forward to watching them play," said Lehmann ahead of the third Test which gets underway in Leeds on Thursday.
"The game has moved on and people have got to move on as well, I'm glad those guys are playing their part in a great contest between Australia and England.
"It's been an enthralling series,” he added.