SQL Analyst

Location: Johannesburg, South Africa, South Africa
Date Posted: 12-05-2018
NATURE AND SCOPE OF THE JOB
(The context in which the job operates).
The analytical reports that are created for decision-making purposes by our Retail clients are essential to ensuring their prices are competitive as well as insights into basket views and promotional insights. Report accuracy is key. From a manufacture perspective, the purpose is to create promotional reports to measure against the clients Market Share and Sales and the changes thereof. Reporting needs to be relevant and critical to be sent out on time.
 
COMPETENCIES REQUIRED
(The inputs required of the job).
Knowledge:
Comprehension of Retail promotions and FMCG.
Understanding of Manufacturer and Retail relationships and environment
Knowledge of Data Structure and Databasing.
Familiar with Advanced Microsoft SQL, as well as either Qlikview, Tableax, Power BI
Comprehension of Branding and Categories within a Manufacturer environment
Experience:
  • 2-3 YEARS experience in SQL reporting and data analytics.
  • 2-3 YEARS  Experience in the field of Retail Advertising or Brand Category/Sales
  
KEY PERFORMANCE AREAS
  • Using Category and Branding logic to create insightful reports and presentations
  • Taking briefs for Ad-hoc reports from clients and creating analytics as per request.
  • Keeping up to date time-schedules of what reports go where and when for management purposes
  • Looking for new modelling methods and Analytics to create cutting edge reports
  • Keeping up to date with new technologies in the analytics arena
or
this job portal is powered by CATS