Grafana + InfluxDB / ETL Developer

Project Overview

We are building an analytics module for an industrial tracking system (SINTRA).

The system tracks assets (e.g. pallets) using smartphone-based 3D positioning (X, Y, Z).
We already collect high-frequency data (time-series in InfluxDB).

Goal:
Build a Stability Analysis Dashboard to evaluate:

data quality
tracking stability
device & zone performance
detection issues
⚠️ Important Architecture (Must Follow)

This project has a strict split:

Backend / ETL (YOU BUILD)

all calculations (jitter, jumps, gaps)
scoring (0–100)
classification (GREEN / YELLOW / RED)
aggregations (1 min, 5 min, etc.)
Grafana (YOU BUILD)

dashboards
charts
tables
filters
alerts
❗ No business logic in Grafana

ScopeETL / Backend

process time-series data (x, y, z, timestamp)
calculate:
jitter (std deviation)
jump detection
visibility gaps
build aggregated datasets:
asset level
device level
zone level
Grafana

Build 3 dashboards:

Overview (KPIs, problem assets, trends)
Asset Detail (time series, scatter, histogram)
Setup Dashboard (zone/device quality)
Alerts

unstable assets
low visibility
device issues
Required Skills

Grafana (advanced dashboards)
InfluxDB (or similar time-series DB)
SQL / Flux
ETL / data processing experience
Preferred

IoT / industrial data
high-frequency data handling
Deliverables

ETL logic for stability KPIs
prepared datasets
3 Grafana dashboards
alert rules
Timeline

~20–30 person days
~3–6 weeks
How to Apply

Please include:

Grafana dashboard examples
Experience with time-series data
Short explanation:
how you separate ETL and dashboard logic
Important

We are looking for someone who understands:

data → KPIs → dashboards (end-to-end)