ETL Expert

The consultant is required to review the current methods and systems utilized by the Power for All team, especially the current Extraction Transformation and Loading (ETL) process, and advise on the most optimal process to extract and transform the data for the purposes of comparative data analysis and visualization across the different data sets. Identify and use open system tools to best load and run analysis and automate this process. Once the process of extraction, transformation loading (ETL) and analysis with visualization has been identified and agreed upon with the research team. The Consultant should finalize the automation process of the ETL process and provide a data visualization dashboard that is automated. It will be required from the consultant to develop a document that clearly identifies the tools and processes used and how to manage errors or updates of the automation process. The management of the system must be handed over to the Power for All data analyst who will manage this system and who will need to address any changes needed on the system once the automation process has been completed.