Hydrology Data Processing & Analytics Officer

Irrigation Department; Sukkur; On-site; PKR 450,000 - 600,000; Full time

Job summary

The Irrigation Department in Sukkur invites applications for the Data Processing Assistant (BS-16). The role manages and analyzes hydrological, meteorological, and irrigation data to support water resource planning, flood forecasting, and canal operation scheduling.

The officer maintains centralized databases, runs ETL pipelines, and generates periodic reports using SQL Server, PostgreSQL, Python, ArcGIS/QGIS and advanced Excel to ensure 99% data accuracy and timely flood data delivery.

Qualifications

• Experience designing and managing relational and spatial databases.
• Experience building ETL pipelines for real-time telemetry data.
• Strong understanding of data quality, validation, and audits.

Responsibilities

• Design, implement, and maintain relational and spatial databases for canal flow, rainfall, and groundwater monitoring networks
• Develop and automate ETL pipelines to ingest real-time telemetry data from SCADA systems and manual gauge entries
• Perform statistical analysis and predictive modeling for seasonal water availability and crop water requirement estimation
• Generate and disseminate standardized irrigation performance reports, dashboards, and GIS maps for senior management and stakeholders
• Ensure data quality through validation rules, anomaly detection algorithms, and regular audits against field measurement records
• Coordinate with field divisions, WAPDA, and Met Department to resolve data gaps and integrate multi-source datasets into the central IMIS

Skills

SQL Server

PostgreSQL

Python (pandas)

ETL pipelines

GIS analysis

Excel

Statistical analysis

Education

MCS/MSc Computer Science/IT or equivalent

Tools

SQL Server

PostgreSQL

Python (pandas)

ArcGIS

QGIS

Excel (Advanced)

Job description

The Irrigation Department in Sukkur invites applications for the Data Processing Assistant (BS-16). The role manages and analyzes hydrological, meteorological, and irrigation data to support water resource planning, flood forecasting, and canal operation scheduling.

The officer maintains centralized databases, runs ETL pipelines, and generates periodic reports using SQL Server, PostgreSQL, Python, ArcGIS/QGIS and advanced Excel to ensure 99% data accuracy and timely flood data delivery.