Job description

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. Familiarity with SQL concepts and data modeling. Weekly Hours 40

Requirements

Must-haves

Spreadsheet Systems Developer
Position Type
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 tools or templates that can be reused across the organization.
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.
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.
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.

Nice-to-haves

Experience integrating Sheets with CRM, ERP, or project management tools.
Background in data analytics, information systems, operations, or related fields.
Familiarity with SQL concepts and data modeling.
Weekly Hours

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

javascriptsql

Platform: workday
Effort: long