The vendor is required to provide that on-call data architecture modernization support services from qualified firms with expertise in data system architecture, data management, and cloud-based data solution.
- The discretion to modify, expand or delete any portion of the project outlined in this RFQ.
- to reject any or all of the responses to this RFQ without cause and accept any response that, in the city’s sole judgment, will be in the best interest of the city.
- The third largest water resource recovery facility (WRRF) in state, treating approximately 20 million gallons per day (MGD) of residential and industrial wastewater from 300,000 residents.
- Key enterprise data systems that are included in implementation effort include:
• Real-time process and operational data with over 4,500 tags
• Lab data with over 1,500 analytes collected at multiple locations at the plant and within the environment
• Manually entered data such as operator logs and information obtained during rounds; water information management system (WIMS) is also currently used to store operational data and laboratory data.
- Like to build a centralized data architecture considering, but not limited to the following requirements:
• Centralizes multiple data sources utilizing custom ETL/ELT flows into a common repository,
• Allows for building a data warehouse or data lake house for diverse data sources,
• Facilitates data governance, data security and privacy, and data quality management,
• Has low latency,
• Relatively simple user interface,
• Highly available to other software for read/write operations,
• feeds operational data to solutions for reporting and analysis,
• Assists with metadata management,
• Has transparent and easily accessible documentation related to data flows.
- The data management staff in supplementing their skills and providing project expertise and recommendations.
- The successful implementation of a new data architecture should allow for the following:
• Fulfilling regulatory reporting requirements
• Providing SPR employees with accessible and reliable data
• Informing metrics and key performance indicators (KPIS)
• Migrating existing datasets as required
• Enhancing communications with stakeholders
- Specific needs expected as part of the implementation include the following:
• Data architecture recommendations.
• Configuring the cloud-based tools and network.
• Addressing cybersecurity considerations, data governance, and permissions.
• building ETL/ELT pipelines between original data sources and the new data architecture.
• Navigating data flows from original data sources through firewalls.
• Implementing cost controls to avoid overspending on variable cloud costs.
• Developing a data warehouse/lake house on top of the data lake.
• Coordinating between and city of englewood it staff.
• Change management efforts within to support the selected solution.
• Training for the staff to maintain and monitor the repository
• A comprehensive estimation for annual costs related to the creation, deployment, and maintenance of the solution.
• Documenting infrastructure configurations, extract transform load/ extract load transform (ETL/ELT) processes, data architecture, and data lake house/warehouse in collaboration with spr.
• Other items as assigned and agreed upon by both parties
- Contract Period/Term: 1 year
- Questions/Inquires Deadline: January 30, 2025