Job Title
Spreadsheet Systems DeveloperLocation
GlobalPosition Type
VolunteerJob 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
40Similar Jobs
What you need to know about the Colorado Tech Scene
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
