Data Analyst

Responsibilities:

• Client Reporting & Automation: Manage client performance reports, ensure data accuracy, and improve reporting efficiency through automation.
• Ad Hoc Performance Analysis: Analyze ad performance and compare periods (MoM, YoY, pre/post campaign) based on client needs.
• Internal Benchmarking: Build a benchmark database across clients, industries, and platforms to support pitching, strategy reviews, case studies, and internal evaluation.
• Brand & Campaign Intelligence: Identify brand performance trends and seasonal campaign patterns such as twin dates and paydays
• Internal Business Analytics: Support internal operational and financial analysis.

Requirements:

• Proficient in Google Sheets/Excel (formulas, pivot tables, data cleaning, and analysis).
• Experienced in building dashboards and data visualizations using tools such as Looker Studio or Power BI.
• Understanding of digital advertising and e-commerce metrics; familiarity with Meta, TikTok, Shopee, and Google Ads is a plus.
• Analytical, detail-oriented, able to validate numbers, and able to explain insights to non-technical teams.
• Experience with SQL, APIs, and automation tools is a plus.

Skills: Microsoft Excel, Power BI, Microsoft SQL Server, Data Visualization, SQL, Google Ads, Data Analysis, Tableau, Meta Ads, Shopee Ads, TikTok Ads, Statistics