We are looking for a detail-oriented professional to manage our online store data and order systems. You will be responsible for moving information between our retail websites, our internal database (ERP), and Google Sheets.
Main Responsibilities
1. Daily Operations (Order & Product Management):
- Order Entry: Every day, you will move customer orders from our website into our internal system (ERP). You must ensure all information is 100% correct.
- Product Uploading: You will add new products and imagery to our websites, via spreadsheet and import/export.
- Inventory Updates: You will make sure the product details and stock levels are the same on all platforms.
2. Data & Systems (Reporting & Analysis):
- Google Sheets: You will build and manage complex spreadsheets. You must be very good at using formulas like VLOOKUP, XLOOKUP, QUERY, and ARRAYFORMULA.
- System Integration: You will use no-code tools (such as Zapier, Make.com, or Supermetrics) to connect different platforms.
- Advertising Data: You will pull data from advertising channels (like Google Ads or Facebook) and marketplaces into Google Sheets to create reports.
- Data Analysis: You will organize data to help the management team understand how the business is performing.
Required Skills
- Advanced Google Sheets: You must know how to organize large amounts of data and use complex formulas.
- No-Code Tools: Experience using Zapier, Make.com, or similar tools to connect different software programs.
- E-commerce Knowledge: Experience working with online stores and marketplaces.
- Attention to Detail: You must be very careful with data entry. Small mistakes can cause big problems in our ERP.
- English Level: Good reading and writing skills in English.
