> Markdown version of [/jobs/ext/4326902-uts-temporary-google-workspace-and-automation-developer](https://www.wearedevelopers.com/jobs/ext/4326902-uts-temporary-google-workspace-and-automation-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # UTS - Temporary Google Workspace and Automation Developer - **Company:** North Carolina State University - **Location:** Raleigh, NC, United States - **Experience:** Expert - **Salary:** $72,800.0 - **Contract:** Temporary contract - **Skills:** Web Interfaces, HTML, JavaScript (Programming Language), Application Programming Interfaces (APIs), Applications Architecture, Cascading Style Sheets (CSS), Cloud Database, Databases, Continuous Integration, Information Engineering, Data Security, Relational Databases, Database Queries, Database Schema, Software Debugging, Programming Tools, MySQL, Performance Tuning, Power BI, Software Engineering, SQL Stored Procedures, SQL Databases, Systems Architecture, Systems Integration, Web Applications, Software Repository, Data Classification, Google Data Studio, Backend, AngularJS, Script Language, Information Technology, Gsuite, Front End Software Development, Webhooks, Software Version Control, Data Pipelines, Servicenow, Web Api - **Published:** October 23, 2026 - **Apply:** https://jobs.ncsu.edu/postings/236604/pre_apply ## About the Role * 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 Department Required Skills * 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 Years Experience, Skills, Training, Education * 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 Valid NC Driver's License required? No Commercial Driver's License Required? No, 2. * Do you have 5+ years of professional software development, automation, or data engineering experience? ## Description 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 Yes If Yes, Appointment Length 4 months Wolfpack Perks and Benefits 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: * Health Insurance for Temporary Employees * Enhance your career with LEAD courses * Attend non-revenue generating sporting events for free. Attain Work-life balance with our Childcare discounts, Wellness & Recreation Membership, and Wellness Programs that aim to build a thriving wolfpack community. 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. Department Information, Work Schedule 40 hours per week, 100% onsite 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., 3. * Have you built custom Google Apps Scripts that process web form entries into Google Sheets, and how have you handled Google's execution time or quota limits in past projects? (Open Ended Question) 4. * Which databases (like MySQL) and BI tools (like Looker Studio or Power BI) have you connected to Google Sheets or web apps, and what kind of SQL queries or data models did you build for them? (Open Ended Question) Applicant Documents