Three or more years of professional experience using Google Sheets at an advanced level.
Expertise with QUERY, IMPORTRANGE, ARRAYFORMULA, VLOOKUP/XLOOKUP, FILTER, REGEX, and other complex formulas.
Demonstrated ability to use Google Sheets to simulate relational database behavior.
Strong analytical and problem-solving skills.
Proficiency in Google Apps Script or JavaScript.
Excellent attention to detail and documentation practices.
Responsibilities
Design and maintain interconnected Google Sheets systems that mimic relational database structures.
Normalize and organize datasets across multiple sheets and tabs for consistency and scalability.
Create dynamic dashboards, lookup tables, and structured data flows.
Develop formulas, array formulas, queries, and nested functions to manipulate and analyze data.
Use Apps Script to automate data processing, integrations, and scheduled tasks.
Build reusable tools or templates for organization-wide use.
Collaborate with teams to understand their data needs and translate them into reliable, user-friendly tools.
Troubleshoot spreadsheet performance issues and provide scalable solutions.
Train or support colleagues in best practices for managing and using complex Google Sheets systems.
Integrate Google Sheets with Google Workspace tools such as Forms, Docs, and Drive.
Use APIs or third-party tools such as Zapier, Make, and BigQuery to connect Google Sheets to external data sources or systems.
Desired Qualifications
Experience integrating Google Sheets with customer relationship management, enterprise resource planning, or project management tools.
Background in data analytics, information systems, operations, or related fields.
Familiarity with Structured Query Language concepts and data modeling.
Job Title
Spreadsheet Systems Developer
Location
Global
Position Type
Volunteer
Job Description
We are seeking a highly skilled and detail-oriented Google Sheets Specialist to join our team full-time. The ideal candidate is an expert in Google Sheets, with deep experience using it to manage, analyze, and connect complex datasets — effectively using it as a relational database. This role will support data-driven decision-making across departments, build smart data systems, and automate workflows for operational efficiency.
Key Responsibilities
Data Architecture & Management:
Design and maintain interconnected Google Sheets systems that mimic relational database structures.
Normalize and organize datasets across multiple sheets and tabs for consistency and scalability.
Create dynamic dashboards, lookup tables, and structured data flows.
Advanced Sheets Development:
Develop formulas, array formulas, queries, and nested functions to manipulate and analyze data.
Use Apps Script to automate data processing, integrations, and scheduled tasks.
Build tools or templates that can be reused across the organization.
Process Improvement & Support:
Collaborate with teams to understand their data needs and translate them into reliable, user-friendly tools.
Troubleshoot spreadsheet performance issues and offer scalable solutions.
Train or support colleagues in best practices for managing and using complex Sheets systems.
Integrations & Automation:
Integrate Google Sheets with other Google Workspace tools (Forms, Docs, Drive, etc.).
Use APIs or third-party tools (e.g., Zapier, Make, BigQuery) to connect Sheets to external data sources or systems.
Qualifications
Required:
3+ years of professional experience using Google Sheets at an advanced level.
Expertise with QUERY, IMPORTRANGE, ARRAYFORMULA, VLOOKUP/XLOOKUP, FILTER, REGEX, and other complex formulas.
Demonstrated ability to use Google Sheets to simulate relational database behavior.
Strong analytical and problem-solving skills.
Proficiency in Google Apps Script or JavaScript.
Excellent attention to detail and documentation practices.
Preferred:
Experience integrating Sheets with CRM, ERP, or project management tools.
Background in data analytics, information systems, operations, or related fields.