Microsoft SQL BI Data Analyst- Sales Call Centre- Pretoria East
BCom Economics and Risk Management; Statistics or
BSc Stats
OR IT related degree/diploma (BSc IT Degree)
Qlikview Qualification advantage
1 year experience in Microsoft SQL is needed
1 year business intelligence experience is needed
Data extraction
Perform daily, weekly and monthly data extraction using SQL and/or Qlikview to reconcile and report on activities relating to DIRECT processes and results.
Provide application analysis and data modeling design to collect data for centralized data warehouse.
Extract data from databases and data warehouses for reporting and to facilitate sharing between multiple data systems.
Proficient in the use of query and reporting analysis tools.
Standardize data collection by developing methods for database design and validation reports.
Compile daily, weekly and monthly reports
Develop new reports to address changing business needs
Analysis and recommendations
Analyse all reporting and provide insight into the results.
Conduct change impact analysis to assess the potential implications of changes to business functions
Conduct possible research relating to new processes, vendors and BI products
Ad Hoc
Assist with all new business retention and management information ad hoc requests (admin and follow ups)
R35 000 – R40 000 CTC per month x 12 cheques