The role of Competitive Intelligence Engineer involves developing solutions to extract and process data from various digital sources using technologies like Python and OCR tools. The engineer will automate data extraction processes and collaborate with teams to optimize data workflows.