Google Workspace Developer

Summary

TTC, Inc. is seeking a Google Workspace Developer to lead the migration and operational transformation from legacy Microsoft environments to Google Workspace solutions. The role focuses on reverse-engineering legacy workflows, developing Google Workspace applications, migrating data repositories, modernizing reporting, and maintaining workflow continuity and security across teams.

Responsibilities

• Re-architect legacy SharePoint sites, document libraries, and Microsoft Power Platform tools into scalable Google Workspace equivalents, including AppSheet, Google Sites, Shared Drives, and Apps Script
• Translate and rebuild complex Power Automate multi-stage approvals, automated triggers, and integrations using Google Apps Script, AppSheet automations, and Workspace webhooks
• Migrate low-code Microsoft Power Apps into responsive, robust Google AppSheet applications featuring role-based access control and relational data schemas
• Transition and optimize complex Excel/Access models and SharePoint Lists into Google Sheets and BigQuery backends utilizing advanced formulas (QUERY, FILTER, ARRAYFORMULA, LAMBDA), Apps Script triggers, and Connected Sheets
• Replicate and modernize Power BI reports and dashboards within Google Looker Studio, establishing direct data connections to Sheets, BigQuery, and third-party APIs
• Design and implement granular access controls and permissions across Google Shared Drives, Sites, and Apps to match or exceed existing security and governance policies
• Create comprehensive technical documentation and user-enablement materials to support organizational change management

Skills

• Candidates must be clearable for a Public Trust Position - must be a US Citizen or Permanent Resident or authorized to work in the US and have lived in the US for more than 3 years
• * Bachelor's Degree in Computer Science, Information Technology, or equivalent with at least 3+ years of relevant experience
• * Deep hands-on experience in administration, configuration, and solution development within the Google Workspace Enterprise ecosystem
• * Advanced development proficiency in Google Apps Script (JavaScript), HTML/CSS for Workspace extensions, and RESTful API integrations with Google Workspace APIs
• * Proven track record building enterprise-grade AppSheet solutions from complex relational datasets with custom UX views, workflow triggers, and security filters
• * Demonstrated mastery in Google Sheets data modeling, performance tuning for large datasets, and enterprise dashboard creation in Google Looker Studio
• * Direct technical experience analyzing, auditing, and decomposing Microsoft SharePoint architectures, Power Automate flows, and Power Apps logic
• * Strong understanding of Google Workspace security architecture, including Shared Drive permission hierarchies, Data Loss Prevention (DLP), and OAuth app controls
• * Ability to gain and maintain a federal Public Trust clearance (U.S. Citizen or Permanent Resident who has resided in the U.S. for the past 3 consecutive years)
• * Must be able to remain in a stationary position up to 50% of the time
• * Must be able to operate a computer and other office productivity machinery directly related to position
• * Must be able to exchange information effectively with leadership, FRA stakeholders, development teams, and project managers. Active listening skills during meetings and presentations
• * Requires the ability to perform tasks involving near vision, including reading detailed reports, analyzing digital content, and reviewing technical documentation
• * Google Cloud Certified Professional Google Workspace Administrator or Professional Cloud Developer
• * Familiarity with Google Cloud Platform (GCP) services, including Cloud Functions, Cloud Run, BigQuery, and Cloud IAM
• * Direct prior experience executing an end-to-end organizational migration from Microsoft 365 / Power Platform to Google Workspace

Qualifications

Must Haves

• Candidates must be clearable for a Public Trust Position - must be a US Citizen or Permanent Resident or authorized to work in the US and have lived in the US for more than 3 years
• * Bachelor's Degree in Computer Science, Information Technology, or equivalent with at least 3+ years of relevant experience
• * Deep hands-on experience in administration, configuration, and solution development within the Google Workspace Enterprise ecosystem
• * Advanced development proficiency in Google Apps Script (JavaScript), HTML/CSS for Workspace extensions, and RESTful API integrations with Google Workspace APIs
• * Proven track record building enterprise-grade AppSheet solutions from complex relational datasets with custom UX views, workflow triggers, and security filters
• * Demonstrated mastery in Google Sheets data modeling, performance tuning for large datasets, and enterprise dashboard creation in Google Looker Studio
• * Direct technical experience analyzing, auditing, and decomposing Microsoft SharePoint architectures, Power Automate flows, and Power Apps logic
• * Strong understanding of Google Workspace security architecture, including Shared Drive permission hierarchies, Data Loss Prevention (DLP), and OAuth app controls
• * Ability to gain and maintain a federal Public Trust clearance (U.S. Citizen or Permanent Resident who has resided in the U.S. for the past 3 consecutive years)
• * Must be able to remain in a stationary position up to 50% of the time
• * Must be able to operate a computer and other office productivity machinery directly related to position
• * Must be able to exchange information effectively with leadership, FRA stakeholders, development teams, and project managers. Active listening skills during meetings and presentations
• * Requires the ability to perform tasks involving near vision, including reading detailed reports, analyzing digital content, and reviewing technical documentation

Nice to Haves

• * Google Cloud Certified Professional Google Workspace Administrator or Professional Cloud Developer
• * Familiarity with Google Cloud Platform (GCP) services, including Cloud Functions, Cloud Run, BigQuery, and Cloud IAM
• * Direct prior experience executing an end-to-end organizational migration from Microsoft 365 / Power Platform to Google Workspace