Appsheet Developer

100% US Remote but candidate must be local to San Francisco CA to align with onshore project needs.
Business Driver: Supplement the core team to maintain and optimize 12 business-critical AppSheet tools used across the global REWS organization.
Deliverables: Deliver robust application features complex data mappings and executive-level analytics reporting.
Interview Process: Fast-tracked 2-round technical panel focusing on live logic queries or complex AppSheet architecture discussion.

TOP HARD SKILLS
Google AppSheet: 4 6 years of experience (Advanced expressions OCR bots)
Advanced SQL (BigQuery/Cloud SQL): 4 years of experience (Window functions stored procedures)
Google Apps Script: 4 years of experience (Custom automation development)

NICE-TO-HAVES
Looker Studio & PLX/Plx Dashboards
BQ/PLX Scripting
Telecom Media or Technology (CM&T) Industry vertical experience

DISQUALIFIERS
Less than 4 years of dedicated Google AppSheet development experience.
Inability to support PST core collaboration hours or not local to the San Francisco market area.
Lack of experience building complex relational databases using Cloud SQL or BigQuery.

Position Overview

The CM&T team is seeking a Level 9 Enterprise Technology Architect specializing as an Appsheet Developer. The mission of this role is to support the onshore lead developer and offshore development team in maintaining and enhancing an existing suite of approximately 12 AppSheets. This suite is leveraged critical to conducting global reporting across the REWS organization.

Day-To-Day Responsibilities

• Design and deploy complex AppSheet applications using advanced expressions slices and automation bots.
• Architect scalable data models leveraging BigQuery and Cloud SQL ensuring proper ingestion/validation of structured and unstructured data.
• Build intuitive dashboards and user interfaces via Looker Studio or AppSheet for global REWS reporting.
• Write advanced SQL (joins window functions stored procedures) for ad-hoc analysis and leadership insights.
• Leverage Google Apps Script for custom integrations across the Google Workspace ecosystem.
• Collaborate closely with 1 onshore lead developer and 2 offshore AppSheet developers to optimize the existing application suite.

Top 3 Required Skills

• Google AppSheet Expert: 4 years (Complex expressions bots OCR dynamic views)
• BigQuery & Cloud SQL: 4 years (Advanced SQL joins window functions stored procedures)
• Google Apps Script: 4 years (Custom integrations and automation workflows)

Additional Desired Skills

• Looker Studio (for interactive reporting)
• Looker / Plx Dashboards
• BQ / PLX scripting and database architecture
• Core Application Managed Services consulting experience

Ideal Candidate Profile

The ideal candidate is an expert-level AppSheet Developer (Level 9 equivalent) with a strong foundation in modern data architecture and cloud databases. They possess a collaborative mindset tailored for cross-shore alignment combined with the technical autonomy required to drive complex enterprise automations. The tone should be consultative technical and analytical.

Job Responsibilities

• Design build and deploy advanced AppSheet applications utilizing complex expressions slices and automation bots.
• Architect scalable data models using BigQuery and Cloud SQL to manage structured and unstructured data streams.
• Build interactive reporting dashboards and interfaces via Looker Studio and AppSheet for executive stakeholders.
• Develop custom workspace integrations using Google Apps Script and write advanced SQL scripts for ad-hoc business analysis.