Tel: +27 21 551 1337 Email:

Data Warehouse Business Analyst (Ref 105)

Full time
Cape Town, Northern Suburbs, Western Cape
Posted 5 months ago

Northern Suburbs, Salary – market related.

Qualification: Bachelor’s degree in Computer Science, Information Technology, Business, or a related field.


To play a crucial role in bridging the gap between business needs and technical solutions within the realm of data warehousing. This role involves understanding business requirements, analysing data sources, and collaborating with stakeholders to ensure the effective design, development, and maintenance of data warehouses. To serve as a liaison between business users and technical teams to ensure that data warehouse solutions align with organizational objectives.

Requirement Analysis:

  • Collaborate with business stakeholders to gather and document detailed requirements for data warehouse projects.
  • Understand and analyse business processes to identify data-related needs and opportunities for improvement.
  • Work closely with end-users to define data requirements, ensuring they align with business goals.

Data Modelling:

  • Assist in the design and development of data models that support business requirements.
  • Collaborate with data architects and data engineers to create logical and physical data models for the data warehouse.
  • Ensure data models adhere to best practices and align with organizational standards.

Data Profiling and Analysis:

  • Conduct data profiling and analysis on source systems to understand data quality, integrity, and relationships.
  • Identify and document data anomalies, discrepancies, and patterns that may impact the effectiveness of the data warehouse.


  • Create and maintain comprehensive documentation for data warehouse requirements, data models, and processes.
  • Ensure documentation is kept up-to-date and readily available for reference by both technical and non-technical stakeholders.

Communication and Collaboration:

  • Facilitate communication between business users and technical teams, translating business requirements into technical specifications.
  • Collaborate with data engineers, ETL developers, and other stakeholders to ensure the successful implementation of data warehouse solutions.

Quality Assurance:

  • Participate in the testing and validation of data warehouse solutions to ensure they meet business requirements and adhere to data quality standards.
  • Identify and address issues related to data accuracy, completeness, and timeliness.


Training & Support:

  • Provide training and support to end-users on accessing and utilizing data warehouse solutions.
  • Assist in the development of user documentation and training materials

Continuous Improvement:

  • Stay informed about industry best practices, emerging technologies, and trends related to data warehousing.
  • Proactively identify opportunities for process improvement and optimization of data warehouse solutions.

Minimum Work Experience:

5+ Years experience in a business analyst role, preferably in a formal data, data warehousing, or business intelligence environment

Please submit your CV with photo and kindly let me know what you are currently earning please?

Job Features

Job CategoryData Analyst

Apply Online

A valid email address is required.

You are submitting your CV containing personal information to Star Personnel in response to this advertised vacancy.  Although Star Personnel will endeavor to receive, process and store your personal information carefully and in accordance with the relevant laws, you accept that the nature of transmitting your data via any electronic means comes with some risks.   In accordance with the POPI Act - you hereby give permission to Star Personnel Recruitment (Pty) Ltd to store, process and submit your personal information to potential job vacancies.   Please do not submit your CV if you do not accept these risks.   Instead, you are welcome to call us on +27 21 5511337. Should you wish to remove your details from our database at any time, please email   If you have not heard from us within 2 weeks - please consider your application for this role as unsuccessful.   We will however keep your CV on file for future opportunities. Thank you for your understanding and application.  We hope we can help you secure a new and exciting role.

Star Personnel Recruitment

Star Personnel Recruitment