The role of Competitive Programming Expert at Mindrift involves creating and assessing algorithmic challenges aimed at training advanced AI models. Key responsibilities include writing original and incorrect solutions in C++ and Python, developing test cases, and ensuring quality checks for solutions. Candidates should possess a strong competitive programming background and excellent written English skills.