Refers to one's own niece or someone else's niece. The term is neutral and commonly used in both spoken and written Japanese.
姪が来月、大学を卒業します。
My niece will graduate from university next month.
His niece is very good at drawing.
Last month my sister had a baby, so I got a niece.
My grandmother always dotes on her niece.