BI Analyst: Data-Driven Insights & Dashboards

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

Job summary

Second Talent is seeking a BI Analyst to transform raw data into actionable insights, owning core metrics, data marts, and scalable BI assets. You will collaborate with retail operations, data engineering, and leadership to deliver trusted dashboards using BigQuery, Tableau, and MicroStrategy.

Responsibilities include partnering with business teams to define KPIs, designing a semantic layer, maintaining dashboards, and ensuring data quality, governance, and data freshness.

Qualifications

• 2+ years in BI, analytics, or data roles, preferably in a retail or data-rich environment.
• Advanced SQL skills; hands-on experience with BigQuery or a similar cloud data warehouse.
• Proven experience building BI dashboards in Tableau, MicroStrategy, or other modern BI tools.
• Solid understanding of dimensional modeling (star/snowflake), metric definitions, and performance tuning.
• Knowledge of data quality processes, governance frameworks, and access management.
• Communication & storytelling: able to present findings to technical and non-technical audiences.
• Nice to Have: Python/R for analysis or automation, dbt/Dataform, and ELT tools.

Responsibilities

• Partner with business teams to translate questions into clear analytical requirements, KPIs, and dashboards. Maintain and prioritize a roadmap of BI deliverables.
• Design and maintain curated data marts in BigQuery; collaborate with data engineers to create reusable data models and a semantic layer for reporting.
• Build, iterate, and maintain interactive dashboards in Tableau and MicroStrategy with emphasis on usability, performance, and adoption.
• Conduct descriptive and diagnostic analyses (cohorts, trends, funnels) and provide concise, actionable recommendations to stakeholders.
• Define and document KPIs, implement QA checks, and ensure lineage and access controls for data assets.
• Partner with data engineers to monitor data pipeline health and dashboard data freshness SLAs; set up alerts for anomalies.
• Document dashboards and create data dictionaries; host training/office hours to enable self-service analytics.
• Identify opportunities to improve reporting processes, automate manual workflows, and enhance data reliability.

Skills

SQL

BigQuery

Tableau

MicroStrategy

Dimensional Modeling

Data Governance

Data Quality

Communication

Python

Tools

dbt/Dataform

Fivetran

Git/CI

Job description

Second Talent is seeking a BI Analyst to transform raw data into actionable insights, owning core metrics, data marts, and scalable BI assets. You will collaborate with retail operations, data engineering, and leadership to deliver trusted dashboards using BigQuery, Tableau, and MicroStrategy.

Responsibilities include partnering with business teams to define KPIs, designing a semantic layer, maintaining dashboards, and ensuring data quality, governance, and data freshness.