Summary
We are looking for a dedicated Data Entry and Parser proficient in Google Sheets. This role mainly comprises of data entry/parsing from PDF documents containing payroll information into Google Sheets, then analyzing this data using Google Sheets functions to make sure that the data is parsed correctly and no information is missing. The ideal candidate will have a solid understanding of data analysis principles, a meticulous eye for detail, and highly advanced Excel/Google Sheets skills.
This is a full-time role as you’ll be working between 10 am to 6 pm Eastern Time on weekdays.
Key Responsibilities
Accurately input data from provided PDF documents or Excel documents into Google Sheets spreadsheets, adhering to specified formats and templates. This information consists of employee names and paycheck dates, and payroll info.
Utilize Google Sheets text functions (=sum…) to parse payroll period data into quarters.
Use Google Sheets data validation to parse all input data so that data can be sorted based on employee names and paycheck dates and create pivot tables.
Analyze all data by comparing monthly and quarterly payroll info to known yearly payroll, figure out what data (if any) is missing from provided documents.
Clearly verbally communicate your findings to the Operations Manager to request additional documents for necessary payroll periods.
Reanalyze data to ensure completeness.
Qualifications
Minimum of 2 years of experience in data entry and analysis at a known, verifiable company.
Expertise in Microsoft Excel OR Google sheets, including formulas, pivot tables, text functions, and data validation.
Extremely strong attention to detail, especially in data entry and data validation tasks.
Excellent communication skills in English, both written and verbal.
Ability to work 10 am to 6 pm Eastern Time (New York time), minus a 1 hour lunch.
Reliable and strong internet connections during working hours.
Interview Process
1: Share resume and have initial call with Job Poster.
2: Have group call with Job Poster’s company and other candidates to prep for case study.
3: Case study (compensated) with other candidates. Best performing candidate gets hired.
APPLY FOR THIS JOB:
Company: Dental Clinic
Name: Nicole Chikunov
Email: