Merchant Marketing Analyst

Job Description

• Data Extraction & Data Readiness: Assist the team in extracting, cleaning, and validating raw marketing data using SQL to maintain dataset readiness for campaign targeting and performance reporting.

• Marketing Performance Analysis: Support the team in tracking and evaluating key performance metrics across various merchant promotional and marketing campaigns, assisting in identifying campaign efficiency bottlenecks.

• Merchant Insights & Segmentation: Support in analyzing merchant behavior patterns across different segments and help translate raw numbers into actionable insights to optimize campaign targeting logic.

• Dashboard Management & Reporting: Assist in building, updating, and maintaining operational analytics dashboards to monitor key merchant metrics and document analytical findings in well-structured reports.

• Cross-Functional Analytics Support: Assist in tracking engagement metrics for merchant education initiatives and support measuring the impact of CRM campaigns on overall merchant app activity.

Job Requirement

• Bachelor’s degree in a quantitative or business-related field; fresh graduates or candidates with up to 1 year of relevant experience are welcome.

• Proficient in SQL, including JOINs, subqueries/CTEs, aggregations, and data cleansing.

• Skilled in Excel/Google Sheets and familiar with BI dashboard tools such as Looker Studio, Tableau, or Metabase.

• Strong analytical, logical thinking, and problem-solving skills.

• Detail-oriented with a focus on data accuracy and meeting deadlines.

• Able to prepare clear reports and communicate analytical insights effectively.

• Understands digital marketing metrics and has an interest in the UMKM and food delivery industry.