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, primarily leveraging Google Apps Script to automate processes across Google Workspace (Sheets, Docs, Forms, Gmail, Drive), constructing clean custom web interfaces using HTML/CSS/JS, and querying, transforming, and managing backend data using SQL. This is a temporary, time-limited appointment of 4 months, based onsite in Raleigh, NC.

Responsibilities

• Workflow Automations and Data Analysis (40%)
  • 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).
  • Write optimized SQL queries, stored procedures, views, and scripts to extract, transform, and integrate data between relational databases and reporting interfaces.
  • Build interactive web applications, custom HTML dialogs, sidebars, and gravity forms using HTML, CSS, and modern JavaScript embedded directly into Google Workspace or hosted as standalone micro-apps.
  • 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.
• Project Coordination and ITSM Improvement (30%)
  • Create and maintain custom ServiceNow Service Portal widgets, catalog items, and record producers using HTML, CSS, JavaScript, and AngularJS.
  • Manage ServiceNow Update Sets, scope permissions, and adhere to ITSM best practices to ensure safe deployment and zero-downtime releases.
  • Maintain clear documentation for application architecture, database schemas, API dependencies, and end-user guides to ensure maintainability.
  • 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 Base Articles (KBAs) in ServiceNow of departmental functions.
• System Maintenance, Security & Technical Leadership (30%)
  • Conduct root-cause analysis, debug runtime errors, and perform periodic security audits on access controls and user permissions across all scripts and automation systems.
  • Author comprehensive technical specs, system architecture diagrams, and end-user documentation; translate complex business requirements into technical execution plans.
  • Maintain code repositories using Git/GitHub, utilizing local development environments (clasp for Apps Script) and standard CI/CD deployment procedures.

Requirements

• Associate degree in computer science, information technology, or field related to the area of assignment.
• 5+ years of professional software development, automation, or data engineering experience.
• Advanced Google Apps Script experience (JavaScript): deep knowledge of trigger configurations (time-driven and event-driven), quota limits, and integrating web apps.
• Strong SQL expertise: deep experience writing complex queries, joins, aggregations, window functions, and database schema design across cloud databases or relational platforms (e.g., MySQL).
• Ability to multitask and manage multiple projects.
• Knowledge of databases, system security, and troubleshooting.
• Advanced knowledge of Google Workspace.
• Analytical mindset and problem-solving aptitude.

Qualifications

• Experience with integrating web-hosted forms with Google Sheets plugins.
• Experience integrating with Business Intelligence tools like Looker Studio and Power BI.
• Background in operational process engineering, workflow optimization, or internal developer tools.

Benefits

• Health insurance for temporary employees.
• Career enhancement through LEAD courses.
• Free attendance at non-revenue generating sporting events.
• Childcare discounts.
• Wellness & Recreation Membership.
• Wellness Programs aimed at building a thriving community.

Pay

Anticipated hiring range: $35.00 per hour.

Schedule

40 hours per week, 100% onsite.