1) Data Consolidation and Sorting:
• Gather donor data from various sources for the past five years.
• Consolidate and organize the data into a central spreadsheet.
• Sort data based on pre-defined criteria (e.g name, NRIC, address, donation date, amount, donation type etc)
2) Data Cleaning:
• Identify and remove duplicates, typos, and inconsistencies within the dataset.
• Standardize data formats (e.g., date format, name format).
• Ensure data accuracy and completeness through meticulous review.
3) Data Entry:
• Enter clean and validated donor data into a designated spreadsheet.
• Maintain data integrity through accurate data entry practices.
4) Documentation:
• Maintain clear documentation of the data cleaning process, including identified and addressed issues.
Job Requirements
• Strong proficiency in Microsoft Excel, including data manipulation and cleaning techniques.
• Excellent attention to detail and meticulous approach to data handling.
• Ability to work independently and manage multiple tasks efficiently.
• Excellent organizational skills and ability to prioritize tasks.
