advisor careers in Waterford, Ireland