Dashboard Programmer - Consultancy at BRAC

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.