Job Description
JOB SUMMARY
Systematically assess the quality of the databases
Proceed to final data cleaning including designing, maintaining, executing and documenting database tests.
Identify gaps in information and instruct the Consortium on how to complement the information using the software application available.
Consolidate essential beneficiaries’ information in a single database.
Improve the system to collect the data to harmonize the information management.
Issue recommendations on how to streamline the information management system including database structure, data quality, documentation, and software applications
ACTIVITIES
Audit and assess the database and systems in place
Proceed with data cleaning and gaps analysis
Inform BRCiS Members on the status of the data base and design a data patching plan agreed and reviewed by the Consortium
Create a beneficiary “Cap” system to control for double counting, neighbouring village beneficiaries and IDP beneficiaries within the Manager’s Form dataset.
Create a “Qlikcloud” beneficiaries served dashboard drawing from ONA and Manager’s Form datasets that allows disaggregation of beneficiaries by location, time and activity, as well as overall beneficiaries without double-counting.
Lead the process of patching data gaps with the Members
Consolidate the beneficiaries information database and upload it to the server as needed
Based on the conclusions of the audit and assessments, draft an information management plan to improve the Consortium information management system
Review and validate the plan with the BRCiS Members
Review software and data collection, cleaning and warehousing to take forward the recommendations of the plans
Develop guidance documents, training materials for the Consortium Members to implement the information management plan as required.
DELIVERABLES
Initial database assessment report and plan to address the gaps
Creation a beneficiary “Cap” system within the Manager’s Form dataset.
Creation of a “Qlikcloud” beneficiaries served dashboard.
Consolidated data base and dashboard
Information management plan
Training material and guidance documents for the BRCiS Member and CMU to support consultant activities/deliverables
Final report and presentation of the work accomplished.
QUALIFICATIONS
Must be a Top-notch problem solver and very detail oriented.
Ability to manoeuvre and debug within the application’s source code.
Excellent analytical, detail-oriented, presentation and problem solving skills.
Proven work experience as a system analyst and developer.
Professional Software Development (ex: Web development in JS, PHP and HTML).
Experience in developing Data Visualization Tools/Dashboard using QlikSense and Qlikview.
Experience with Data Modelling tool and methodology.
Expert database skills including complex SQL queries, performance tuning and database development (DDL, DML, stored procedures etc.).
Experiences in Auditing Databases and Documenting the findings.
Knowledge and use of Mobile Data Collection platforms such as ONA and ODK.
CRITICAL SKILLS
Ability to Conceptualize, Assess and document the current problems/inefficiencies in our database and come up with solutions.
Strong communication and documentation skills.
Strong analytical, problem identification and solving skills.
Ability to complete tasks meeting project plan schedules and deadlines.
TIME FRAME
Work is approximately expected to take place over a 45 day period.
All work must be completed by December 10th 2017.
Consultants open to building upon this experience in further partnerships with BRCiS in 2018 are preferable.
