Spreadsheet Systems Developer

Job Title

Location

Position Type

Job Description

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