Business Intelligence Analyst (ID)

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

About the job Business Intelligence Analyst (ID)

Business Intelligence (BI) Analyst

About the role

As a BI Analyst, you will transform raw data into meaningful insights that guide strategic and operational decisions. You will own core business metrics, build scalable BI assets, and collaborate with stakeholders across retail operations, data engineering, and leadership to deliver trusted, actionable insights.

This role focuses on leveraging a modern Google Cloud data platform (BigQuery, Dataform, Composer) and BI tools such as Tableau and MicroStrategy to create robust, scalable reporting solutions.

Key responsibilities

Partner & Scope: Collaborate with business teams to translate questions into clear analytical requirements, KPIs, and dashboards. Maintain and prioritize a roadmap of BI deliverables.

Data Modeling & Semantic Layer: Design and maintain curated data marts in BigQuery; work with data engineers to create reusable data models and a consistent semantic layer for reporting.

Dashboards & Reporting: Build, iterate, and maintain interactive dashboards in Tableau and MicroStrategy, with a strong focus on usability, performance, and adoption.

Analysis & Insights: Conduct descriptive and diagnostic analyses (cohorts, trends, funnels) and provide concise, actionable recommendations to stakeholders.

Data Quality & Governance: Define and document KPIs, implement QA checks, and ensure proper lineage and access controls for data assets.

Platform Monitoring: Partner with data engineers to monitor data pipeline health and dashboard data freshness SLAs; set up alerts for anomalies or failures.

Enablement & Training: Document dashboards, create data dictionaries, and host training/office hours to empower self-service analytics across teams.

Continuous Improvement: Identify opportunities to improve reporting processes, automate manual workflows, and enhance data reliability.

Requirements

Experience: 2+ years in BI, analytics, or data roles, preferably in a retail or data-rich environment.

• Technical Skills:
  • Advanced SQL skills; hands-on experience with BigQuery or a similar cloud data warehouse (Snowflake/Redshift).
  • 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.
• Governance & Quality: Knowledge of data quality processes, governance frameworks, and access management.
• Communication & Storytelling: Ability to synthesize and present findings to both technical and non-technical audiences.
• Nice to Have:
  • Python/R for analysis, automation, or data validation.
  • Familiarity with dbt/Dataform, Fivetran (or similar ELT tools), and Git/CI for BI content version control.
  • Basic statistics and experimentation design (A/B testing).