Business Intelligence Analyst
Bogotá, Distrito Capital, Colombia
- ETL (Extract, transform, load) of market information in order to support a pricing policy and better understand the market for Colombia, Brazil & Mexico:* Extraction of market information from main competitors through web scraping technique. Use of Python language and libraries such as Selenium, Scrapy & Pandas.* Cleaning and consolidation of the extracted market information for use by the company's internal clients. Use of SQL and Snowflake platform service.* Construction of market information tracking dashboard for decision making. Use of Holistics, cloud platform for Business Intelligence (BI). - Construction of dashboard for tracking sales, margins & costs of the company in order to keep track of the pricing policy and behavior of the different categories.- Support in requests for improvement, change or construction of tracking dashboards.