consultant careers in Waterford, Ireland