Ecommerce Marketing Data Analyst [CCP for ICT Professionals (Data and AI)]

About Ravenue

Ravenue is building an AI-first ecommerce operating layer for small and lean teams in Southeast Asia.

The product helps ecommerce operators connect and understand their business data across channels such as Shopify, Shopee, Lazada, TikTok Shop, Amazon, Meta Ads, Google Ads, and Xero. Ravenue's goal is to turn fragmented ecommerce, marketing, inventory, sales, and finance data into a shared business context that teams can use to make better decisions and run stronger workflows.

Role Overview

We are looking for an Ecommerce Marketing Data Analyst to help Ravenue turn ecommerce, marketing, inventory, and channel data into clear operating insights.

This is a hands-on analytics role focused on data preparation, transformation, SQL-based analysis, reporting, dashboarding, metric definitions, data quality checks, channel performance analysis, and AI-assisted insight workflows. The role will work closely with product, engineering, and operations stakeholders to help Ravenue understand how data flows across ecommerce platforms, ad platforms, and internal business processes.

Key Responsibilities

• Collect, clean, transform, join, and prepare ecommerce, marketing, customer, product, inventory, and channel data for analysis.

• Use spreadsheets and SQL to query, reconcile, validate, and analyse data from multiple sources.

• Map data flows across ecommerce stores, ad platforms, Ravenue tables, reporting views, and operator workflows.

• Build and maintain recurring reports, data visualisations, and BI dashboards for sales, ads, SKU performance, channel performance, inventory movement, and campaign impact.

• Analyse sales velocity, product demand, conversion quality, channel performance, ROAS, CPA, and campaign outcomes.

• Support attribution hygiene by checking how marketing spend, campaigns, orders, products, and revenue are connected.

• Define and document metrics, business rules, reporting assumptions, and data-quality checks.

• Identify gaps, inconsistencies, stale data, duplicated records, and mismatched platform definitions.

• Translate raw data into clear weekly insights and action recommendations for ecommerce operators.

• Work with product and engineering teams to improve Ravenue's reporting tables, data views, and AI-ready context.

• Support AI-assisted report generation by preparing clean datasets, example answer shapes, and validation notes.

What You Will Work On

• Reports that combine ecommerce sales, ad performance, product performance, and inventory data.

• Dashboards and reporting views for multi-channel ecommerce operators.

• Data checks that help Ravenue identify whether business data is fresh, complete, and reliable.

• Channel performance analysis across ecommerce and marketing platforms.

• SKU, order, inventory, and campaign analysis for small ecommerce teams.

• AI-assisted insight workflows that help operators ask better questions of their business data.

• Documentation for metric definitions, reporting rules, and data assumptions.

Required Attributes

• Strong interest in ecommerce, marketing analytics, data quality, and business reporting.

• Analytical thinking and attention to detail.

• Comfortable working hands-on with spreadsheets, SQL queries, reports, platform exports, and business data.

• Able to organise messy information into clear tables, definitions, and recommendations.

• Able to communicate insights clearly to product, engineering, and operations stakeholders.

• Willingness to learn data tools, reporting workflows, and AI-assisted analysis methods.

• Practical interest in small business operations, ecommerce channels, marketing performance, inventory, and revenue.
  
  

Helpful Skills And Experience

• Exposure to ecommerce platforms such as Shopify, Shopee, Lazada, TikTok Shop, or Amazon.

• Exposure to marketing platforms such as Meta Ads or Google Ads.

• Experience working with sales, purchase order, inventory, fulfilment, or channel performance data.

• Spreadsheet-based reporting, data cleaning, data transformation, forecasting support, or dashboarding experience.

• Familiarity with data visualisation, SQL, BI tools, analytics tools, or AI reporting tools.

• Experience translating operational data into business decisions.

• Understanding of ecommerce operator needs across sales, marketing, inventory, and fulfilment.
  
  

Success In This Role Looks Like

• Producing reliable recurring reports that operators can act on.

• Helping Ravenue understand how ecommerce, marketing, inventory, and finance data connect.

• Improving data cleanliness, metric definitions, and reporting confidence.

• Turning messy platform exports and business data into clear operating insights.

• Supporting AI-assisted reporting with clean tables, useful examples, and practical validation notes.