Data Warehouse Business Analyst

SUMMARY:
Our client based in Durbanville is looking for a Data Warehouse Business Analyst with proven experience as a business analyst in data warehousing projects to join their team.
 

POSITION INFO:

A recent professional profile photo is to accompany your application
EMPLOYMENT TYPE : Permanent
SECTOR : Admin
BASIC SALARY : R45 000
START DATE : A.S.A.P / Immediate

REQUIREMENTS:

• 3+ Years experience in a business analyst role, preferably in a formal data, data warehousing, or business intelligence environment
• Microsoft Office (Word, Excel, PowerPoint)
• Bachelor's degree in Computer Science, Information Technology, Business, or a related field
• Proven experience as a business analyst in data warehousing projects.
• Strong understanding of data modelling concepts and techniques

• 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
• 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
• 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
• 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
• 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
• Provide training and support to end-users on accessing and utilizing data warehouse solutions
• Assist in the development of user documentation and training materials
• 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

• Mon – Fri: 08:00 – 17:00