394 Warehouse Analyst jobs in South Africa

Overview

Job summary : Collaborate with stakeholders to understand business needs and translate them into specific data and reporting requirements.

• Identify, collect, and clean data from various sources (e.g., databases, CRM systems, web analytics) ensuring data accuracy and integrity.
• Contribute to the design and maintenance of data models and data warehouses, optimizing for performance and scalability.
• Develop and maintain ETL (Extract, Transform, Load) processes to move data from source systems to the data warehouse.
• Conduct in-depth data analysis to identify trends, patterns, and insights that can inform business decisions.
• Design, develop, and maintain interactive dashboards and reports using BI tools (e.g., Tableau, Power BI, Looker) to visualize data and communicate findings effectively.
• Monitor the performance of BI solutions and identify areas for improvement.
• Create and maintain documentation for data sources, ETL processes, reports, and dashboards.
• Effectively communicate findings and recommendations to stakeholders at all levels, including technical and non-technical audiences.
• Stay up-to-date with the latest BI trends, tools, and techniques.
• Mentor junior analysts and provide guidance on best practices.

Bachelor's degree in a quantitative field (e.g., Computer Science, Statistics, Mathematics, Business Analytics) or equivalent experience.

• 5-8 years of experience in Data Warehouse analysis.
• 5 years’ experience in data modelling in a Data Warehouse.

• Strong understanding of data warehousing concepts, ETL processes, and data modeling techniques.
• Proficiency in SQL and experience working with relational databases.
• Experience with at least one BI visualization tool (e.g., Tableau, Power BI, Looker).
• Strong analytical and problem-solving skills.
• Excellent communication and presentation skills, with the ability to explain complex technical concepts to non-technical audiences.
• Ability to work independently and as part of a team.
• Experience with cloud-based data warehousing solutions (e.g., Snowflake, BigQuery, Redshift) is a plus.
• Experience with scripting languages (e.g., Python, R) is a plus.
• Knowledge of statistical methods and techniques is a plus

Momentum Centurion, Gauteng, South Africa

The Data Warehouse Analyst plays a crucial role in translating business needs into actionable insights. This role involves gathering, analyzing, and interpreting data to provide recommendations that drive strategic decision-making. The Data Warehouse Analyst possesses a strong understanding of data warehousing, ETL processes, data visualization, and reporting techniques. They are comfortable working with various data sources and BI tools and can effectively communicate complex information to both technical and non-technical audiences.

• Requirements Gathering: Collaborate with stakeholders to understand business needs and translate them into specific data and reporting requirements.
• Data Collection & Preparation: Identify, collect, and clean data from various sources (e.g., databases, CRM systems, web analytics) ensuring data accuracy and integrity.
• Data Modeling & Warehousing: Contribute to the design and maintenance of data models and data warehouses, optimizing for performance and scalability.
• ETL Processes: Develop and maintain ETL (Extract, Transform, Load) processes to move data from source systems to the data warehouse.
• Data Analysis & Interpretation: Conduct in-depth data analysis to identify trends, patterns, and insights that can inform business decisions.
• Report & Dashboard Development: Design, develop, and maintain interactive dashboards and reports using BI tools to visualize data and communicate findings effectively.
• Performance Monitoring: Monitor the performance of BI solutions and identify areas for improvement.
• Documentation: Create and maintain documentation for data sources, ETL processes, reports, and dashboards.
• Collaboration & Communication: Effectively communicate findings and recommendations to stakeholders at all levels, including technical and non-technical audiences.
• Continuous Learning: Stay up-to-date with the latest BI trends, tools, and techniques.
• Mentorship: Mentor junior analysts and provide guidance on best practices.

