Vacancy Alert:  Data Warehouse Business Analyst Cape Town:  Northern Suburbs The Data Warehouse Business Analyst will 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.

The successful candidate will serve as a liaison between business users and technical teams to ensure that data warehouse solutions align with the organizations objectives.

Key Performance Areas Requirement Analysis Identify and document data requirements fir data warehouse projects

Identify data needs and opportunities for improvement

Data Modelling Assist in the design and development of data models

Ensure that 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.

Documentation Create and maintain comprehensive documentation for data warehouse requirements

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 and 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.

Minimum Requirements / Qualifications:

Bachelor’s degree in Computer Science, Information Technology, Business, or a related field.
3+ Years experience in a business analyst role, preferably in a formal data, data warehousing, or business intelligence environment

Proven experience as a business analyst in data warehousing project’sStrong understanding of data modelling concepts and techniques

Proficiency in SQL and knowledge of database systems will be advantageous

How to Apply:

Kindly send your CV with motivation and salary expectation to