The Network Consultant position at SMARTSOURCE involves working on a one-year project in Fort Wayne, IN. The role requires an engineer with advanced knowledge and experience in Nexus switches and Cisco routers, focusing on network discovery, documentation, and change management procedures.