AUTO111: Software Engineer

JerseySTEM is a mission-driven professional network dedicated to improving access to STEM education for underserved middle school girls in New Jersey. They are seeking a volunteer Software Engineer to design and build backend automation modules in Google Apps Script, focusing on creating reliable services and workflows to support operational needs.

Responsibilities:

• Develop and maintain Google Apps Script backend modules to automate internal workflows
• Build integrations using Google Workspace APIs, including (but not limited to):
• Google Sheets API (data processing, reporting, sync)
• Drive API (file operations, folder structure automation)
• Gmail API (notifications, inbound/outbound workflow automation)
• Calendar API (event creation, attendee handling, scheduling logic)
• Admin SDK (user / group management where applicable)
• Implement reusable library-style modules and clean coding patterns in Apps Script
• Design data flow logic and enforce data integrity across Sheets/Drive/other systems
• Write clear documentation and lightweight technical specs for modules and automations
• Collaborate with product/ops stakeholders to translate requirements into technical solutions
• Use GitLab merge requests, code reviews, and branching workflows
• Track work via Jira tickets, participate in sprint planning, and deliver iterative updates
• Troubleshoot production issues, optimize scripts for performance, and prevent quota overruns

Requirements:

• At least 3 years of industry experience in the software industry
• Experience in designing and building backend automation modules in Google Apps Script
• Experience integrating with Google Workspace APIs such as Gmail, Drive, Sheets, Docs, Calendar, and Admin SDK
• Experience in developing and maintaining Google Apps Script backend modules to automate internal workflows
• Experience building integrations using Google Workspace APIs, including Google Sheets API, Drive API, Gmail API, Calendar API, and Admin SDK
• Experience implementing reusable library-style modules and clean coding patterns in Apps Script
• Experience designing data flow logic and enforcing data integrity across Sheets/Drive/other systems
• Experience writing clear documentation and lightweight technical specs for modules and automations
• Experience collaborating with product/ops stakeholders to translate requirements into technical solutions
• Experience using GitLab for version control and CI practices
• Experience tracking work via Jira tickets and participating in sprint planning
• Experience troubleshooting production issues, optimizing scripts for performance, and preventing quota overruns
• Computer Science Major
• Working Knowledge or willingness to learn Google Apps Scripting Language
• Resourceful, can-do attitude
• Comfort working in a ‘virtual organization' with digital tools (Google Workspace, Jira, salesforce)