A female (family member/friend), who is a sister (or [like a sister]), who helps (usually another female) frequently with cleaning, cooking, [childcare], other household [duties], etc.
There is no romantic involvement with a sister-wife or her spouse, however she is beloved by the whole family.