Operations Assistant/Google Sheet Analyst

## Requirements

1. Excellent written and oral English.
2. Documentation skill (Writing/maintain Standard Operating Procedure(SOP) manual, Making SOP video, , general organizational skills with emails/tickets)
3. Google Sheet - formulas. Intermediate to advanced Google sheet formula writing/reading skill is required for this position. (You should be well versed in formulas such as Arrayformula, Vlookup, Pivot table, Query, If etc...)
4. Simple image editing skills required (editing, resizing, markup, convert formatting, remove background color etc..)
5. Availability (3 hours/day, 5 days per week), ability to do frequent Whatsapp calls, screenshare on short notice. Quick response to Whatsapp messages is critical to this position.

## Roles & responsibilities

- Document and maintain SOP, including writing procedures, taking screenshot instructional videos, take screenshots
- Creating/follow up on various tickets on the Amazon Seller Central platform to resolve issues, requesting reimbursements;
- Maintain Amazon Seller Central online portal (adjusting price, manage listings etc...)
- Assist in creating new product listings in Amazon (Tex & image prep)

## Pay

Budget: CAD$50 bi-weekly

Screening question:
A vlookup formula is not fetching result, after manually checking you confirm that the search key is present in the target search table/array. What is the possible cause(s) and how would you go about debugging your formula?