Data Analysis and Automation
Assist with data analysis and automate Account Receivable processes.
Overview
Assist with data analysis and automate Account Receivable processes.
You have:
- Advanced computer skills and proficiency in software such as Word, Excel, Access, Microsoft Power Query, and VBA.
- Strong programming and analytical skills are required.
- Ability to provide and present data in a concise manner.
- A degree in computer science, data analytics, mathematics, statistics, or related fields is considered an asset.
Contract
This is a UNV contract. More about UNV contracts.
On a quarterly basis, the Contributions Unit under DFAM’s Grant Management Unit, conducts an exercise to identify overdue receivables. The purpose of this quarterly exercise is to identify grants which (a) have overdue balances due from the donor and (b)the CO has spent more than the funds already received. These grants present a risk to UNICEF of irrecoverable expenditures.
The objective of the quarterly exercise is therefore to remind Country Offices to follow up on overdue receivables and identify amounts which need to be impaired or written off.
The exercise is predominantly manual and requires a significant level of effort. Given the frequency and the limited resources due to competing priorities, it is important that the process be automated for team efficiency and timely completion of this quarterly exercise. The expected impact/outcome is timely collection of receivables, timely impairment and timely writing off the overdue amounts that are not collectable due to one reason or another.
We are looking for 1 of Online Volunteers who under the guidance of Finance Manager and Budget Officer to support our team with conducting data analysis and automating Account Receivable manual process. The Online Volunteer will be responsible for: - Discuss and consolidate indicators and datasets for the analysis and automation exercise - Develop method and tool for the analysis of the data - Suggest indicators and tabulation plan to conduct analysis of data - Automate the manual process of Account Receivable and provide documentation and training to the Budget officer and Finance Manager.
The Online Volunteer will be provided with overview of the business process and is required to update on the progress during regular calls.
The Online Volunteer will have the opportunity to build connections with the team (UNICEF) and learn about the ways in which this project can be supported
Candidates should have advanced computer skills and proficiency in software (e.g., Word, Excel, Access, Microsoft Power Query, VBA ). Strong programming, analytical and writing skills as well as ability to provide and present data in a concise manner is required. A degree in computer science, data analytics, mathematics, statistics, or other related fields is considered an asset.
Potential interview questions
| Can you describe a time when you automated a manual process? | The interviewer is assessing your experience with automation projects. | Provide a specific example of the process you automated, the tools you used, and the outcome. |
| How do you ensure accuracy in your data analysis? | This question aims to understand your attention to detail. | Pro members can see the explanation. |
| What programming languages are you proficient in and how have you applied them? | Pro members can see the explanation. | Pro members can see the explanation. |
| Describe how you prioritize tasks in a project with competing deadlines. | Pro members can see the explanation. | Pro members can see the explanation. |
| Can you give an example of how you've presented complex data to a non-technical audience? | Pro members can see the explanation. | Pro members can see the explanation. |