Operations Specialist; Advanced Excel & Google Sheets Remote

Position: Operations Specialist (Advanced Excel & Google Sheets) | 5-9 yrs | Remote | 5 pm till 2 am
Data Operations Specialist (Advanced Excel & Google Sheets)

Location:

Remote
Shift Timing:  5:00 PM – 2:00 AM IST (US Overlap)

Experience:

5–9 Years
Communication:  Excellent

Role Overview
We are looking for a highly detail-oriented  Data Operations Specialist  with strong expertise in  Advanced Microsoft Excel and Google Sheets  to support our business operations and data management activities.
This role is ideal for professionals who enjoy working with large datasets, solving data-related challenges, building reports, maintaining data accuracy, and supporting business teams with actionable insights.
While experience with  Airtable  is preferred, the primary focus of this role is on  advanced spreadsheet management, data analysis, reporting, reconciliation, and operational support .
Excellent communication skills are mandatory, as the role involves regular interaction with US-based stakeholders and non-technical business users.

Key Responsibilities
Data Management & Analysis
Manage, organize, and maintain large datasets across Excel, Google Sheets, and Airtable.
Clean, validate, and reconcile operational data from multiple sources.
Identify duplicate, incomplete, or inaccurate records and resolve inconsistencies.
Perform data matching and cross-verification across systems.
Ensure data accuracy, integrity, and consistency at all times.
Advanced Excel & Google Sheets
Create and maintain complex spreadsheets, trackers, and reports.
Utilize advanced formulas and functions including:
VLOOKUP
XLOOKUP
INDEX-MATCH
QUERY
ARRAY FORMULA
IF, SUMIFS, COUNTIFS
TEXT Functions
Nested Functions
Build Pivot Tables, Charts, Dashboards, and Management Reports.
Perform data analysis and generate business insights.
Automate repetitive reporting tasks where possible.
Reporting & Business Support
Prepare daily, weekly, and monthly operational reports.
Generate reports for management and client-facing teams.
Analyze trends and identify data anomalies.
Assist business teams in making data-driven decisions.
Support operational workflows and reporting requirements.
Airtable Support (Preferred)
Manage Airtable views, filters, linked records, forms, and permissions.
Support imports, exports, and data organization activities.
Troubleshoot day-to-day Airtable issues.
Maintain clean and structured Airtable databases.
Stakeholder Communication
Coordinate with US-based teams and business stakeholders.
Understand requirements from non-technical users.
Explain data issues and solutions in a simple and professional manner.
Provide timely updates and resolutions.

Mandatory Skills
Advanced Excel Expertise
Strong hands-on experience with:
Advanced Formulas & Functions
Pivot Tables
Pivot Charts
Dashboards
Conditional Formatting
Data Validation
Lookup Functions
Data Cleaning & Transformation
Large Dataset Management
Reporting & Analytics
Google Sheets Expertise
Advanced formulas and automation techniques
Query Functions
Dynamic Reporting
Collaborative Data Management
Data Analysis and Visualization
Communication Skills
Excellent Written Communication
Excellent Verbal Communication
Ability to communicate with international stakeholders
Strong stakeholder management skills
Preferred Skills
Airtable experience
Airtable views, filters, formulas, and linked records
Airtable automations
Zapier / Make / Power Automate exposure
Google Apps Script
Basic JavaScript knowledge
Experience supporting operations or business teams

Ideal Candidate
We are looking for someone who:
Loves working with data and spreadsheets.
Can quickly identify and resolve data issues.
Has exceptional attention to detail.
Can work independently with minimal supervision.
Is comfortable supporting non-technical users.
Possesses strong analytical and problem-solving abilities.
Communicates confidently with global stakeholders.
Key Success Metrics
Accuracy and quality of business data.
Timely delivery of reports and dashboards.
Reduction in data inconsistencies and duplicates.
Stakeholder satisfaction and responsiveness.
Ability to independently manage operational tasks.
Continuous improvement in reporting and data processes.

Interview Evaluation Areas
Advanced Excel proficiency
Google Sheets expertise
Data cleanup and reconciliation skills
Reporting and dashboard creation
Analytical and problem-solving abilities
Airtable knowledge (preferred)
Communication and stakeholder management
Attention to detail and ownership mindset
Ability to work effectively during US overlap hours