UTS - Temporary Google Workspace and Automation Developer at NC State

We are seeking an experienced Software Developer to design, build, and maintain custom internal applications, automated workflows, and data pipelines. In this role, you will bridge business operations, web interfaces, and relational databases. You will primarily leverage Google Apps Script to automate processes across Google Workspace (Sheets, Docs, Forms,
Gmail, Drive), construct clean custom web interfaces using HTML / CSS /JS, and query, transform, and manage backend data using SQL . The ideal candidate thrives on turning operational bottlenecks into streamlined, scalable tools and possesses strong technical problem-solving skills across lightweight enterprise solutions.

Is Time Limited

Is Time Limited Yes

If Yes, Appointment Length 4 months

As a Pack member,
you belong here
, and can enjoy exclusive perks designed to enhance your personal and professional well-being. As you consider this opportunity, we encourage you to review our Employee Value Proposition and learn more about what makes NC State the best place to learn and work for everyone.

• Attend non-revenue generating sporting events for free.

Disclaimer:
Perks and Benefit eligibility is based on Part-Time or Full-Time Employment status. Eligibility and Employer Sponsored Plans can be found within each of the links offered.

Work Schedule 40 hours per week, 100% onsite

• Workspace Automation:
  Design, develop, deploy, and maintain robust Google Apps
  Script solutions to automate multi-step workflows and integrate Google Workspace tools
  (Sheets, Docs, Drive, Forms, Gmail, Calendar, Lucid Charts).
• Database Management & Data Pipelines:
  Write optimized SQL queries, stored
  procedures, views, and scripts to extract, transform, and integrate data between
  relational databases and reporting interfaces.
• Custom Frontend & Web Apps:
  Build interactive web applications, custom HTML
  dialogs, sidebars, and gravity forms using HTML , CSS , and modern Java Script
  embedded directly into Google Workspace or hosted as standalone micro-apps
• API & System Integration:
  Connect third-party APIs, webhooks, and Google Workspace
  APIs (Drive API , Sheets API , Gmail API ) to ensure secure data flow across tools.
• Collaborate with cross-departmental leaders to design and implement secure forms.

• Service Portal & Custom Components:
  Create and maintain custom Service Now Service
  Portal widgets, catalog items, and record producers using HTML , CSS , JavaScript, and
  AngularJS.
• Platform Governance:
  Manage Service Now Update Sets, scope permissions, and
  adhere to ITSM best practices to ensure safe deployment and zero-downtime releases.
• Documentation & Governance:
  Maintain clear documentation for application
  architecture, database schemas, API dependencies, and end-user guides to ensure
  maintainability.
• Performance Optimization:
  Audit existing Apps Script codebases to optimize execution
  time, manage quota limits, batch API requests, and resolve data discrepancies or
  runtime errors.
• Write proficient Knowledge based articles (KBA’s) in Service Now of departmental
  functions

• Monitoring & Troubleshooting:
  Conduct root-cause analysis, debug runtime errors, and
  perform periodic security audits on access controls and user permissions across all
  scripts and automation systems.
• Technical…