Dashboard App scripts Analyst

RBM Partnership to End Malaria

The past fifteen years have seen tremendous gains in reducing the burden of disease and progressing towards malaria elimination. Since 2000, global malaria deaths have been cut by more than half, saving 7 million lives, primarily among children less than five years of age. Expansions in financing, strong political commitments, novel diagnostic and preventative measures, and multi-sectoral coordination have facilitated this progress. Since 1998, RBM Partnership to End Malaria has been central to the global fight against malaria. It has been essential to mobilizing resources and scaling up innovative interventions, putting the world onto a path towards eliminating malaria. The Partnership comprises more than 500 partners committed to end malaria, including malaria endemic countries, their bilateral and multilateral development partners, the private sector, nongovernmental and community-based organizations, foundations, and research and academic institutions.

The RBM Partnership's Vision is of a world free from the burden of malaria. The RBM Partnership is based in Geneva and hosted by UNOPS.

As part of its efforts to enhance data sharing and use for action, the RBM Partnership launched a Global Malaria Dashboard, in 2020, to aggregate available data to improve sharing and interoperability and trigger timely action to progress and challenges. The Global Malaria Dashboard aims to pool available data across a wide range of sources to guide policy and management decisions, as well as partner coordination to deliver targeted support to overcome bottlenecks.

The RBM Global Malaria Dashboard consists of a number of dashboards capturing Malaria Epidemiology data, data on Campaigns (ITN/IRS/SMC), Supply Chain , Malaria Commodities and Technical Assistance  from a variety of sources including partners such as GF, WHO, CHAI, ALMA and individual countries. Currently, the data is stored within Zenysis databasing system. The purpose of this position is to complete the transition of the existing data sources into Google spreadsheets, the integration of new data sources and the automation of data cleaning and triangulation processes using App scripts.

The Dashboard App scripts Analyst shall work with the RBM Data Team to integrate, triangulate and clean existing data sources within the Google sheets environment. In addition, the role will support the Data Manager in data analysis and dashboards development.

The specific tasks include (but are not limited to) the following:

• Collaborate with multiple internal and external stakeholders to discuss the specifics of the data sources and understand the design, and functionality of the dashboard website to support its data interface

• Contribute to the development of AppScripts workflow for data standardization, cleaning and triangulation. Develop and maintain RESTful JSON apis (FastAPI) and consume RESTful APIs

• Maintain up-to-date knowledge of Google sheets trends and advancements

• Develop standard code that can serve as the foundation of future projects

• Perform tasks accurately to meet our brand guidelines and quality standards

• Optimise systems to improve performance and efficiency

• Author technical documentation

• Participate in the selection and design of the visualizations and basic interactions in the platform (drill in, hover, click, etc)

• Connect the different data sources (spreadsheets, API, etc) to the visualizations

• Contribute to the development of AppScripts workflow for data standardization, cleaning and triangulation. Develop and maintain RESTful JSON apis (FastAPI) and consume RESTful APIs

• Lead in Investigating and/or support in developing  and recommending appropriate tools and libraries for the different visuals integrated in the Dashboard.

• Document created workflows and code and prepare the  overall report of the best practices, challenges and recommendations.

• Develop ad-hoc analysis (including using AI/machine learning tools) 

Key deliverables

• Links between data sources and visuals developed

• Data cleaning/triangulations workflows developed

• Report that includes best practices, challenges and recommendations prepared.

• A Master's degree, preferably in Mathematics, Engineering or Computer Science is required. A Bachelor's degree in a relevant field with 2 additional years of experience may be considered in lieu.

Required:

• A minimum of two years experience in developing Appscripts within the Google suite environment and developing Python code.

• Advance knowledge of Google spreadsheets

• Strong understanding of Google Apps SCRIPTs and ability to troubleshoot and create new SCRIPTS as required

• Good knowledge of the Google suite, such as Google Docs, Google Sheets and Google Slides (and their non-cloud equivalents)

Desirable:   

• Demonstrated experience working on data cleaning/triangulation

• Experience with writing clean, efficient, and maintainable code

• Demonstrated experience in designing/developing dashboards

• Familiar with AI and machine learning methods

• Good understanding of malaria key indicators and supply chain terminology

• Full working knowledge of English is essential.

• Working knowledge of French, Spanish or another official UNOPS language is an asset.

• Please note that UNOPS does not accept unsolicited resumes.

• Applications received after the closing date will not be considered.

• Please note that only shortlisted candidates will be contacted and advance to the next stage of the selection process, which involves various assessments.

• UNOPS embraces diversity and is committed to equal employment opportunity. Our workforce consists of many diverse nationalities, cultures,  languages, races, gender identities, sexual orientations, and abilities. UNOPS seeks to sustain and strengthen this diversity to ensure equal opportunities as well as an inclusive working environment for its entire workforce. 

• UNOPS evaluates all applications based on the skills, qualifications and experience requirements outlined in the vacancy announcement. We are committed to considering all candidates in a fair and transparent manner, and we value diverse perspectives and experiences, including those of women, indigenous and racialized communities, individuals with diverse gender identities and sexual orientations, and people with disabilities.



• We would like to ensure all candidates perform at their best during the assessment process.  If you are shortlisted and require additional assistance to complete any assessment, including reasonable accommodation, please inform our human resources team when you receive an invitation.

Terms and Conditions 

• For staff positions only, UNOPS reserves the right to appoint a candidate at a lower level than the advertised level of the post. 

• For retainer contracts, you must complete a few mandatory courses ( they take around 4 hours to complete)  in your own time, before providing services to UNOPS. Refreshers or new mandatory courses may be required during your contract. Please note that you will not receive any compensation for taking courses and refreshers. For more information on a retainer contract here.

• All UNOPS personnel are responsible for performing their duties in accordance with the UN Charter and UNOPS Policies and Instructions, as well as other relevant accountability frameworks. In addition, all personnel must demonstrate an understanding of the Sustainable Development Goals (SDGs) in a manner consistent with UN core values and the UN Common Agenda.

• It is the policy of UNOPS to conduct background checks on all potential personnel. Recruitment in UNOPS is contingent on the results of such checks.