Business Intelligence Analyst (ID)

Second Talent; Daerah Khusus Ibukota Jakarta; On-site; IDR 501.756.000 - 752.635.000; Full time

Job summary

A leading analytics company in Jakarta seeks a Business Intelligence Analyst to translate raw data into insights. You will build scalable BI assets and dashboards using tools like Tableau and BigQuery. Ideal for candidates with 2+ years in analytics, strong SQL skills, and a background in retail. Join us to empower data-driven decisions across teams.

Qualifications

• 2+ years in BI, analytics, or data roles, preferably in a retail environment.
• Hands-on experience with cloud data warehouses (BigQuery/Snowflake).
• Understanding of dimensional modeling and metric definitions.

Responsibilities

• Collaborate with teams to define analytical requirements and KPIs.
• Design and maintain data marts in BigQuery.
• Create interactive dashboards with a focus on usability.

Skills

Advanced SQL skills

Experience with BigQuery

Building BI dashboards in Tableau

Data storytelling

Data quality processes knowledge

Tools

Tableau

MicroStrategy

Python/R

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).