About the job
We are seeking a meticulous and skilled Virtual Assistant (Advanced Google Sheets Expert) to become an integral part of our client's team. Your expertise will be vital in managing and analyzing data, crafting sophisticated Google Sheets, and enhancing operational workflows to guarantee seamless and efficient processes.
Key Responsibilities:
- Design and maintain complex Google Sheets with interlinked workbooks.
- Employ advanced formulas, including ARRAYFORMULA, QUERY, REGEX, IMPORTRANGE, FILTER, VLOOKUP/XLOOKUP, to handle large datasets.
- Develop dynamic dashboards and reports for enhanced data visualization.
- Optimize spreadsheet performance to effectively manage substantial volumes of data.
- Support operational tasks to boost team productivity and workflow management.
Qualifications:
- Demonstrated experience with advanced Google Sheets.
- Exceptional attention to detail and problem-solving abilities.
- Ability to work autonomously in a remote setting.
- Previous experience as a Virtual Assistant or Operations Support.
- Outstanding communication skills in English.
Minimum Technical and Work Environment Requirements:
- Internet Connection:
- Primary internet connection with a minimum speed of 15 Mbps.
- Backup internet connection with at least 10 Mbps, capable of supporting work during power outages.
- Primary Device:
- Desktop or laptop with:
- Intel Core i5 (8th generation or newer), Intel Core i3 (10th generation or newer), AMD Ryzen 5, or equivalent processor.
- A minimum of 8 GB RAM.
- Backup Device:
- Must meet or exceed the performance of an Intel Core i3 processor and be operational during power outages.
- A working webcam.
- A noise-canceling USB headset.
- A quiet and dedicated home office space.
- Peripherals and Workspace: A smartphone for communication and verification purposes.
