Purpose
To design a dashboard so as to enable effective and efficient data collection processes and run automated analytics to understand and visualize the data across a range of variables, helping management teams to lift performance and accountability across BRAC International Offices, leading to greater impact of our work on the ground.
Scope of Work (Role and Responsibilities)
Take lead in designing the dashboard and capacitating the CO Teams to manage the dashboard:
Design a dashboard for tracking performance, improvement and accountability of the performance standards using either excel or any other free to use software package in agreement with Regional Office management.
Design standard formulas within the dashboard for generating graphs and tables that should be automatically generated from the master sheet including: Performance Tables per category of standards for each Country, Overall Performance per Country and Region, Quarterly Trends analysis Tables per category of standards for each Country, Quarterly overall performance Trends analysis graphs per Country and Region for 4 quarters. The programming should ensure restricted permission to the relevant staff. I.e some areas of the spreadsheets or tabs should be locked for access or hidden so as to maintain confidentiality among unauthorized users only.
Deliver training to CO teams and other relevant teams on how to fill/update, manage and navigate through the dashboard
Support in operationalizing of the Dashboard to the Country Office Teams for performance assessment, improvement and accountability
Practice, promote and endorse the issues of safeguarding policy among team members and ensure the implementation of safeguarding standards in every course of action.
Follow the safeguarding reporting procedure in case any reportable incident takes place, encourage others to do so.
Major Deliverables
Detailed work plan (including meetings with relevant stakeholders) – 3 Day
Functional Dash Board developed (Including Piloting/Testing) – 12 Days
Training delivered to teams in 9 BI Countries in Africa and Asia – 4 Days
A completed dashboard using Q1_2024 data set (including data collection and verification) – 10 Days
Produce automatically generated Tables and graphs of analytics from the master sheet of all the standards using the Q1_2024 data set for 2 Regions (Africa and Asia) in 9 Countries (6 in Africa and 3 in Asia) including: Performance Tables per category of standards for each Country, Overall Performance per Country and Region, Quarterly Trends analysis Tables per category of standards for each Country, Quarterly overall performance Trends analysis graphs per Country and Region). – 6 Days
Requirements and Qualifications:
In order to execute the above listed roles for the Dashboard Programmer consultancy services efficiently, BRAC International (RO) needs a technical consultant as shown below.
Job summary:
Responsible for designing a dashboards so as to enable effective and efficient data collection process and run analytics to help lift performance and accountability across BRAC International Africa Offices, leading to greater impact of our work on the ground.
Qualification:
Degree in Economics, Social Sciences, Development Studies, Organisational Development, IT, or equivalent is required.
Experience: in designing dashboards/soft systems and working with teams.
Skills:
Excellent written and spoken English and communication skills (both written and oral) to interact with people/teams of diverse background, data analysis and report writing
Basic Technical knowledge of Monitoring and Evaluation and Learning functions and management. Plus data analysis and report writing
Technical knowledge and practice of software development and programming (especially excel)
Terms and Conditions
The consultant will closely work with the Head of Quality, Performance and Operations, Focal Staff at the Country Offices, and Regional Office in completing the above mentioned scope of work.
He will also be supported by the Deputy Regional Director to accomplish the above-mentioned activities. All the information gathered/generated during the process shall be the intellectual property of BRAC International, which shall not be shared with any third party without prior written consent of BRAC International.
If you meet the above qualifications, please submit a technical proposal detailing your previous experience in conducting similar work, a proposed work plan with tentative timeline, a proposed budget, and CVs. The technical proposal should be no more than five pages (excluding budget and CVs).All proposals must be submitted by email to bracafrica@brac.net with a Cc to norah.ngina@brac.net no later than 13th March 2024 at 11.59pm East African Time (EAT)
Apply via :
bracafrica@brac.net
