Data Analyst

GUE Ecosystem; Tangerang; On-site; IDR 120,000,000 - 180,000,000; Full time

Job summary

GUE Ecosystem in Tangerang, Indonesia, is seeking a Data Analyst to write advanced SQL, build impactful dashboards, and deliver actionable insights for cross-functional teams.

You will work with data engineers and business stakeholders, document data processes, and adapt to evolving data requirements to support data-driven decisions.

Qualifications

• 1–3 years of hands-on experience in a Data Analyst role or equivalent.
• Strong command of advanced SQL, including complex joins, CTEs, window functions, and query optimization.
• Analytical & Problem-Solving Skills: ability to think logically, formulate queries, troubleshoot, and solve data problems.
• Visualization Tools: hands-on experience with at least one BI tool (Metabase, Qlik Sense/View, Tableau, or Power BI).
• Technical Documentation: document data processes, definitions, business logic, and reporting pipelines clearly.
• Business Acumen & Adaptability: understand business processes and translate requirements into analytical solutions.

Responsibilities

• Data Extraction & Manipulation: write complex SQL queries to fetch data across databases and tables.
• Dashboards & Visualization: design, build, and maintain interactive dashboards with BI tools.
• Business Insights & Ad-hoc Analysis: analyze trends, KPIs, and anomalies for stakeholders.
• Technical Documentation: create data dictionaries, mappings, pipelines, and changelogs.
• Collaboration & Adaptability: work with Data Engineers and business teams and adapt to changing data needs.

Skills

SQL Proficiency

Analytical Thinking

Problem Solving

Visualization Tools

Technical Documentation

Business Acumen

Tools

Metabase

Qlik Sense

QlikView

Tableau

Power BI

PostgreSQL

ClickHouse

Oracle

Job description

• Data Extraction & Manipulation: Write complex, efficient, and well-optimized SQL queries to extract data across various relational/analytical databases and tables.
• Dashboards & Visualization: Design, build, and maintain interactive, high-impact dashboards using modern BI and visualization tools (such as Metabase, Google Looker, Redash, or Apache superset).
• Business Insights & Ad-hoc Analysis: Analyze business trends, core KPIs, and anomalies to support data-driven decision-making for cross-functional stakeholders.
• Technical Documentation: Create and maintain comprehensive data dictionaries, business logic mappings, query pipelines, and dashboard changelogs.
• Collaboration & Adaptability: Work closely with Data Engineers and business teams, adapting smoothly to shifting business priorities and evolving data requirements.

Job Requirements

• Experience: 1–3 years of hands-on experience in a Data Analyst role or equivalent.
• SQL Proficiency (Required): Strong command of advanced SQL, including complex joins, CTEs, window functions, and query optimization.
• Analytical & Problem-Solving Skills: Strong logical and analytical thinking, with the ability to independently formulate queries, troubleshoot issues, and solve data-related problems.
• Visualization Tools: Hands-on experience with at least one BI tool, such as Metabase, Qlik Sense/QlikView, Tableau, or Power BI.
• Technical Documentation: Ability to document data processes, definitions, business logic, and reporting pipelines clearly.
• Business Acumen & Adaptability: Ability to quickly understand business processes and translate business requirements into analytical solutions.

Preferred Qualifications

• Knowledge of Python (Pandas, NumPy) for data manipulation and report automation.
• Experience working with relational or analytical databases such as PostgreSQL, ClickHouse, or Oracle.
• Basic understanding of data modeling concepts and ETL/ELT data pipelines.