About the role
The incumbent will assist in automating impact systems. This will entail digitally collecting impact data from supported businesses, online submission to the Airtable database system, and data visualization through PowerBI. To support this process, the role will design well-structured database tables and migrate all the historical impact data from SharePoint to the Airtable database. In addition, the role will conduct data entry of key impact metric data from half-year progress reports into the online tracker on Airtable (Jan – June 2024).
Key Responsibilities
- Design a well-structured database table about AECF key impact metrics.
- Download historical impact data from SharePoint and reorganize it into already developed database tables created for each metrics category.
- Upload these tables into the Airtable database with guidance from the impact team.
- Conduct data entry for half-year reporting (Jan – June 2024) into the Airtable database for analysis and reporting.
- Ensure timely follow-up of all missing data and seek clarification from impact and program team members.
Qualifications:
- Possess a bachelor’s degree or diploma in Information Technology (IT), Computer Science, Social Sciences, or a related field.
- Preferably have experience in designing databases.
- Have less than one year post undergrad completion.
- Have an excellent command of English (both written and spoken).
- Be proficient in MS Office Suite, MS Excel, MS Access, and MS Word.
- Have the ability to work in a fast-paced, self-directed environment under deadline pressures.
- Have the ability to manage own workload independently, multi-task, and prioritize effectively.
- Be keen on details and proactive.
- Have the ability to work effectively in a multicultural environment.
