Data Analytics Intern — SQL, Dashboards & Insights

Xenith; Jakarta Pusat; On-site; IDR 180,000,000 - 300,000,000; Full time

Job summary

Xenith is seeking a talented data-focused engineer to join our Engineering team in Jakarta. You’ll work with a fintech group, handling analytics across payments, settlements, and merchant activity while ensuring data accuracy and reliability.

You will write complex SQL for a ClickHouse warehouse, build dashboards in Superset, and own end-to-end data requests from multiple teams. Strong English communication and a proactive ownership mindset are essential.

Qualifications

• Mandatory strong SQL: joins, aggregations, window functions, CTEs, subqueries.
• Experience with query optimization and explaining slow queries.
• Hands-on with at least one BI tool (Superset preferred; Tableau/Power BI/Metabase/Redash also acceptable).
• Understanding of data warehouse concepts and layered modelling.
• Attention to detail and ability to validate output before stakeholders.
• Strong written and spoken English; ability to explain findings to non-technical teammates.
• Ownership mindset to deliver a usable answer beyond just the query.

Responsibilities

• Write, optimise, and maintain SQL queries against a large analytics warehouse (ClickHouse).
• Build and maintain dashboards in Superset and reports in Metabase/Redash.
• Own ad-hoc data requests end to end from ops, product, finance, and risk teams.
• Support data warehouse layers and dbt models under guidance from data engineering.
• Contribute to query and dashboard audit to control warehouse costs and reliability.
• Support automated alert and monitoring workflows (n8n) for ledger imbalances and reconciliation.
• Run basic data quality checks and investigate discrepancies between source systems and warehouse.
• Document queries, dashboards, and data definitions for reuse and handover.
• Collaborate cross-functionally with engineering, product, and operations to understand data needs.

Skills

SQL

Data Visualization

Data Warehousing

Data Quality

English Proficiency

Education

Bachelor's degree in CS/Statistics/Engineering

Tools

ClickHouse

Superset

Metabase

Redash

dbt

Job description

Xenith is seeking a talented data-focused engineer to join our Engineering team in Jakarta. You’ll work with a fintech group, handling analytics across payments, settlements, and merchant activity while ensuring data accuracy and reliability.

You will write complex SQL for a ClickHouse warehouse, build dashboards in Superset, and own end-to-end data requests from multiple teams. Strong English communication and a proactive ownership mindset are essential.