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.

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.

What we offer:

Attain Work-life balance with our Childcare discounts, Wellness & Recreation Membership, and Wellness Programs that aim to build a thriving wolfpack community.

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.

* Ability to multitask and manage multiple projects
* Knowledge of databases, system security and troubleshooting
* Advanced knowledge of Google workspace
* Analytical mindset
* Problem-solving aptitude
* 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 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.

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

n/a

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 workatncstate@ncsu.edu.

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.