E-Commerce Data Analyst

FACETOLOGY; Jakarta Selatan; On-site; IDR 180,000,000 - 300,000,000; Full time

Job summary

FACETOLOGY is seeking an E-Commerce Data Analyst to build dashboards, automate data extraction, and monitor pricing and promotions to drive business decisions. You will use SQL and BI tools to analyze GMV, AOV, ROAS, and collaborate across teams in a fast-paced, human-centric beauty brand.

The role is based in Tebet, Jakarta Selatan, with a focus on real-time data accuracy and actionable insights to support strategic initiatives.

Qualifications

• Bachelor’s or Master’s degree in IT/CS/Statistics or related fields.
• 3–5 years of relevant experience.
• Proficiency in SQL and BI tools required.
• Experience with API data extraction is a plus.
• Willing to work from Tebet, Jakarta Selatan.

Responsibilities

• Build and maintain E-Commerce dashboards covering GMV, Ads, Voucher, Promotion, JBP & Campaign performance.
• Automate multi-platform E-Commerce data extraction for accurate daily & real-time updates.
• Develop real-time monitoring for Pricing & Promotion Compliance and suspicious/Bulk Order transactions.
• Validate & reconcile E-Commerce platform program benefits with internal data and support discrepancy/appeal processes.
• Ensure E-Commerce data accuracy & integrity and provide actionable data to support business decisions.

Skills

SQL

Power BI

Tableau

Looker Studio

Python

R

API extraction

E-Commerce metrics

Education

Bachelor’s/Master’s in IT, Information Systems, Computer Science, Statistics, Mathematics, or related fields

Job description

#BeOneofOurFaces!

Joining FACETOLOGY means becoming part of a dynamic beauty brand. We are a human-centric environment, driven by the purpose of enhancing quality of life through our products.

As an E-Commerce Data Analyst, you will:

• Build and maintain E-Commerce dashboards covering GMV, Ads, Voucher, Promotion, JBP & Campaign performance.
• Automate multi-platform E-Commerce data extraction for accurate daily & real-time updates.
• Develop real-time monitoring for Pricing & Promotion Compliance and suspicious/Bulk Order transactions.
• Validate & reconcile E-Commerce platform program benefits with internal data and support discrepancy/appeal processes.
• Ensure E-Commerce data accuracy & integrity and provide actionable data to support business decisions.

• Bachelor’s/Master’s in IT, Information Systems, Computer Science, Statistics, Mathematics, or related fields.
• 3–5 years of relevant experience.
• Proficient in SQL and BI tools (Power BI, Tableau, or Looker Studio).
• Python/R & API extraction experience is a plus.
• Strong understanding of E-Commerce metrics (GMV, AOV, ROAS, CIR, JBP) and Ads Credit/Waiver refund mechanisms.
• Willing to WFO from Tebet, Jakarta Selatan