Employer description & source details
Government water systems (JJM–IMIS, AP Mana Mitra, RWSS) carry uncertain Power BI licensing, and EAII’s current Inline Chlorination (ILC) reporting depends on Power BI – a tool that cannot be embedded natively into state portals or shared with officials who lack licences. This role reports to the Manager, Safe Water Operations. In this role, you will build and harden a lightweight, fully org-owned alternative: standalone HTML/CSS/JavaScript dashboards fed from public Google Sheets CSV exports and REST/JSON endpoints. This removes the licensing barrier, deploys anywhere, and gives EAII full ownership of its reporting stack for the India Safe Water – Inline Chlorination (ISW–ILC) programme. Backend Development & Data Integration Design and build robust backend APIs (REST/JSON) that securely consume, validate, and transform data from government systems (JJM–IMIS, AP Mana Mitra, RWSS) and public Google Sheets CSV exports. Develop data pipelines and ETL processes to standardize government data feeds into a consistent JSON schema accessible to multiple frontend clients. Implement authentication, data validation, error handling, and rate limiting for production-grade API reliability. Architect a configuration layer and data model enabling new indicators, sites, and districts to be added without backend code changes. Conduct a source/API audit and define a data contract and JSON schema during the discovery phase. Work with government IT teams to establish secure, reliable data access and define API SLAs. Prepare comprehensive API documentation, deployment guides, and a maintenance runbook for Program Operations. Present fortnightly demos against agreed milestones; hand over all code and documentation to EAII at the end of the engagement. Months 1–2 – Discovery & setup: source/A
Extracted skills: javascript, node.js, python, java, sql, power bi