Appsheet Developer

Job Title: Appsheet Developer Location: 100% US Remote, but the candidate must be local to San Francisco, CA to align with onshore project needs. 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. 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.