[DATA ENTRY] Consolidation of Employee Spreadsheets
Budget: $750 – $1,500 SGD
Yara manages over 500 employees and 100 contractors worldwide, spread out to different departments, teams, and projects. Each team has their own spreadsheet/s that contains various employee details such as uniqueID, firstName, jobTitle, dept, subDept/project, hrbpName, hiringManagerName, status, country/location, etc.
However, it is difficult to get a holistic view of all the employees, and some of the records also contain outdated and inconsistent information.
The main goal of this project is to consolidate various spreadsheets containing employee information into a single master spreadsheet while citing any inconsistencies and making notes on all the updated items. Another objective is to create a short summary email update for the client's convenience e.g. in Jan 10 people moved projects, 1 person resigned and 2 people are unassigned.
The awarded freelancer will be given access to the different spreadsheets for their reference. They will also have opportunities to meet with each of the 7 department heads over video call to receive their updates and discuss any inconsistencies that are unresolved. Note: some employees are shared within a given department across multiple projects.
The ideal candidate will have:
- Excellent data entry skills
- Proficiency in English
- Great timezone compatibility and availability with Singapore (GMT+8)
- Competitive bid (and hourly rate)
If you are interested, please submit a bid and do not forget to include your QUOTE as well as your HOURLY RATE. Thank you.
However, it is difficult to get a holistic view of all the employees, and some of the records also contain outdated and inconsistent information.
The main goal of this project is to consolidate various spreadsheets containing employee information into a single master spreadsheet while citing any inconsistencies and making notes on all the updated items. Another objective is to create a short summary email update for the client's convenience e.g. in Jan 10 people moved projects, 1 person resigned and 2 people are unassigned.
The awarded freelancer will be given access to the different spreadsheets for their reference. They will also have opportunities to meet with each of the 7 department heads over video call to receive their updates and discuss any inconsistencies that are unresolved. Note: some employees are shared within a given department across multiple projects.
The ideal candidate will have:
- Excellent data entry skills
- Proficiency in English
- Great timezone compatibility and availability with Singapore (GMT+8)
- Competitive bid (and hourly rate)
If you are interested, please submit a bid and do not forget to include your QUOTE as well as your HOURLY RATE. Thank you.