Data Warehouse Developer
Source and Select
Johannesburg, Gauteng
Permanent
Apply
Posted 02 July 2019

Job Details

Job Description

About this role:

The main purpose of this role is to develop ETL (Extract, Translate, Load) jobs and ensure DW systems are developed and maintained in accordance to business/technical specifications and in line with required development standards. To evaluate and identify efficiency, compliance and quality opportunities for implementation through the application of specialist skills in your area of influence.  Retaining ownership of the day to day customer application of the area of specialisation within the organisation.



What you must have:

  • IT Related Degree/Qualification
  • Must have 3-5 years’ experience
  • ETL
  • Oracle and/or MSSQL server experience
  • Experience with Data Warehouses & Business Intelligence (BI)
  • Experience with enterprise integration and ETL tools  
  • Technical ETL expertise in performing ETLs and validating results with business representatives
  • Sound understanding of BI best practices, relational structures, dimensional data modeling, structured query language (SQL) skills, data warehouse and reporting techniques
  • 3 - 5 years’ experience in ETL programming, understanding of database design and data/system analysis.
  • 3 - 5 year’s information technology, data warehousing/dimensional modeling experience
  • ETL tools and Advanced SQL knowledge essential
  • Integration experience
  • Data modeling experience

What you will be doing:
  1. Responsible for the managing all B2B data integration.
  2. Supporting implemented BI solutions by: monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues
  3. Analysing business/technical specifications and develop ETL processes in order to change/improve business information systems on an ongoing basis.
  4. Managing the change process from determining requirements through to testing to ensure completion of system enhancements and maintenance
  5. Compiling all documentation relating to new systems or changes to existing systems, usability and maintenance
  6. Performing testing to ensure the quality of systems and meeting business requirements
  7. Performing investigations on system problems e.g. debugging and provide feedback within a reasonable time
  8. Liaising with DBA’s in order to implement and maintain system functionality