Request for Proposals for Data Analytics Platform Services

Silicon Valley Clean Energy (SVCE) is seeking proposals for the development and implementation of DAISY 2.0, a cloud-based data analytics platform to expand and enhance their current data warehouse (DAISY 1.0). The platform will serve as a central, secure repository of data with proper ETL (Extract, Transform, Load) systems to enable efficient, high-impact analyses and reporting via integrated applications and tools. The scope includes: (1) Cloud Data Platform Deployment (4-6 weeks) - either managing existing Google Cloud Platform infrastructure or migrating from GCP to an alternative cloud platform, including setting up ETL pipelines, migrating dashboards, and documenting data provenance; (2) Tools Deployment - operationalizing enabling tools including geocoding, spatial analysis, address standardization, and weather normalization; (3) Ongoing Services (up to 3-year contract term) including system administration, data security, ETL pipeline maintenance, dataset ingestion, dashboard/report development, and user support. The platform should derive four levels of insight: Descriptive (current state), Diagnostic (how current state was achieved), Predictive (future outcomes), and Prescriptive (recommended actions). Core functionalities include data storage, ETL of multiple data sources (weather, CAISO market data, program data, resource/asset data, air quality data), data warehousing, visualization with mapping capability, customizable dashboards and reports, user access permissions, custom table creation, third-party application integration (Excel, Tableau), query library with version control, and data provenance tracking. The solution must support multiple user tiers with customizable access permissions. Bidders should propose either a Professional Services Contract (time & materials) or SaaS Contract model. Open-source solutions are preferred over proprietary solutions. The platform must be able to migrate from existing DAISY 1.0 in Google BigQuery, integrate with SVCE systems (CRM, ETRM), and be extensible for additional datasets and tables. Security requirements include SOC 2 Type 2 audit report (preferred) or SOC 2 Type 1/ISO certification, routine internal and external vulnerability testing, Information Security policy documentation, and cybersecurity insurance of at least $5,000,000 per occurrence. The solution should be designed to allow other California-based Community Choice Energy agencies to access similar services on comparable terms.