BRAC
TERMS OF REFERENCE FOR DASHBOARD PROGRAMMER – CONSULTANCY
CONSULTANCY CONTRACT, TERMS AND CONDITIONS
Consultancy Title: Dashboard Programmer – Consultancy
Consultancy Period: Thirty Five (35) Days within March 2024 to April 2024
Consultancy Location: Remote
1. Terms of reference (hereinafter referred to as ToR):
1.1 Background
BRAC International envisions lifting the quality and accountability across all SBI Country Offices departmental areas in order to improve our performance as well as to provide clarity on what constitutes strong performance in 9 SBI Countries (6 in Africa region: Uganda, Tanzania, Rwanda, South Sudan, Liberia and Sierra Leone) and (3 in Asia Region: Afghanistan, Philippines and Myanmar).
Specifically:
- Country Directors (CDs) to more effectively hold their senior teams to account,
- In turn, Snr Management to hold Country Directors to account for overall Organisational performance in their respective country,
- Target support from across BRAC International to address this, hopefully in a more efficient and effective manner, where we see that performance is dipping/not strong
Hence an Organisational Performance Framework was collaboratively developed across both Country Offices and BI Leadership, which consist of a focused set of Essential Standards across each departmental area, and related KPIs so that we can regularly assess adherence to these standards, as well as to provide the information for management (both at Country level and at BI) to make informed decisions. Hence the need to have a dashboard to communicate the status of the different standards with related KPIs in an easy format to comprehend and inform quick management decisions making.
1.2 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.
1.3 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.
1.4 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
1.5 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.
Position: Dashboard Programmer – Consultant
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)
2.0 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.
BRAC International (RO) will not pay any compensation in any form except for the amount agreed as fee for the agreed scope of work and time, unless outlined in this contract, or agreed in writing between the two parties.
The Consultant work will be performed with due professional care, in accordance with appropriate professional consulting practice.
How to apply
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 [email protected] with a Cc to [email protected] no later than 13th March 2024 at 11.59pm East African Time (EAT).
BRAC is committed to safeguarding children, young people and adults, and expects all employees and volunteers to share the same commitment. We believe every stakeholder and every member of the communities we work with has the right to be protected from all forms of harm, abuse, neglect, harassment, and exploitation – regardless of age, race, religion, and gender, status as an individual with a disability or ethnic origin. Therefore, our recruitment policy and procedure include extensive background checks and disclosure of criminal records in order to ensure safeguarding to the fullest extent.
BRAC is an equal opportunities employer.
Deadline: 13-Mar-24