Dashboard App Scripts Analyst at United Nations Office for Project Services (UNOPS)

Job Description

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.
Education

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.
Experience

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)