UTS - Temporary Google Workspace and Automation Developer at NC State

Join the Pack! A community with nearly 8,000 faculty and staff, and 30,000 students. NC State is one of the largest employers in North Carolina, offering a large range of career opportunities. Visit us at https://jobs.hr.ncsu.edu/.

Department: 480501 - UHR Temporary Services

Location: Raleigh, NC

Essential Job Duties:

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.

Other Work/Responsibilities:

Workflow Automations and Data Analysis (40%)

• 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 JavaScript

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.

Project Coordination and ITSM Improvement (30%)

• Service Portal & Custom Components: Create and maintain custom ServiceNow Service

Portal widgets, catalog items, and record producers using HTML , CSS , JavaScript, and

AngularJS.

• Platform Governance: Manage ServiceNow 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 ServiceNow of departmental

functions

System Maintenance, Security & Technical Leadership (30%)

• 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 Documentation & Strategy: Author comprehensive technical specs, system

architecture diagrams, and end-user documentation; translate complex business

requirements into technical execution plans.

• Code Maintenance & Version Control: Maintain code repositories using Git/GitHub,

utilizing local development environments (clasp for Apps Script) and standard CI/CD deployment procedures.

Required Qualifications:

• 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 App Script Expertise: Deep experience writing complex queries, joins,

aggregations, window functions, and database schema design across cloud databases

or relational platforms (e.g., MySQL).

• 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.

Preferred 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.

Required license or certification:

n/a

Position Number: 48LS005

AA/EEO Statement:

NC State University is an equal opportunity employer. All qualified applicants will receive equal opportunities for employment without regard to age, color, disability, gender identity, genetic information, national origin, race, religion, sex (including pregnancy), sexual orientation, and veteran status. The University encourages all qualified applicants, including protected veterans and individuals with disabilities, to apply. Individuals with disabilities requiring disability-related accommodations in the application and interview process are welcome to contact 919-513-0574 to speak with a representative of the Office of Equal Opportunity.

If you have general questions about the application process, you may contact Human Resources at (919) 515-2135 or [email protected].

Final candidates are subject to criminal & sex offender background checks. Some vacancies also require credit or motor vehicle checks. Degree(s) must be obtained prior to start date in order to meet qualifications and receive credit.

NC State University participates in E-Verify. Federal law requires all employers to verify the identity and employment eligibility of all persons hired to work in the United States.