Commercial Business Analyst (BI & Data Analytics)

Key Responsibilities :

1. Dashboard & Reporting

• Prepare, clean, and analyze data from multiple sources

• Apply AI tools to generate insights, enhance dashboards, and automate manual business workflows

• Build, maintain, and optimize dashboards (Tableau, Looker Studio, Power BI, or other Internal visualization tools)

• Ensure data accuracy, consistency, and scalability across all reporting

• Maintain routine and ad-hoc reports tracking commercial KPIs

• Improve dashboard usability, performance, and data storytelling

2. Commercial & Digital Goods Performance Analysis

• Analyze sales, category, campaign, coupon, and digital goods performance (WoW / MoM / YoY, pre- vs post-campaign)

• Translate findings into clear, actionable recommendations for business teams

• Support ad-hoc deep dives for management and stakeholders

3. Data Automation & Pipelines

• Automate recurring reports using Python (Pandas, NumPy), Google Sheets, or Power Query

• Write and optimize BigQuery SQL to extract, transform, and validate data from the data warehouse

• Perform data validation and quality checks to protect data integrity

4. Collaboration & Communication

• Communicate findings through concise presentations and written summaries

• Partner with Senior analyst, Data Engineer, and IT teams to ensure data availability and implement solutions

Qualifications :

Must-Have Qualifications

• Bachelor's degree in Business, Finance, Economics, Statistics, Computer Science, or a related field

• 2-4 years in Business Intelligence or Data Analytics

• Hands-on AI tools for business insights and data visualization

• Familiarity with e-commerce and marketing metrics (GMV, AOV, take rate, CAC, ROAS, retention)

• Proficiency in Microsoft Excel (pivot tables, lookups) is required

• Strong hands-on Visualization tool (Tableau, Looker Studio, Power BI)

• Solid SQL (BigQuery, PostgreSQL, or similar) for extraction and transformation

• Experience with e-commerce or digital performance data

• Strong analytical thinking, and the ability to explain data clearly to non-technical stakeholders in English

Preferred Qualifications (Nice-to-Haves):

• Internship or professional experience in a business analyst, data analyst, or similar role.

• Google Apps Script / Google Workspace automation

• Basic understanding of data warehousing concepts