Grafana Dashboard + Node-RED Flow Developer for MQTT-Based Lift Station Monitoring

---

We are a municipal agency seeking a skilled freelancer to assist in finalizing an IoT-based monitoring system for multiple wastewater lift stations. The MQTT server is already operational, and sensor data is actively publishing. We now need help building a clean, functional Grafana dashboard and enhancing Node-RED flows for alerting, logic, and historical tracking. Project Scope: Create one or more Grafana dashboards to visualize data such as: Wet well levels (line chart or gauge) Pump status (on/off indicators) Power source (normal/generator) Active alarms and historical trends Integrate time-series database (InfluxDB preferred) for historical logging Assist with or review existing Node-RED flows for: Alarm triggers (high level, long run time, power failure, etc.) Notifications via email/SMS Pump runtime and cycle tracking logic Recommend improvements for reliability, alert accuracy, and performance Ability to scale to 3 sites on dashboard Requirements: Experience with Grafana dashboards (bonus for public works or utility layouts) Strong Node-RED flow logic building (including timers, counters, and alerting nodes) MQTT topic structure understanding (we already have broker in place) Familiarity with Modbus, lift station sensors, or municipal SCADA systems is a plus Our Environment: MQTT Broker: Eclipse Mosquitto (running on Synology NAS) Node-RED: Docker-based deployment Grafana: Hosted on same NAS (or external VM) Topic Structure Example: SmartDEN_Notifier/E8EADA006EB0/liftstation1/pump1_status Deliverables: Finalized Grafana dashboards (JSON export and/or implemented directly) Updated and documented Node-RED flows Optional: Setup of InfluxDB for historical storage if not already configured To Apply: Please include examples of past Grafana or Node-RED work, especially for industrial or utility applications. Bonus if you’ve worked with municipalities, pump systems, or SCADA replacements.

Keyword: Python

Docker Grafana Database MQTT