EMIS Database Developer/Administrator

The primary objective of an EMIS for DIL is to have a consolidated, uniform and user-friendly data repository that can help in generating detailed reports on DIL schools, staff, students and other activities such as trainings and evaluations. This will result in enhancing the decision making capabilities both on an organizational and departmental level.

Duties:

• Prepare a detailed design for an EMIS for data entry, storage, and report generation in collaboration with DIL’s M&E Department.
• Review the information provided by DIL about educational indicators, data collection tools, timelines, data flow and reporting requirements.
• Develop core EMIS modules (Training Dept., Program Dept.)
• Design and generate custom reports from the database, with options to select what fields and what time period the report covers (monthly, quarterly and annual) and what scope (assets/school data/all schools/provinces/grades etc.).
• Create simple automated mechanisms to export key data or customized reports to excel and other formats for additional analysis.
• Design a series of common basic queries that staff can easily run.
• Test the functionality of the new database.
• Data migration from Excel to EMIS.
• Define multiple and customizable access levels for DIL users.
• Finalize and complete the system.
• Ensure transfer of key knowledge in the maintenance, adjustment, expansion and trouble shooting of EMIS database.
• Conduct a training workshop.
• Assistance in resolving any problems with data entry or management and reporting from existing tables. (Post development).
• Manage and debug the database regularly.

Requirements:

• BS in Computer Science or equivalent.
• At least 1-2 years of relevant experience in software, applications and database development.
• Must have a strong working knowledge of MS Access, PHP, Javascript and MySQL.
• Successful candidate must have good development track record to write and troubleshoot SQL Code (stored procedures, functions, tables, views, triggers, indexes, constraints).
• Experience with programming language such as Java and PHP.
• Excellent verbal and written communication skills.
• Hands on experience with Web page development.
• Hands-on experience with .NET and Java programming languages.
• Proficient with MS Sharepoint.