That would be a Narrative Designer which may have junior/associate/senior/etc. levels like any other discipline. I'm not the most familiar with the position and responsibilities vary between studios but they may include:
- storyboarding missions, quests, and cutscenes
- plotting out parts of the main story
- designing character personalities and backstories
- creating lore snippets
- some dialogue writing (often there are dedicated writers who do this)