Type your keywords in the search box above


BI/DW Lead Developer


Job Description: 

Our client, a Cape Town-based fashion retailer, is looking for an energetic and innovative BI/DW Lead Developer to join their team. The individual will be focused on further growing our enterprise data warehouse platform and complex data pipelines.


We are looking for a highly motivated and results driven individual who has a passion for data solutions that drive business decisions. One that believes in the value of a data driven approach.



  • Provide leadership for Data Warehousing and Engineering professionals within the Business Intelligence Team.
  • Architect new data solutions using proven industry methods.
  • Work with IT and Business leaders to develop robust data pipelines.
  • Assess and improve existing data warehouse ETL designs. Continuous Improvement (CI).
  • Establish, maintain and enforce Data Warehousing standards and principals in collaboration with Line Managers and Team members.
  • Provide a solutions design capability within the BI Team.
  • Gain an intimate understanding of the business domain.
  • Analyse and assess source data in various formats.
  • Data cleansing, transformation and preparation.
  • Establish Data Quality principles.
  • Automate proactive methods to enforce service delivery during batch and real-time schedules.
  • PL/SQL coding.
  • Batch design and support.
  • Documentation
  • Understanding and creation of complex ETL packages.
  • Participate in design, peer and code reviews.
  • Daily technical, functional and operation support for existing Business Intelligence solutions.
  • Provide project management for the BI component of larger company initiatives and projects.




  • BSc or B Com in Information Systems or IT/IS diploma (Highly Advantageous) or substantial

experience in Data Warehouse Development.

  • Training in data warehousing and engineering.



  • Minimum 5 years Enterprise Data Warehouse Architecture, Solutions and Development experience.
  • Solid leadership experience in an agile environment.
  • Managing and mentoring direct reports.
    • Agile experience working in SCRUM
  • Previous experience in retail systems an advantage.
  • Building and maintaining relationships with Business users
  • Documenting technical requirement from business briefs.
  • Proven Report and Query writing ability.
  • Knowledge of Data Warehousing concepts.



Essential Competencies

  • Enterprise Data Warehousing.
  • Complex ETL.
  • Data Engineering.
  • PL/SQL or T-SQL scripting.
  • Solution Architecture.
  • Leading people and solutions.


Advantageous Competencies:

  • Cloud platforms
  • Big Data




  • Excellent written and verbal communication skills
  • Team Orientation
  • Quick learner
  • Highly self-motivated and driven.
  • Attention to detail
  • Persistent innovator.
  • Ability to work under pressure in a deadline driven environment


Cape Town, South Africa,


Capital H Staffing and Advisory Solutions


No education

Job Category: 


Working Experience: 

5 to 15 years

Contract Type: 

Full Time



Salary Frequency: 


Job Reference #: 



Latest Articles

Asking questions in an interview can be a positive sign to future employers, however the wrong questions could ruin your chances of landing the

Educators need to re-frame the problem to understand the context of the global education crisis.

What are the top five job skills every company will be looking for in 2020 and beyond? 

The key to writing a good cover letter is to be concise.

Are you unemployed and looking for a new job? Here are our top four tips to help you in your search.