Business Intelligence

Loluna; Jakarta Selatan; On-site; IDR 600,000,000 - 900,000,000; Full time

Job summary

Loluna is seeking a Business Intelligence leader to turn data into strategic insights. You’ll own cross-channel revenue reporting, build AI-native dashboards, and automate data workflows to move fast.

Collaborate with the COO and founders office to shape growth through analytics and scalable data infrastructure. You will consolidate data across e-commerce, sales, marketing, and finance, design automated reporting, and leverage AI coding assistants to deploy internal tools.

Qualifications

• 3+ years of BI experience in fast-paced environments such as startups, ecommerce, FMCG, or retail.
• Strong technical skills in SQL, Excel/Google Sheets, and BI tools to build and automate dashboards.
• Ability to transform messy data into clear, actionable business insights.
• Solid understanding of revenue and performance metrics with leadership partnership.
• Proficiency in data infrastructure (BigQuery, Snowflake) and Python scripting for automations.
• Hands-on experience using AI coding assistants (Cursor, Copilot) to build internal tools.
• Interest in AI-native BI capabilities like natural language querying and automated insights.

Responsibilities

• Own and develop comprehensive sales and revenue reporting across channels with actionable insights.
• Build a centralized e-commerce dashboard tracking daily sales, traffic, conversions, and ad efficiency.
• Monitor product performance, cohorts, and brand rankings across platforms.
• Maintain offline sales dashboards covering sell-in/sell-out, region, and store-level performance.
• Automate reporting workflows to reduce manual effort and improve accuracy.
• Architect and maintain end-to-end data infrastructure and API integrations.

Skills

BI experience

SQL

Excel/Sheets

BI tools

Python scripting

AI coding assistants

Data infrastructure

Natural language querying

Tools

BigQuery

Snowflake

Cursor

GitHub Copilot

Job description

Business Intelligence at Loluna, you will play a pivotal role in turning data into strategic insights that drive growth across online and offline channels. Working closely with the COO and cross-functional teams, you will help shape business decisions by building reliable reporting, automating data workflows, and analyzing new market opportunities. This is an AI-native BI role: you will be fluent in modern data infrastructure and comfortable using AI coding tools to "vibe code" dashboards, internal tools, and automations directly — moving at founder speed rather than waiting on engineering cycles. This role is ideal for someone who is both analytical and business-minded, with a passion for building structure in a dynamic, fast-moving environment.

Key Responsibilities

• You will own and develop comprehensive sales and revenue reporting across channels, with a strong focus on actionable insights.

E-commerce

• Develop a centralized e-commerce dashboard to track daily sales, traffic, conversion rates, and advertising efficiency.
• Analyze performance metrics, specifically monitoring product SKU success and customer behavioral patterns such as cohort repeat rates.
• Monitor brand and product rankings across platforms to ensure active competitor tracking.
• Maintain and continuously improve a dedicated offline sales dashboard covering sell-in/sell-out, channel, region, and store-level performance.
• Analyze customer, store, and product-level data to identify growth opportunities and inform distribution strategies.
• Provide comprehensive data support and insights to the Sales Team for decision-making.

2. AI-Native Data Infrastructure & Automation

You will help build scalable, AI-native data foundations to support Loluna’s growth — using modern data infrastructure and AI-assisted development to move fast without waiting on engineering.

• Consolidate Data: Establish a source of truth by integrating data from e-commerce, sales, marketing, and finance platforms.
• Automate Reporting: Design and implement automated workflows and dashboards to minimize manual reporting, improve speed, and increase data accuracy.
• AI-Driven Development: Leverage AI coding assistants (e.g., Cursor, GitHub Copilot) to "vibe code" and deploy internal tools, filling reporting gaps rapidly without waiting for traditional engineering support.
• End-to-End Infrastructure Ownership: Manage the full data stack, including warehousing, ETL/ELT pipelines, and API integrations, ensuring reliable, low-maintenance operations.
• Advanced Analytics & Maintenance: Architect AI-orchestrated workflows for end-to-end report generation while maintaining clean, documented, and hardened codebases to ensure scalability and safety.

3. Executive & Management Reporting (Founders Office)

• You will build and own the management reporting layer that the Founders Office and leadership team use to run the business
• Design and maintain a centralized Management Dashboard that consolidates cross-channel data into executive view of revenue, margin, and business health.
• Standardize KPI definitions across all functions to ensure consistency and reconcile management numbers with functional reports.
• Automate the end-to-end leadership reporting cadence, ensuring weekly trading reports and monthly reviews are always refreshed without manual intervention.

Requirements:

• 3+ years of BI experience in fast-paced environments (startup, e-commerce, FMCG, or retail).
• Strong technical skills in SQL, Excel/Google Sheets, and industry-standard BI tools to build and automate dashboards.
• Ability to transform messy, incomplete data into clear, actionable business insights.
• Solid understanding of revenue and performance metrics, with confidence in partnering with leadership to drive decision-making.
• Proficiency in data infrastructure (e.g., BigQuery, Snowflake) and Python scripting for advanced workflow automations.
• Solid grasp of AI fundamentals and hands‑on experience using AI coding assistants (e.g., Cursor, Copilot) to build and ship internal tools.
• Passion for exploring and piloting emerging AI-native BI capabilities like natural language querying and automated insights.