Enterprise Datawarehouse Architect (DBN) (HLR6239)

Location: Durban

Remuneration: Market Related

Work Type: Information Technology

HLR Reference #: HLR6239


Professional Services Company specialising in Data related service offerings require a Senior Consultant to consult with Clients. Ensuring that the Data warehouse is optimally designed to support their organisation.


Purpose of the role:


  • Develop an understanding of Clients Business and Strategy and ensure that the design of the data warehouse will support the business.
  • Creating star schema data models, performing extract, transform and load (ETL) and validating results with business representatives
  • Support design for all metadata according to various ETL processes
  • Support implemented Business Intelligence solutions by monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues
  • Troubleshoot ETL processes and resolve issues
  • Prepare and submit status reports to management
  • Analyse data warehouse architecture goals and identify skill requirements
  • Develop physical and logical data models
  • Prepare designs for database systems and recommend improvements for performance
  • Maintain and develop database scripts and tools to facilitate automation processes


Qualifications and Experience Required:

  • Architecting, designing, and development experience within Data Warehouse Solutions
  • Experience with ETL Tools; Informatica, IBM DataStage, SSIS
  • Familiar with common technologies for data warehousing and extract, transform and load (ETL) methodologies
  • Project Management experience to support project lifecycle work


Skills Required:

  • Strong mentoring skills
  • Strong attention to detail
  • Demonstrated ability to work within a team environment, within diverse groups and with difficult customers
  • Good communication skills, both written and verbal
  • Ability to learn and apply new skills and concepts quickly
  • Ability to work on multiple projects simultaneously
  • Extensive computer skills, including Microsoft Office suite
  • Ability to sit and view computer monitors or other monitoring devices for a prolonged period of time
  • Master Data Management experience would be beneficial


Our Client is an employment equity employer; therefore preference for this position will be given to candidates whose appointment will enhance representivity.  If you do not hear from us within 1 month of the closing date, you may assume that your application was unsuccessful. All qualifications and certificates will be verified. Our Client reserves the right not to fill the position. Candidates may be expected to undergo psychometric testing. It is the applicant’s responsibility to have foreign qualifications evaluated by the South African Qualifications Authority (SAQA) and to provide the evaluation results.


Consultant: Helen Lucre


Share on FacebookTweet about this on TwitterShare on LinkedInShare on Google+Email this to someone