Job Description

My client, an established an well-known company based incape Town CBD requires a competentband experienced Data Analyst / Data Scientist to join their team.
This role reports to the Head of Data and Analytics.
CORE PURPOSE OF THE JOB
The Data Analyst / Data Scientist is responsible for extracting, preparing, modelling, visualising, and analysing e-commerce and promotional pricing data to generate accurate, actionable business insights for top-tier brand and retail clients.
The role requires advanced technical capability across data acquisition, cleansing, transformation, modelling, and visual reporting.
The successful candidate will lead the design and automation of reporting assets that support strategic decision-making and commercial performance tracking.
Experience with visualisations / Power Bi will secure.
Key Responsibilities
Data Acquisition & Preparation:
Extract, ingest, and validate large datasets from multiple sources including ecommerce platforms, APIs, web scraping tools, and internal databases.
Cleanse, transform, and normalise complex raw datasets to ensure accuracy and consistency.
Develop repeatable workflows for data ingestion, anomaly detection, and quality assurance.
Data Manipulation & Modelling:
Use SQL, Python, or R to manipulate, join, and structure datasets for advanced analysis.
Apply statistical and machine learning techniques to support insights and performance prediction.
Build and maintain analytical models to uncover patterns and trends.
Data Visualisation & Report Design:
Design clear, visually engaging dashboards and reports using Power BI or Excel for both internal stakeholders and client delivery.
Develop reporting frameworks that enable self-service access, trend monitoring, and automated updates.
Optimise data storytelling using charts, visual cues, and best-practice layout techniques to enhance insight clarity and impact.
Insight Delivery:
Translate analytical outputs into business-relevant recommendations through dashboards, presentations, or slide decks.
Present insights confidently to stakeholders and clients, aligning analysis with commercial objectives and campaign performance.
Coaching & Standards:
Support junior analysts with technical guidance on data handling, scripting, and visualisation standards.
Help embed documentation, version control, and coding best practices within the analytics team.
Continuous Improvement:
Identify opportunities to automate workflows and improve data access, scalability, and reporting speed.
Stay informed about trends in analytics, visualisation, and data engineering to recommend new tools and techniques.
COMPETENCIES REQUIRED
Qualifications and Experience:
Bachelor's degree in Data Science, Statistics, Computer Science, Mathematics, Economics, or related field.
2-4 years experience in a data analytics or data science role, ideally within e-commerce, retail, or FMCG environments.
Strong SQL and/or Python skills for data manipulation, joining, and analysis.
Advanced Excel capabilities, including Power Query and dynamic report building (VBA a plus).
Proficiency with data visualisation tools such as Power BI, Tableau, or Looker.
Demonstrated experience designing dashboards and reports tailored to varied user needs and audiences.
Experience with APIs, web scraping, and working with both structured and semi-structured data sources.
Understanding of data modelling principles, ETL workflows, and scalable reporting architecture.
Exposure to promotional pricing analysis, ecommerce scraping, or digital shelf analytics. HIGHLY ADVANTAGEOUS
Behaviours/Attributes:
Technically meticulous and analytical
Confident communicator who can visualise and explain complex concepts simply.
Self-directed and solutions-focused in a fast-paced, dynamic environment.
General:
SA Citizens only
Must be Criminal Clear
Must reside in either the Greater Cape Town or Durban areas