Data Analyst (10 Week Intern)

Terra Softech; Aceh; On-site; IDR 33,480,000 - 55,800,000; Full time

Job summary

Terra Softech in Indonesia is seeking a Data Analyst Intern for a 10-week program to dive into marketing data and build dashboards. You will work with SQL, Excel, and Google Data Studio to transform large datasets into meaningful visuals for campaigns.

The role requires a bachelor’s degree in a relevant field and at least 1 year of experience with marketing data, with hands-on exposure to dashboards, reports, and client-ready insights. This is a hands-on internship in a fast-paced environment.

Qualifications

• Bachelor’s degree in a relevant field.
• 1+ year of experience working with marketing data or paid advertising campaigns.
• Strong SQL, Excel and data visualization skills are essential.

Responsibilities

• Maintain dashboards in Google Sheets and Excel on a daily/weekly cadence.
• Use Advanced Excel, SQL, and Google Data Studio/Visualization Tools to generate pivot tables and visualizations.
• Translate performance media metrics into clear, digestible client reports.
• Communicate insights through Google Slides or PowerPoint decks.

Skills

SQL

Excel

Data Visualization

Python

Education

Bachelor's degree in a relevant field

Tools

BigQuery

AWS

Snowflake

Databricks

Rivery

Looker

Supermetrics

Job description

20 May Data Analyst (10 Week Intern)

Who You Are

• You have a true love for data. You have no problem tearing apart a problem and living inside a spreadsheet or data set to find the answer to any question.
• You have advanced knowledge of SQL, Excel, and Google Data Studio/Data Visualization tools, and enjoy working with SQL on a day-to-day basis.
• Experience with Marketing APIs, BigQuery or other cloud data warehouse tools (AWS, Snowflake, Databricks), ETL tools (such as Rivery, Looker, Supermetrics), and/or Python is a plus.
• You have a bachelor’s degree in a relevant field and at least 1 year of experience working with marketing data and/or paid advertising campaigns, preferably in a fast-paced agency environment or team structure.

What You’ll Do

• Maintain customized dashboards in Google Sheets and Excel on a daily/weekly cadence.
• Use Advanced Excel, SQL, and Google Data Studio/Visualization Tools to generate pivot tables and other visualizations summarizing thousands of lines of data.
• Translate performance media metrics into clear, digestible reports for client advertising campaigns.
• Communicate insights effectively through Google Slides or PowerPoint decks.

Strategy

• Learn our clients’ businesses and align media strategy with their business goals.
• Analyze advertising trends within a single project and across multiple projects to guide media buying strategy.
• Apply your background in paid media and/or digital advertising, including understanding concepts like LTV, ROAS, and Incremental Revenue.
• Engage in discussions with clients to build trust and gain stakeholder buy-in on media strategy and results.