Pakistan: Database Programmer

Khyber Pakhtunkhwa Education Sector Programme (KESP) – Terms of Reference

Fixed Term Technical Assistance: Database Programmer

Programme Background

The Khyber Pakhtunkhwa Education Sector Programme (KESP) Technical Assistance (TA) team’s mission is to work at provincial, sub-provincial and school levels to provide comprehensive, flexible and high quality technical support to the Government of Khyber Pakhtunkhwa in the delivery of its strategy and priorities for transforming education service delivery. The TA constitutes a component of the wider DFID and DFAT-funded KESP programme, which also includes Sector Budget Support, and an infrastructure component.

A new Education Sector Plan (ESP) for the period 2015-2020 has recently been launched, with an accompanying Joint Review Framework (JRF) and describes the KP Government’s comprehensive and ambitious strategy for the development of the elementary and secondary school sector in the Province. It details ten priorities: (i) redeveloping the approach to training and selecting new teachers; (ii) developing a consolidated, needs based, high quality approach to CPD; (iii) redeveloping teaching cadre employment rules; (iv) establishing a sustainable approach to provision of facilities; (v) launching new benefits aimed at children most at risk of educational deprivation; (vi) scaling up partnerships with the private sector; (vii) launching a draw down fund for use in emergency situations; (viii) testing and updating of population data; (ix) developing of district officials’ management skills; and (x) pegging the education budget to inflation.

Purpose of Role

Purpose of this role is to develop a Budget Execution Tracking (BET) Software for monitoring the Current and Development Budget Execution in all the districts of Khyber Pakhtunkhwa.

Background

Headline Policy 9 of ESP 2015-20, advocates the development of district officials management skills in three key areas of a) Information Management b) Budgeting and financial management and c) planning. In order to implement the policy 9 and its resultant activities at district level, KESP TA aims to establish a District Delivery Unit at Directorate of Education, in Peshawar, Khyber Pakhtunkhwa. Delivery Manger Districts will head District Delivery Unit. The unit will provide support to the Directorate to develop the capacity of District Education Officials for improved service delivery and effective governance.

Scope of work of District Delivery Unit will entail three broad areas of delivery which are mentioned as follows:

1. 
   

   Development and Monitoring of District Education Plans (DEPs) of 25 districts of Khyber Pakhtunkhwa;

   
   


2. 
   

   Monitoring the Execution of budget (both current and development) in all the districts of Khyber Pakhtunkhwa;

   
   


3. 
   

   Monitor the Execution of Conditional Grants at district level.

   
   

Responsibilities

The Programmer will undertake the following tasks:

• Develop a Budget Execution Tracking (BET) Software in consultation with Director Education, Deputy Director, Section Officer Budget and Delivery Manger Districts to monitor the budget execution for current (non-salary) budget activities in all the districts of Khyber Pakhtunkhwa;


• The programmer will be managing, modelling, supervising, maintaining and back-up procedures on monthly basis;


• Programmer will also conduct database cleaning, merging, verification and validation of data with the help of Database Managers;


• Maintain close liaison with IT Providers and suggest integration of various databases (such as EMIS, IMU, EEF and C&W department) maintained by the E&SED;


• Any other task assigned by Director Education and Delivery Manager Districts;

Deliverables

Development and operationalization of Budget Execution Tracking (BET) Software.

Additional activities

The Delivery Manager Districts (Adam Smith International) and Director Education (GoKP) may assign additional tasks.

Qualification and Experience

• At least BSCS or MCS from reputable Institute/University


• MCSA-SQL SERVER certification


• 5-7 years of experience

Duration

130 days from December 2015 – June 2016.

Location of work

The adviser will be based in District Delivery Unit at Directorate of Education in Peshawar, Pakistan