Intern- IT Automation & Analytics

Role Overview

We are looking for a technically skilled professional who can build automation workflows, integrate tools using APIs, and streamline business operations using Python, JavaScript, and Google Workspace tools. The ideal candidate will be comfortable working with data, building scripts, and creating efficient systems using Google Sheets and related tools.

Responsibilities

• Develop automation scripts and workflows using Python and JavaScript (Appscript)
• Integrate third-party tools and internal systems using REST APIs
• Build and maintain Google Sheets-based tools, dashboards, and automated workflows and visualize on Looker Studio
• Write basic and intermediate Google Sheets formulas for data transformation and reporting
• Create automated reports and presentations using Google Slides
• Work within Google Workspace to improve operational efficiency
• Manage data imports, exports, and synchronization between different platforms
• Debug, maintain, and optimize existing scripts and automations
• Collaborate with internal teams to understand operational needs and implement solutions

Requirements

• Strong proficiency in Python
• Solid experience with JavaScript
• Advanced knowledge of Google Sheets
• Knowledge of any visualization tool like Looker Studio or PowerBI
• Expertise in Google Sheets formulas (ARRAYFORMULA, QUERY, IMPORTRANGE, etc.)
• Experience working with APIs and data integrations
• Strong understanding of Google Workspace tools (Sheets, Slides, Drive, etc.)
• Ability to manipulate and analyze datasets efficiently

Skills

• Python
• JavaScript
• Google Sheets
• REST APIs
• Looker Studio