Data Engineer Intern: Mentored, Hands-On Data Pipelines

Job opportunity for Data Engineer Intern at Insignia in KOTA ADM. JAKARTA BARAT, DKI JAKARTA, Indonesia.

Location:

Meruya, West Jakarta

Employment Type:

Internship (6 Months)

are looking for a motivated Data Engineer Intern to join our data team. In this role, you will assist in building, maintaining, and optimizing data pipelines, writing efficient SQL queries, and supporting data processing initiatives. This internship is a great opportunity for students or fresh graduates who want to gain hands‑on experience in data engineering.

• Develop and optimize SQL queries for data extraction and transformation.
• Assist in building data pipelines and ETL/ELT processes.
• Work with relational databases to manage and analyze data.
• Create and maintain database objects using SQL best practices.
• Collaborate with the data and analytics team on various projects.
• Support data validation, monitoring, and documentation.

• Minimum programming proficiency in SQL.
• Familiar with Python for data processing.
• Understanding of SQL concepts such as:
  • Common Table Expressions (CTE)
  • Window Functions
  • Create Table As Select (CTAS)
• Experience using at least one relational database:
  • MySQL
  • PostgreSQL
  • MariaDB
• Have completed or currently in the Final Thesis stage, or have previous internship/work experience.
• Have completed at least one academic or personal project related to data, databases, or software development.
• Nice to have:
  • Basic understanding of ETL/ELT concepts.
  • Experience using Git.
  • Familiarity with data visualization or BI tools.
  • Organizational or leadership experience (student organizations, committees, etc.).
  • Strong analytical thinking and willingness to learn.

• Hands‑on experience with real‑world data engineering projects.
• Mentorship from experienced Data Engineers.
• Opportunity to work with modern data technologies and best practices.
• Collaborative and supportive working environment.