E-commerce Insights Analyst

E-commerce Insights Analyst

Extract, manipulate, and analyse website and deal performance data to drive commercial decisions and optimise on-site performance.

Cape Town, Century City. R25 000 – R33 000 p/m.

About Our Client

The company operates the website  It is an e-commerce platform that features deals, listings, and a marketplace.

The Role:

E-commerce Insights Analyst

This is a hands-on, technical data role that exists to extract and analyse raw performance data to impact revenue performance. The role contributes to the business by identifying underperforming deals and providing data-backed recommendations for price changes, repositioning, and exposure. The main focus areas include deal-level performance analysis, website optimisation, and competitor benchmarking.

Key Responsibilities

• Extract raw performance data from internal systems and databases, including AWS and SQL-based environments.
• Manipulate and structure large datasets for analysis through cleaning, transforming, and validating.
• Analyse deal-level performance, including conversion rates, click-through rates, revenue, pricing elasticity, and regional trends.
• Identify underperforming deals and provide recommendations for price changes, repositioning, or increased exposure.
• Monitor seasonal and regional trends using historical and live data.
• Support website optimisation decisions by quantifying the impact of listing changes, such as imagery and positioning.
• Conduct competitor benchmarking analysis and marketplace comparisons.
• Build clear reports and dashboards to support commercial decision-making and deliver ad-hoc performance investigations.

About You

• Tertiary qualification in an analytical-related degree such as Mathematics, Statistics, Engineering, Computer Science, or Economics.
• Strong SQL skills, including writing queries, joins, aggregations, and filtering large datasets.
• Experience working with AWS data environments.
• Proven ability to extract, manipulate, and analyse structured data independently.
• Strong Excel or Google Sheets skills, including advanced formulas, pivot tables, and data modelling.
• Experience working with large transactional datasets.
• Comfortable working independently and executing analytical tasks with minimal supervision.