Spreadsheet Systems Developer

SIL, Inc.
United States
11 days ago
Apply on www.careerbuilder.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
3 years minimum
Working hours
Regular working hours

Tech stack

JavaScript (Programming Language) Application Programming Interfaces (APIs) Data Analysis Big Data BigQuery Spreadsheets Information Systems Data Architecture Data Files Relational Databases Excel Formulas Lookup Table
+11 more
Regular Expressions SQL Databases Data Streaming Systems Integration Data Processing Zapier Script Language Data Analytics Build Tools Data Management Gsuite

Job description

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.

Requirements

Spreadsheets, Spreadsheets, Data Sets, Analysis Skills, Relational Databases (RDBMS), Detail Oriented, Data Management, Reporting Dashboards, Structured Data, Data Analysis, 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., 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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerbuilder.com
Prepare application

Good distractions

Loading talks and stories from around this role…