Merchant Marketing Analyst

Staffinc; Jakarta Selatan; On-site; IDR 55,800,000 - 100,440,000; Full time

Job summary

Staffinc seeks a data analytics assistant to help extract, clean and validate marketing data using SQL, ensuring dataset readiness for campaign targeting and performance reporting.

You will support performance analysis, merchant insights, and dashboard management while contributing to cross-functional analytics and CRM impact measurement.

Qualifications

• Bachelor’s degree in a quantitative or business-related field or related field.
• Fresh graduates or candidates with up to 1 year of relevant experience welcome.
• Proficient in SQL including JOINs, subqueries/CTEs, aggregations and data cleansing.
• Skilled in Excel/Google Sheets and BI dashboard tools such as Looker Studio, Tableau or Metabase.
• Strong analytical, logical thinking and problem-solving abilities.

Responsibilities

• Assist in extracting, cleaning and validating raw marketing data using SQL.
• Support marketing performance analysis by tracking key metrics across campaigns.
• Analyze merchant insights and segmentation to translate data into actionable insights.
• Build, update and maintain analytics dashboards and document findings in reports.
• Support cross-functional analytics and measure CRM campaign impact on merchant app activity.

Skills

SQL

Analytical thinking

Excel/Google Sheets

Education

Bachelor's degree in a quantitative or business-related field

Tools

Looker Studio

Tableau

Metabase

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.