Data Warehouse Intern: ETL, SQL & Analytics (Hybrid)

GTN_IDN PT Global Tiket Network; Indonesia; Hybrid; IDR 16,740,000 - 33,480,000; Full time

Job summary

tiket.com is seeking a final-year student or recent graduate in CS/DS/IS for a BI/DWH Intern role. You will gather metrics, develop ETL pipelines, monitor ETL jobs, write SQL queries, and document data models.

The internship lasts at least 6 months and requires hybrid work with at least two days in the office. Familiarity with ETL, SQL and Data Warehousing is expected; Python is a plus and experience with reporting tools is beneficial.

Qualifications

• Must be a final-year student or recent graduate in CS/DS/IS or related fields.
• Familiar with ETL, SQL and data warehousing.
• Python knowledge is a plus; experience with reporting tools is beneficial.

Responsibilities

• Gather key metrics and data requirements from BI Analysts and stakeholders.
• Develop and optimize ETL pipelines and database tables for reporting.
• Monitor, debug, and troubleshoot ETL jobs to ensure data accuracy.
• Write and improve SQL queries for data extraction and analysis.
• Document ETL workflows and data models for future use.
• Support data modeling enhancements to improve performance and scalability.

Skills

ETL

SQL

Data warehousing

Python

Reporting tools

Education

Final-year student or recent graduate in Computer Science, Data Science, Information Systems, or related fields

Job description

tiket.com is seeking a final-year student or recent graduate in CS/DS/IS for a BI/DWH Intern role. You will gather metrics, develop ETL pipelines, monitor ETL jobs, write SQL queries, and document data models.

The internship lasts at least 6 months and requires hybrid work with at least two days in the office. Familiarity with ETL, SQL and Data Warehousing is expected; Python is a plus and experience with reporting tools is beneficial.