Data Warehouse Intern

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

We think you also hate when travel app is giving you a headache, right? A slight misinformation can ruin the trip. That is exactly what we are tackling as t-fam! Making sure that our 50+ million users have the best experience in crafting their own adventure.

Your main duties in flying with us:

• Gather key metrics and data requirements from BI Analysts and other stakeholders
• Develop and optimize ETL pipelines and database tables to support 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

Mandatory belongings that you must prepare:

• Final-year student or recent graduate in Computer Science, Data Science, Information Systems, or related fields
• Willing to do internship for at least 6 months and starting soon
• Willing to join hybrid working arrangement, at least two days working in office
• Have experience as a DWH Developer/Business Intelligence/Data Analyst Intern is good to have
• Familiar with ETL, SQL and Data Warehousing
• Familiar with reporting tools and Python is a value-added

In the event that you haven’t received any updates after 3 weeks, your data will be kept and we may contact you for another career destination. Meanwhile, discover more about tiket.com on Instagram, LinkedIn, or YouTube.

tiket.com is the pioneer of online travel agent (OTA) in Indonesia established in 2011. tiket.com is one of the largest and most comprehensive online travel companies in Indonesia, offering a full spectrum of travel products and services core to the travel experience, ranging from flights, ground transport, accommodations, attractions, activities, event ticketing, and travel essentials.

tiket.com’s mission is to accommodate the best access for online travel booking through web and mobile applications.

In 2017, tiket.com became an affiliated company of Blibli and by 2021 became a consolidating subsidiary of Blibli. Blibli has a unified omnichannel ecosystem known as Blibli Tiket, consisting of its subsidiary entities, tiket.com, and Ranch Market. This is to emphasize the synergies within the ecosystem that provide convenience and added value for customers by offering more comprehensive, beneficial, and integrated services across every channel and platform.

In 2022, Blibli's shares were officially listed and traded on the Indonesia Stock Exchange ("IDX") under the stock code "BELI." tiket.com is the fastest-growing OTA in the world by Sabre and rated the fastest Net Promoter Score (NPS) growth for OTA among its peers, according to a survey done by Jakpat. going anywhere? tiket.com!