Dashboard App scripts Analyst (100 days short term Homebased Retainer)
Collaborate with stakeholders to develop and maintain data integration solutions.
Overview
Collaborate with stakeholders to develop and maintain data integration solutions.
You have:
- Bachelor's degree in Software Engineering and/or Computer Science is required.
- A minimum of two years experience in developing Appscripts within the Google suite environment.
- Advance knowledge of Google spreadsheets.
- Strong understanding of Google Apps SCRIPT and ability to troubleshoot and create new SCRIPTS as required.
- Full working knowledge of English is essential.
- Working knowledge of French, Spanish or another official UNOPS language is an asset.
Contract
This is a IICA-1 contract. This kind of contract is known as International Individual Contractor Agreements. It is normally internationally recruited only. It's an external contract. It usually requires 2 years of experience, depending on education. More about IICA-1 contracts.
Background Information - Job-specific
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.
The incumbent will work under the guidance and supervision of the Advocacy and Communications Manager, and in close collaboration with the Strategic Communications Partner Committee (SCPC) Manager and the Advocacy Officer, to achieve the core objectives and strategic priorities of the Partnership and the Strategic Communications Partner Committee (SCPC):
The purpose of the SCPC is to develop and implement, in collaboration with the Partnership Management Team, communications to achieve the objectives of the Partnership. The objective of the SCPC is to translate the overarching objectives of the Partnership into specific, aligned and inspirational messages that catalyse action.
Functional Responsibilities
The App scripts/Google Sheets developer shall work with the RBM Data Team to integrate, triangulate and clean existing data sources within the Google sheets environment.
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.
Key deliverables
- Links between data sources and visuals developed
- Data cleaning/triangulations workflows developed
Report that includes best practices, challenges and recommendations prepared.
Impact of Results The effective and successful achievement of results by data analysts directly impacts the activities of the Secretariat and the respective Partner Committees, and more broadly the mission of the RBM Partnership.
Education/Experience/Language requirements
Education
- A Bachelor degree, preferably in Software Engineering and/ or Computer Science is required.
- A relevant Master’s degree is an advantage and may be considered in lieu of some or all required years of experience.
Experience Required
A minimum of two years experience in developing Appscripts within the Google suite environment
Advance knowledge of Google spreadsheets
Strong understanding of Google Apps SCRIPTs and ability to troubleshoot and create new SCRIPTS as required
Strong attention to detail, accuracy and communication skills
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
Language - Full working knowledge of English is essential. - Working knowledge of French, Spanish or another official UNOPS language is an asset.
Competencies
Treats all individuals with respect; responds sensitively to differences and encourages others to do the same. Upholds organizational and ethical norms. Maintains high standards of trustworthiness. Role model for diversity and inclusion.
Acts as a positive role model contributing to the team spirit. Collaborates and supports the development of others. For people managers only: Acts as positive leadership role model, motivates, directs and inspires others to succeed, utilizing appropriate leadership styles. Demonstrates understanding of the impact of own role on all partners and always puts the end beneficiary first. Builds and maintains strong external relationships and is a competent partner for others (if relevant to the role). Efficiently establishes an appropriate course of action for self and/or others to accomplish a goal. Actions lead to total task accomplishment through concern for quality in all areas. Sees opportunities and takes the initiative to act on them. Understands that responsible use of resources maximizes our impact on our beneficiaries. Open to change and flexible in a fast paced environment. Effectively adapts own approach to suit changing circumstances or requirements. Reflects on experiences and modifies own behavior. Performance is consistent, even under pressure. Always pursues continuous improvements. Evaluates data and courses of action to reach logical, pragmatic decisions. Takes an unbiased, rational approach with calculated risks. Applies innovation and creativity to problem-solving. Expresses ideas or facts in a clear, concise and open manner. Communication indicates a consideration for the feelings and needs of others. Actively listens and proactively shares knowledge. Handles conflict effectively, by overcoming differences of opinion and finding common ground.
Contract type, level and duration
Contract type: Individual Contractor Agreement (ICA) Contract level: ICS-9 / IICA 1 Contract duration: Maximum 100 days within a 12 month period
For more details about the ICA contractual modality, please follow this link: https://www.unops.org/english/Opportunities/job-opportunities/what-we-offer/Pages/Individual-Contractor-Agreements.aspx
****As per UNOPS policy, in duty stations where the NPO (National Professional Officer) category has been established by the International Civil Service Commission (ICSC), a home-based contract may be issued as a Local ICA Specialist position.****
Additional Information
- 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.
- Qualified women and candidates from groups which are underrepresented in the UNOPS workforce are encouraged to apply. These include in particular candidates from racialized and/or indigenous groups, members of minority 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. 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.
Potential interview questions
| Can you describe a project where you developed a Google Apps Script? | To assess your experience and expertise in using Google Apps Script. | Detail the project's objectives, the specific scripts you developed, and the impact on the project. |
| How do you ensure data accuracy when cleaning data? | Evaluates your attention to detail and methodologies for data cleaning. | Pro members can see the explanation. |
| Explain your process for integrating different data sources. | Pro members can see the explanation. | Pro members can see the explanation. |
| How do you stay updated on advancements in Google Sheets? | Pro members can see the explanation. | Pro members can see the explanation. |
| Can you give an example of a time you documented your work effectively? | Pro members can see the explanation. | Pro members can see the explanation. |