The Role
Build and maintain complex, high-performance Google Sheets and dashboards using advanced formulas; analyze data and support operational workflows to improve team productivity and efficiency in a remote setting.
Summary Generated by Built In
We are looking for a detail-oriented Virtual Assistant & Operations Specialist to join our client's team. You will play a key role in managing and analyzing data, building advanced Google Sheets, and supporting their operational workflows to ensure smooth, efficient processes.
Job Responsibilities:
- Build and maintain complex Google Sheets with interconnected workbooks
- Utilize advanced formulas including ARRAYFORMULA, QUERY, REGEX, IMPORTRANGE, FILTER, VLOOKUP/XLOOKUP for large datasets
- Create dynamic dashboards and reports for easy data visualization
- Optimize spreadsheet performance to handle large volumes of data efficiently
- Assist with operational tasks to support team productivity and workflow management
Requirements
- Proven experience with advanced Google Sheets
- Strong attention to detail and problem-solving skills
- Ability to work independently in a remote environment
- Prior experience as a Virtual Assistant or Operations Support
- Excellent 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.
- Backup connection must be capable of supporting work during a power outage.
- Primary Device:
- Desktop or laptop equipped with at least:
- Intel Core i5 (8th generation or newer), Intel Core i3 (10th generation or newer), AMD Ryzen 5, or an equivalent processor.
- A minimum of 8 GB RAM.
- Backup Device:
- Must meet or exceed the performance of an Intel Core i3 processor.
- Must be functional during power interruptions.
- A functioning webcam.
- A noise-canceling USB headset.
- A quiet, dedicated home office space.
- Peripherals and Workspace: A smartphone for communication and verification purposes.
Benefits
- Join Our Dynamic Team: Experience our fun, inclusive, innovative culture that values your unique contributions and supports your professional growth.
- Embrace the Opportunities: Seize daily chances to learn, innovate, and excel. Make a real impact in your field.
- Limitless Career Growth: Unlock a world of possibilities and resources to propel your career forward.
- Fast-Paced Thrills: Thrive in a high-energy, engaging atmosphere. Embrace challenges and reap stimulating rewards.
- Flexibility, Your Way: Embrace the freedom to work from home or any location of your choice. Create your ideal work environment.
- Work-Life Balance at Its Best: Say goodbye to stressful commutes and hello to quality time with loved ones. Achieve a healthy work-life integration to perform at your best.
Skills Required
- Proven experience with advanced Google Sheets (complex workbooks and interconnected sheets).
- Proficiency with ARRAYFORMULA, QUERY, REGEX, IMPORTRANGE, FILTER, VLOOKUP, XLOOKUP.
- Ability to create dynamic dashboards and optimize spreadsheet performance for large datasets.
- Prior experience as a Virtual Assistant or Operations Support.
- Strong attention to detail and problem-solving skills.
- Excellent English communication skills.
- Ability to work independently in a remote environment and support team workflows.
- Primary internet connection with minimum 15 Mbps.
- Backup internet connection with minimum 10 Mbps, capable during power outage.
- Primary device: Desktop or laptop with Intel Core i5 (8th gen+) or Intel Core i3 (10th gen+), AMD Ryzen 5, or equivalent; minimum 8 GB RAM.
- Backup device meeting or exceeding Intel Core i3 performance and functional during power interruptions.
- Functioning webcam.
- Noise-canceling USB headset.
- Quiet, dedicated home office space.
- Smartphone for communication and verification purposes.
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
CrewBloom is a remote staffing agency founded in 2016 that connects businesses with top-tier global talent. The company specializes in sourcing and recruiting professionals for various roles, including sales, customer support, IT, and administrative functions. With a global footprint spanning 22 countries, CrewBloom aims to help growing companies scale efficiently by providing vetted, high-performance remote staff across diverse industries such as healthcare, SaaS, and e-commerce.
