Description:
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 wowcher.co.uk. 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.