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 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.