Data Analyst/Data Engineer Intern

Role Overview

We are looking for a Data Analyst / Data Engineer Intern to work closely with the Product & Technology team on building and maintaining data pipelines, internal dashboards, reporting systems, and data-driven workflows. This is a hands-on role suited for someone who is technically strong, comfortable working with databases and data pipelines, and interested in understanding how data is used to build operational products.

Responsibilities

• Build, maintain, and troubleshoot data pipelines across sources such as AWS RDS, Amazon Redshift, application databases, APIs, Google Sheets, and other internal systems.
• Write and optimize SQL queries for data extraction, transformation, reconciliation, and reporting.
• Develop Python scripts for ETL/ELT workflows, data transformation, validation, and automation.
• Manage and monitor scheduled cron jobs and recurring data workflows.
• Develop and maintain dashboards, reports, DocTypes, forms, workflows, and views in Frappe Framework / ERPNext.
• Support basic frontend customisation using JavaScript, HTML, and CSS.
• Use tools such as Postman for API testing and debugging.
• Use AI tools such as ChatGPT or Claude for coding assistance and data analysis.

Requirements

• Strong knowledge of SQL, including joins, aggregations, CTEs, and subqueries.
• Good working knowledge of Python for data processing and automation.
• Understanding of relational databases and data modelling.
• Experience working with ETL/ELT pipelines and scheduled data jobs.
• Strong proficiency in Microsoft Excel / Google Sheets.
• Understanding of REST APIs, JSON, and Postman.
• Experience with Frappe Framework / ERPNext is a plus.
• Exposure to AWS RDS, Amazon Redshift, PostgreSQL, or MySQL is a plus.

Skills

• SQL
• Python
• Frappe Framework
• AWS
• JavaScript