The veteran Sinn Fein politician is leaving his job as Stormont economy minister to take on a new role in the upper chamber of the Irish parliament.