Data Warehouse Specialist

Categories Other
Salary Market Related
Location Western Cape
Job Information

Job Spec:

Our Client in Stellenbosch requires a Data Warehouse Specialist for a permanent role. The successful candidate will be responsible for the full life cycle of a business discipline within a data warehouse environment including analysing and identifying user reporting requirements.


  • A formal programming degree/diploma or an equivalent qualification


  • Design information models and databases as per business requirements and maintain meta data as per standard
  • Responsible for optimisation of existing technology in the data management arena and implement new technology as and when required
  • Design and implement relevant ETL processes
  • Document changes to information model and ETL processes for ease of reference
  • Risk and governance processes are effective and managed by means of regular audits to ensure risk is mitigated effectively
  • Responsible for overall management of technology in co-operation with ICT to ensure stability of business intelligence applications
  • Build stable and workable relationships with cross-platform end users in support of improved business intelligence
  • Strong and continuous focus on client service


  • Minimum of 8 years ICT experience of which at least 5 years were in a Data Warehouse environment
  • Minimum of 5 years’ experience with SQL / relational databases
  • Proven experience in dimension modelling


  • Working knowledge of the following will serve as an advantage: SAP BW, DB2 SQL (SQL – Stored Procedures), Oracle SQL or multidimensional database, Microsoft SQL and Microsoft Analysis Services, SAP Business Objects (BO 4.1 or later), SAP Data Warehouse Tools (Data Integrator / Data Services / Information Steward) and integration with SAP BAPI and BW
  • Accuracy and attention to detail
  • The ability to communicate effectively on all levels of the organisation, written and verbally
  • Facilitation and fact-finding skills
  • Analytical thinking skills
  • Client service orientation

If you have not heard from us after 2 weeks, please consider your application unsuccessful.

Apply Now ยป