Project: Kenya Off-Grid Solar Access Programme (KOSAP)
Scope: KOSAP Facilities (Debt and Results-based Financing Facilities)
Job Description
Under the guidance of the KFM, the Database Processor – Technical is responsible for the overall development and maintenance of the KOSAP Facilities Data Management System, development of the necessary ICT tools, the generation and supply of digital analyses and reports from the systems. He/she is responsible for recommending, and upon approval by the KFM Team Leader, applying modifications and upgrades required thereof.
Description of Data Management Systems
These are any ICT systems deemed necessary by the KOSAP Facilities Manager to be required or necessary for, among other relevant functions, the effective receipt, acquisition, storage, retrieval, deployment, analysis, presentation, trail, query and audit of any KOSAP Facilities’ related data. The tools to be used include, but are not limited to, database management systems, web panels and phone-based applications. These must be developed and maintained in accordance to the Data Protection Act (2019).
Detailed Tasks
1. Maintenance
Maintain database system(s) and web panels of high availability and quality depending on each user’s specialised role and pre-defined data metrics.
Design and implement databases in accordance to end users’ information needs and views; the KFM Team will provide, from time to time, templates to be used in the Facilities for data collection or analysis, which will be the basis on which databases may be developed.
Update and maintain KOSAP-FM website (domiciled at www.kosap-fm.or.ke or as may be directed by the KOSAP Facilities Manager).
Maintain online tools for use by the KOSAP Team or other users as may be determined by the KFM.
They include:
A visitor’s count function.
A function that shows pages that are frequently visited and the most downloaded documents.
Receiving applications: Develop a tab where applicants will log in, upload their proposal and from where they receive an auto reply. This platform will then be disabled after the set proposal submission deadline.
2. Compliance/Security
Ensure the database management systems adhere to best practice, comply with the Data Protection Act of 2019, and are accordingly updated.
Ensure that the database systems, web panels, applications and website are always functional.
Ensure that the data tools and systems comply with third party rights of ownership and use in line with the Data Protection Act, 2019.
Ensure the website is secure and uses SSL encryption.
Ensure the website, backend database, and APIs are scalable.
Ensure the website loads fast enough and experiences minimal downtimes.
Optimise the website for different devices, browsers, data speed, search engines, and users and ensure it is user friendly.
3. Data Management – Receipt, Storage, Maintenance
Minimise database downtime and manage parameters to provide fast query responses
Perform tests and evaluations regularly to ensure data security, privacy and integrity in line with the Data Protection Act, 2019.
Monitor database performance, implement changes and apply new patches and versions when required
4. Data Retrieval and Deployment
Define users and enable data distribution to the right user, in an appropriate format and on time.
Undertake data retrieval on both a generic and need basis.
Supply data and data analysis monthly or as directed by the KFM.
5. Data Analysis and Reporting
Undertake special-purpose Data Manipulation and Presentation
Support KOSAP Facilities monitoring and evaluation with the required data retrieval and analyses.
Visualise data using Power BI and Pivot Tables on a monthly basis or as directed by the KFM.
Perform data quality checks based on the set constraints and requirements.
6. Training and support
Provide proactive and reactive data management support and training to users.
Develop and update guidelines on uploading data to the reporting portal.
Train and support recipients in uploading data to the reporting portal.
7. CRM
Identify an appropriate CRM platform for use by the project.
Design and develop the CRM based on the project requirements.
Maintain data and information on the CRM.
Ensure the CRM is secure.
8. Match-Making platform
Provide reports monthly based on the use of the platform.
Generate and analyse information on match-making platform use and effectiveness.
9. Data Visualization and interactive map
Design and maintain an impact page with an interactive map showing sales achieved/ debt secured.
Create a dashboard showing project KPIs: power installed, the number of jobs created, female-headed households’ beneficiaries and avoided CO2 emission.
Supply data and analysis monthly or as directed by the KFM
Qualifications
University Degree in Information Technology or another relevant field.
At least 3 years’ work experience as part of, and within a busy coding environment.
Proven working experience as a Database developer/administrator and Website developer
Hands-on experience with database standards and end user applications.
Capability to independently execute database concepts, design, documentation and coding.
Previous experience with Database Administration and Web-based case tools (frontend/backend) and third-party tools.
In-depth understanding of data management and online web-based technologies and tools (e.g., permissions, recovery, security and monitoring). Ability to implement encryption is mandatory.
Knowledge of software development, coding and user interface web applications.
Excellent analytical and organisation skills.
An ability to understand front-end users’ requirements and a problem-solving attitude.
Excellent verbal and written communication skills.
Team player
Apply via :
jobs.smartrecruiters.com
