Cloud Data Warehouse and API Programmer (Real Estate Industry)

An estimate of hours to complete will be required in order to get the budget approved. An executed non-disclosure agreement is also required.

Preferred tools: Python, PostgreSQL, Google Cloud Platform, and an open source dashboard (open to suggestions).

Setup Data Warehouse
-Google Cloud
-PostgreSQL
-Big Query

Setup Data Scripts
-Python
-ETL to data warehouse
-API Script (JSON data format)

Data Sources (3rd Party Data)
Phase 1 - Local Building Permits from Open Data API (1 data source)
Phase 2 - Local MLS (Multiple Listing Service) data from API (1 data source)
Phase 3 - US Census data from FTP site (1 data source)
Phase 4 - Federal Reserve data from API (multiple data sources)
(Potential Phase 5 for additional data sources)

Basic Front End GUI/Dashboard (browser based)
-Interactive/Dynamic Dashboard for data (Charts/Graphs, etc.)
-Data utilities/data input screens for non-technical users