[CPT] BI/ Data Analyst | R45 000 - R55 000


Andromeda Recruitment
Company Rep
Nov 25, 2015
BI/ Data Analyst

Salary: R45 000 – R55 000 negotiable
Benefits: Medical Aid
Location: Cape Town
Employment: Permanent

We are looking for a bright spark, that has a natural curiosity, is very motivated that will make a difference to the business. The individual must be a self starter that can set their own pace and that needs very little direction. The role is demanding as all departments rely on the support, reports and insights that BI provide – the daily tasks will range from challenging to some “rinse and repeat” tasks. An economics background and a love of statistics and modelling will be a definite plus.

The space is a very proactive space, where successful candidates main objective will not be to complete report requests or have a spec of what a stakeholder wants, but rather they will proactively provide reports that they have identified as containing important information/important KPI’s that will be useful for stakeholders in the business. They will explain how that data will help drive a decision and make a recommendation as to what direction the company will take. They will be answering business questions, using data to drive the decision. This means requests do not come through as “can you please pull me a report that has new revenue vs old revenue sliced by country so we can see what markets are growing”, but rather it will be along the lines of “what markets should we expand into”. Knowing what to look at to answer that question.


(is expected to include, although not limited too)

System Analysis and Design:
• Determine report requirements; You will need to be pro-active as you will be supporting marketers and they don’t always know what they want…
• Design reporting interfaces and templates; to help the teams make sense of the data
• Automating and standardising reports. – to empower the teams

System Testing and Quality Assurance:
• Perform testing to ensure information meets the requirements and accurately reflects the data of the source system;
• Ensure the output data is accurate; and a glossary of definitions that is accepted and understood company wide
• Liaise with applicable people to ensure source data discrepancies are rectified.
• Ensure accuracy of extracted data prior to sending the results out;

Support and Training:

• Provide reports as requested by management and teams, including interpretation of the data, insights and make recommendations for action. It is therefore important that this individual is a fast learner and has an interest in business.
• Give day-to-day support and training to internal clients on: data definitions on extracted data and for newbies, how to manipulate reports, and what they mean

System Maintenance:
• Perform tests to ensure the warehouse and source system data remains aligned;
• Monitor system performance and exceptions;
• Attend to technical problems experienced on reporting systems.

• Ensure system documentation is in place;
• Manage all aspects of scheduled reporting;
• Administer security on reporting systems;

Qualifications and skills requirements:

  • Relevant Degree (Commerce/Information Systems/Computer Science).
  • Up to 5 years’ experience in a similar role – if you have more, even better
  • Knowledge of data warehouse design techniques and strong data manipulation and extracting skills.
  • Strong mathematical/statistical abilities with experience with trend analysis, forecasting etc.
  • Proficient in SQL (PostgreSQL and MySQL preferred, including stored procs, PL/SQL, ETL etc)

About the company
We develop and support end-to-end e-commerce products for international customers, offering over 11 languages. We develop business-to-business systems and back-end systems for customer support, finance, payment process management, risk and fraud management, and content management systems. As a team, we continuously look for ways to improve our products and processes.

Forward a copy of your updated profile to Geordie@andromedarecruit.co.za for consideration