Operations Assistant

WORK ARRANGEMENT

I. Working Hours
Monday - Friday: 9:00 AM-6:00 PM, PH Time
Saturday: 9:00 AM-1:30 PM, PH Time

II. Salary: $400/month

ABOUT THE ROLE
We are looking for a detail-oriented and proactive Operations Assistant with strong Google Sheets / Excel skills to support day-to-day business operations, including HR processes, manage internal systems, and assist with technical setups.

JOB SCOPE
I. HR & Coordination
1. Create and maintain Google Sheets trackers (e.g. payroll, internal dashboards)
2. Coordinate onboarding of new hires (VAs)
3. Conduct onboarding calls and guide tool setup
4. Track attendance, leaves, and working hours
5. Process payroll data every cutoff
6. Respond to internal HR-related questions

II. Tech & Tool Support
1. Help tea ---------- mbers with tools and technical setups
2. Coordinate system requests across teams

III. General Support
1. Assist Operations Manager with ad hoc operational requests
2. Coordinate with team leads and internal stakeholders

IV. Requirements
1. Strong Google Sheets skills (comfortable with formulas and organizing data)
2. Highly organized and detail-oriented
3. Good written and spoken English
4. Able to handle multiple tasks and priorities
5. Proactive and able to follow through without constant supervision

V. Bonus (Nice to Have)
1. Experience in HR or employee management
2. Familiarity with LLMs (e.g., Claude, ChatGPT, Gemini)
3. Basic technical knowledge (VPS, domains, automation tools)

VI. Requirements (MUST HAVE)
1. Advanced Google Sheets / Excel skills and able to work with complex formulas such as:
ARRAYFORMULA, QUERY, FILTER, VLOOKUP / XLOOKUP, IMPORTRANGE, IFERROR / nested logic, REGEX functions, Date-based calculations
2. Able to debug and improve existing spreadsheet systems
3. Strong logical thinking and problem-solving ability

Technical Requirements
CPU - i5 or better
Memory (RAM) - 16GB (minimum), 32GB or more (ideal)
Internet Speedtest - 50+ Mbps (download) | 20+ Mbps (upload)
Note: Stable electricity and internet connection is required (with a backup plan to ensure uninterrupted work)