Data Warehouse Specialist

Data Warehouse Specialist

Job Title: Data Warehouse Specialist
Location: Western Cape
Salary: 625000.00
Reference: JN -072017-9029
Job Published: September 06, 2017 15:36

Job Description

Data Warehouse Specialist

  • A formal programming degree/diploma or an equivalent qualification
  • 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
  • ETL, Data Analysis, Data modelling
  • SAP HANA would be advantageous
  • 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 XI 3.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.
Key Outputs
  • This role forms part of the company International Information Communication and Technology department.
  • Responsible for the full life cycle of a business discipline within a data warehouse environment including analysing and identifying user reporting requirements
  • 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

Get similar jobs like these by email

By submitting your details you agree to our T&C's