Relief International
SCOPE AND NATURE OF THE SERVICES:
The Data Scientist for Data restructure will provide a back-end restructuring of existing data, to allow health teams to preserve current data entry practices, and allow RI global staff to create aggregated data visuals needed for tracking and analysis.
Deliverables:
- Develop a back-end automation process to restructure quarterly data entry and combine these data from several Excel files into one useable data set. The freelancer is welcome to propose their own solutions for this. Possible solutions include writing Excel VBA macros and/or using Power Query and/or Python.
- The result should be a long-form, tidy dataset that can be updated with new data entry on a quarterly basis (through the back-end automated process) in a structure conducive to data analysis and visualization (i.e. in PowerBI).
- Develop and provide clear, user-friendly instructions for using the macro / code or other solution.
- Level of effort should require 1-2 days of work
Technical Experience and Skills required for the role
- Expert Excel skills
- Proven data automation experience with Excel VBA Macros and/or Power Query and/or Python
- Ability to effectively convey data processes to non-data professionals
- Data visualization experience (especially Power BI) preferred
How to apply
To apply for this post, follow the link and click on the “Apply” button in the job advert page:
https://phg.tbe.taleo.net/phg01/ats/careers/v2/viewRequisition?org=RI&cws=44&rid=1849
- You will be asked to upload a CV and your proposal (timeframe and activities plan) to completing the consultancy.
- Your proposal should be no more than 2 pages long and explain and how your skills and experience make you a good fit.
- This position will require a demonstrated ability to achieve the results described above. In the application, please provide specific examples of similar tasks completed for past projects
Closing date. Note the closing date as per the website listing, however, please apply immediately as we will be reviewing submissions on a rolling basis and may withdraw the positing before the closing date.
COVID 19: To ensure a safe workplace, RI follows government requirements, and in some locations a mandatory vaccination policy applies. When working or traveling on RI business, all staff, contractors and visitors must follow the rules and entry requirements of the country.
If this role is US based there is a mandatory policy for COVID 19 vaccination.
Due to limited resources, only those short-listed will be contacted
Relief International has a zero-tolerance policy for unlawful harassment, sexual exploitation and abuse. Relief International is committed to protecting our staff and the communities we work with from abuse and harm including sexual exploitation, sexual abuse and sexual harassment.
All staff are expected to abide by our Code of Conduct.
Recruitment to all roles in Relief International include a criminal records self-declaration, references and other pre-employment checks, which may include police and qualifications checks.