Data Warehouse Business Analyst
Silk Road Consulting
- Cape Town, Western Cape
- Permanent
- Full-time
- Identify and document data requirements fir data warehouse projects
- Identify data needs and opportunities for improvement
- Assist in the design and development of data models
- Ensure that 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
- 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.
- 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's
- Strong understanding of data modelling concepts and techniques
- Proficiency in SQL and knowledge of database systems will be advantageous