About the Role:

• The MIS Developer will work collaboratively with the Monitoring, Evaluation, and Learning (MEL) team, comprised of the Head of Metrics, M&E Specialist, Database Specialist, and M&E Advisor. Their primary focus will be to design and implement a robust MEL framework to assess the impact of JGP’s investments.
• The M&E team will delegate a dedicated team member to support the consultant to gain a sound understanding the scope of the assignment and to deliver effectively. The M&E team will also offer regular support through regular updates in a scheduled manner and on need basis. In addition, the successful consultant will be expected to work with the JGP partners to understand their specific data needs and processes, validate the system and conduct user training.
• The MIS Developer will be responsible for designing, developing, implementing, and maintaining databases using the PostgreSQL relational database management system (RDBMS).

Specific Roles and Responsibilities:

• Assist the MEL team in identifying key project indicators and disaggregating data collection points as needed.
• Propose a statistically robust methodology for tracking, analyzing, and reporting performance based on these indicators.
• Continuously monitor and optimize the PostgreSQL database design and performance.
• Collaborate with the MEL team to understand data requirements and ensure data integrity.
• Generate detailed survey reports linking results to project interventions.
• Jointly work with JGP data specialist to deliver a functional database that supports the set specific objectives. The database should support receiving reports from 7 JGP partners contributing to specific metrics.
• Regularly update the JGP team (Central team and JGP partners) on development progress, system validation and user testing.
• Support partners on the system use it to upload micro-data reports and generate aggregate reports.

Selection Criteria:

To be considered for this role, you will have the following to satisfy the criteria:

• A strong understanding of Structured Query Language (SQL) is essential for querying, manipulating, and analyzing data within the PostgreSQL environment. This includes proficiency in writing complex queries, using functions, triggers, stored procedures, and views.
• Solid understanding of database design principles like normalization, data modeling, and indexing is crucial to create efficient and scalable databases.
• Expertise in integrating data from various sources is necessary. This includes understanding data extraction, transformation, and loading (ETL) processes, working with data APIs, and managing data quality during integration.
• Knowledge of data visualization tools like Power BI, Tableau, or other platforms is beneficial. Understanding how to connect these tools to PostgreSQL and translate database queries into meaningful visualizations is valuable.
• The ability to design and develop interactive dashboards that effectively communicate insights gleaned from the PostgreSQL data is a plus. Familiarity with dashboard design principles and best practices allows creation of user-friendly and informative dashboard
• Many PostgreSQL deployments run on Linux or Unix-based systems. Basic understanding of command-line tools and navigating these operating systems is often helpful.