Business Intelligence

As a 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

1. Revenue & Sales Reporting

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.

Offline Sales

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