Expertise: system engineering
Expertise Group: Information Systems
Consultant Source: National
TOR Keywords: system enginenring, flood forecast and early warning system
Objective and Purpose of the Assignment
Integrating the various existing Flood Forecasting and Early Warning Systems (FFEWS) in Indonesia into a
single, unified system is crucial for improving coordination, efficiency, and the overall effectiveness
of flood risk management. Currently, multiple FFEWS operated by different agencies and regional
authorities often use separate platforms, data standards, and communication protocols, which can lead to
fragmented information, inconsistent alerts, and delayed responses during critical flood events. A fully
integrated FFEWS would centralize real-time hydrometeorological data, unify modeling approaches, and
standardize communication workflows across all river basins and administrative levels.
This integration would enhance data interoperability, reduce duplication of efforts, and ensure
consistent and accurate flood warnings nationwide. It would also support decision-making at both
national and local levels by providing a comprehensive view of flood risks, enabling early, coordinated,
and more effective responses. Moreover, a single integrated platform can optimize resource allocation,
streamline maintenance of monitoring infrastructure, and foster stronger institutional collaboration
among government agencies, technical institutions, and communities.
Scope of Work
The Consultant will conduct and responsible for integrating previous various FFEWS platforms into a
single dashboard, to be displayed at the national FFEWS Centre in the Directorate General of Water
Resources (DGWR), Indonesia. The mobilization aims to start collecting the existing FFWES in RBOs and
integrating to national control room. The outputs of this assignment must be closely coordinated and
synchronized with the upcoming main consulting services to ensure continuity, alignment, and to avoid
duplication of tasks.
Detailed Tasks and/or Expected Output
The responsibilities of the consultant should comply with the tasks below:
A. System Inventory and Data Architecture Assessment
This component aims to evaluate the current state of existing FFEWS platforms and data infrastructure to
map integration opportunities and identify technical constraints.
i. Conduct a comprehensive audit of existing FFEWS platforms, including regional RBO systems, BMKG data
services, and DGWR telemetry servers.
ii. Identify types of databases used (e.g., PostgreSQL/PostGIS, SQL Server, MySQL, SQLite, NoSQL) along
with their schema structures and communication protocols (e.g., REST API, MQTT, FTP, ODBC/JDBC).
iii. Document end-to-end data flow—from telemetry acquisition to model inputs, model outputs to forecast
generation, and dissemination of alerts to the public—while outlining any integration challenges and
limitations.
B. ETL Process Design and Implementation
This component focuses on building a reliable and standardized data integration pipeline for
hydrological and meteorological datasets.
i. Design and develop robust ETL (Extract, Transform, Load) pipelines that:
· Extract data from various sources via direct database connectors, APIs, or file-based inputs (e.g.,
CSV, JSON, XML, NetCDF).
· Transform data by converting units, aligning timestamps, cleaning anomalies, and applying consistent
spatial references.
· Load processed data into a centralized time-series database, such as InfluxDB, TimescaleDB, or
PostgreSQL with PostGIS extension.
ii. Schedule and automate ETL workflows using tools like cron jobs or workflow orchestration engines
such as Apache Airflow or Apache NiFi.
C. API Gateway and Standardized Data Services
This phase will establish a unified access mechanism for stakeholders to interact with integrated FFEWS
data efficiently and securely.
i. Develop an API gateway compliant with OpenAPI/Swagger standards to provide unified access to
integrated FFEWS data.
ii. Provide well-documented endpoints for:
· Real-time telemetry data (e.g., rainfall, river water levels, reservoir levels).
· Hydrological model outputs (e.g., flood extent, hydrographs, return periods).
· Forecast and early warning status.
· System diagnostics and health monitoring.
D. Dashboard and Interactive Visualization Development
This component aims to deliver a real-time, user-friendly national FFEWS dashboard with geospatial
capabilities.
i. Develop a responsive, GIS-enabled web dashboard using modern technologies such as React.js or Vue.js
with Mapbox or Leaflet for interactive mapping.
ii. Visualize dynamic real-time data layers, including:
· Hydromet station status, flood risk zones, rainfall accumulation, model outputs, and early warning
alerts.
iii. Implement interactive filtering features by basin (watershed), region, severity level, and forecast
lead time.
iv. Backend development using technologies such as Node.js, Django, or FastAPI, with integration to
geospatial servers (e.g., GeoServer, MapServer).
Minimum Qualification Requirements
General Qualifications:
- Minimum of 5 years of experience in information system. Master or equivalent in computer science or
Information System or other highly related science.
Specific Experience: - Experience working on water resources information system projects for a minimum 3 years is preferred.
- Strong understanding of database management, hydrology, water resources modelling and flood early
warning system frameworks for disaster risk reduction would be an advantage. - Excellent communication, stakeholder engagement, and reporting skills in English
The consultant has experience in information system development and hydrological works. That refers to
all observation systems typically used by a DGWR or National Climatology Meteorological Agency. The CV
of the candidate(s) with proficiency in the following systems is advantage, namely: - Automatic surface water level and discharge stations;
- Water quality (both surface and groundwater);
- Automatic rain gauges;
- Discharge (stream gauging) measurements;
- Doppler Weather Radar Network, including the use of dual-polarized radars and developing Quantitative
Precipitation Estimates (QPE) and Quantitative Precipitation Forecasts (QPF); - Early warning design, setup, and operation for extreme hydro-meteorological events.;
- Expertise in relational and time-series databases: PostgreSQL/PostGIS, MySQL, TimescaleDB, InfluxDB,
and etc. - Familiarity with NoSQL databases such as MongoDB or Cassandra for storing unstructured or log data.
- Ability to implement data normalization, metadata standards (ISO 19115), and real-time synchronization.
- Experience with hydrological/hydraulic modeling systems (e.g., HEC, MIKE, SOBEK) integration is a plus.
- Familiarity with disaster management systems (e.g., InaRISK, InaSAFE).
- Understanding of IoT/telemetry systems (e.g., MQTT brokers, LoRaWAN, edge devices).
Minimum General Experience: 5 Years
Minimum Specific Experience (relevant to assignment): 3 Years
