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.