Reporting & Work Relationships
- Reports to: Information Systems Manager
- Duty Station: KK Main Office, with travel to field locations at least each quarter.
Internal interactions
Programme/Operations teams.
MEAL and Partnerships and Donor Relations staff, Finance, HR, Logistics, and other support departments.
Senior management when required.
External interactions: As assigned by the Information Systems Manager.
Key Duties & Responsibilities.
Develop and maintain complex SQL queries, views, stored procedures, triggers, and reports using PostgreSQL and MySQL to support operational and management information needs.
Analyze and consolidate data from GOIMS and other organizational data sources to produce accurate, timely, and reliable management, operational, and donor reports.
Support HALO data reporting in IMSMA Core, ensuring accurate, timely, and reliable data for operational and management reporting.
Design, develop, and maintain interactive dashboards, charts, and data visualizations using Power BI to support data-driven decision-making.
Monitor and improve data quality, integrity, and consistency through data validation, cleansing, transformation, reconciliation, and quality-control processes.
Analyze and optimize SQL queries, database structures, and reporting processes to improve database performance, system efficiency, and reporting response times.
Design, develop, deploy, and maintain desktop-based and web applications that support organizational operational and information management requirements.
Maintain, enhance, and troubleshoot existing HALO business applications, including Payroll, HRMIS, Fleet, and Clinic systems, ensuring reliability and alignment with evolving business needs.
Design, configure, and manage Survey123 data collection forms and workflows, integrating field-collected data with PostgreSQL databases and ArcGIS Enterprise.
Develop and maintain advanced maps, feature layers, geospatial datasets, and spatial analyses using ArcGIS Pro to support operational planning, monitoring, and decision-making.
Provide technical support for system integration, database and application troubleshooting, data-related issues, and system enhancements across relevant platforms.
Develop and maintain technical documentation, including database structures, data workflows, system configurations, reporting processes, and user guidance.
Identify opportunities for automation, process improvement, and system enhancement to strengthen data management, reporting efficiency, information quality, and organizational decision-making.
Required Skills & Qualifications
Bachelor’s degree in computer science, Information Technology, Data Science, Software Engineering, or another related field, and Master’s degree will be considered an asset.
5-7 years of relevant professional experience in database development, data analysis, MIS, software development or Data Science.
Strong knowledge of SQL, particularly PostgreSQL and MySQL, with the ability to develop complex queries and optimize database performance.
Strong understanding of RDBMS concepts, database design, relationships, normalization, indexing, and data integrity.
Practical programming experience with technologies such as C#, ASP.NET MVC, PHP, Python, JavaScript, HTML, CSS, jQuery, ReactJS, or Next.js.
Experience with Power BI for dashboard development, reporting, and data visualization.
Experience with ArcGIS Pro, ArcGIS Enterprise, Survey123, feature layers, and spatial analysis.
Good knowledge of data quality, validation, transformation, system integration, and troubleshooting.
Strong analytical, problem-solving, and technical documentation skills.
Behavioural Expectations
Reliable, punctual, and collaborative.
Committed to HALO values and confidentiality.
Respectful and able to work under pressure.
Language Skills
- Excellent communication skills in English, both written and spoken.
- Fluency in Dari and Pashto is desirable.
Core Competencies
- Strong interpersonal and communication skills, with the ability to coach, mentor, and motivate staff.
- Excellent organizational and analytical skills with strong attention to detail.
- Ability to manage multiple priorities and meet deadlines under pressure.
- Demonstrated problem-solving skills and a proactive approach to improving systems and processes.
- Commitment to professional integrity, teamwork, and continuous improvement.
Other Requirements
- Willingness to travel frequently to field and operational locations as required.
- Strong commitment to HALO’s mission, values, and quality standards.
- Ability to work independently with minimal supervision.
- Understanding of gender, diversity, and inclusion principles in conducting survey practices.