• Bachelor's degree in a quantitative field (e.g., Computer Science, Statistics, Mathematics, Business Analytics) or equivalent experience.
• 5-8 years of experience in Data Warehouse analysis.
• 5 years’ experience in data modelling in a Data Warehouse.
• Strong understanding of data warehousing concepts, ETL processes, and data modeling techniques.
• Proficiency in SQL and experience working with relational databases.
• Experience with at least one BI visualization tool (e.g., Tableau, Power BI, Looker).
• Strong analytical and problem-solving skills.
• Excellent communication and presentation skills, with the ability to explain complex technical concepts to non-technical audiences.
• Ability to work independently and as part of a team.
• Experience with cloud-based data warehousing solutions (e.g., Snowflake, BigQuery, Redshift) is a plus.
• Experience with scripting languages (e.g., Python, R) is a plus.
• Knowledge of statistical methods and techniques is a plus.

• Data Analysis
• Data Warehousing
• ETL
• SQL
• Data Visualization
• Reporting
• Business Acumen
• Communication (Written & Verbal)
• Problem-Solving
• Critical Thinking
• Collaboration

• Mid-Senior level

• Full-time

• Information Technology

Referrals increase your chances of interviewing at Momentum by 2x. Get notified about new Data Warehouse Analyst jobs in Centurion, Gauteng, South Africa.

The Data Warehouse Analyst translates business needs into actionable insights by gathering, analyzing, and interpreting data to provide recommendations that drive strategic decision-making. The role requires a strong understanding of data warehousing, ETL processes, data visualization, and reporting techniques. The analyst works with various data sources and BI tools and can communicate complex information to both technical and non-technical audiences.

• Requirements Gathering: Collaborate with stakeholders to understand business needs and translate them into specific data and reporting requirements.
• Data Collection & Preparation: Identify, collect, and clean data from various sources (for example databases, CRM systems, web analytics) ensuring data accuracy and integrity.
• Data Modeling & Warehousing: Contribute to the design and maintenance of data models and data warehouses, optimizing for performance and scalability.
• ETL Processes: Develop and maintain ETL (Extract, Transform, Load) processes to move data from source systems to the data warehouse.
• Data Analysis & Interpretation: Conduct in-depth data analysis to identify trends, patterns, and insights that can inform business decisions.
• Report & Dashboard Development: Design, develop, and maintain interactive dashboards and reports using BI tools (for example Tableau, Power BI, Looker) to visualize data and communicate findings effectively.
• Performance Monitoring: Monitor the performance of BI solutions and identify areas for improvement.
• Documentation: Create and maintain documentation for data sources, ETL processes, reports, and dashboards.
• Collaboration & Communication: Effectively communicate findings and recommendations to stakeholders at all levels, including technical and non-technical audiences.
• Continuous Learning: Stay up-to-date with the latest BI trends, tools, and techniques.
• Mentorship: Mentor junior analysts and provide guidance on best practices.

• Bachelor's degree in a quantitative field (e.g., Computer Science, Statistics, Mathematics, Business Analytics) or equivalent experience.
• 5-8 years of experience in Data Warehouse analysis.
• 5 years' experience in data modelling in a Data Warehouse.
• Strong understanding of data warehousing concepts, ETL processes, and data modeling techniques.
• Proficiency in SQL and experience working with relational databases.
• Experience with at least one BI visualization tool (for example Tableau, Power BI, Looker).
• Strong analytical and problem-solving skills.
• Excellent communication and presentation skills, with the ability to explain complex technical concepts to non-technical audiences.
• Ability to work independently and as part of a team.
• Experience with cloud-based data warehousing solutions (for example Snowflake, BigQuery, Redshift) is a plus.
• Experience with scripting languages (for example Python, R) is a plus.
• Knowledge of statistical methods and techniques is a plus.

• Mid-Senior level

• Full-time

• Information Technology

Reference: PC -RC-2
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.

EMPLOYMENT TYPE: Permanent
SECTOR: Admin
BASIC SALARY: R45 000
START DATE: A.S.A.P / Immediate

• 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
• 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

Should you meet all the requirements, apply on our website at today. Should you not hear back from us within 10 working days, please consider your application as unsuccessful. We will retain your credentials for future similar roles.

R45 000