The Psychologist position with the City of Dallas involves providing professional counseling, psychological testing, evaluation, and screening to ensure the mental stability of police officers. This role is crucial in supporting the mental health of law enforcement personnel and includes responsibilities such as conducting evaluations, designing psychological projects, and providing expert testimony in court.