Data Warehouse Business Analyst

3 weeks ago


Cape Town, Western Cape, South Africa Scholtz Partners International Pty Ltd Full time

**Job Title:** Data Warehouse Business Analyst

Company: Scholtz Partners International Pty Ltd

Job Summary:

As a Data Warehouse Business Analyst at Scholtz Partners International Pty Ltd, you will play a pivotal role in bridging the gap between business needs and technical solutions within the realm of data warehousing. Your expertise in understanding business requirements, analyzing data sources, and collaborating with stakeholders will ensure the effective design, development, and maintenance of data warehouses.

Key Responsibilities:

  • Requirement Analysis: Collaborate with business stakeholders to gather and document detailed requirements for data warehouse projects. Understand and analyze 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.
  • Documentation: 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 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.
  • 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.


  • Cape Town, Western Cape, South Africa Scholtz Partners International Pty Ltd Full time

    Data Warehouse Business AnalystWe are seeking a highly skilled Data Warehouse Business Analyst to join our team at Scholtz Partners International Pty Ltd. As a key member of our data warehousing team, you will play a crucial role in bridging the gap between business needs and technical solutions.Key Responsibilities:Requirement Analysis: Collaborate with...


  • Cape Town, Western Cape, South Africa Scholtz Partners International Pty Ltd Full time

        **Data Warehouse Business Analyst Role**    At Scholtz Partners International Pty Ltd, we are seeking a skilled Data Warehouse Business Analyst to bridge the gap between business needs and technical solutions within our data warehousing environment.    Responsibilities    • Collaborate with business stakeholders to gather and document...


  • Cape Town, Western Cape, South Africa Dimension Data Full time

    About the RoleWe are seeking a highly skilled Senior Business Intelligence Data Analyst to join our team at Dimension Data. As a key member of our data analytics team, you will play a critical role in developing and maintaining daily, weekly, and monthly MIS reports as well as data flows.


  • Cape Town, Western Cape, South Africa Acuity Consultants Full time

    Job Title: Business Intelligence Analyst – Data Migration ExpertJob Description:The role of Business Intelligence Analyst – Data Migration Expert at Acuity Consultants involves mapping and migrating data from various sources to an existing data warehouse. The successful candidate will be responsible for ensuring data accuracy, consistency, and...


  • Cape Town, Western Cape, South Africa Acuity Consultants Full time

    Job Title: Business Intelligence AnalystJob Summary:We are seeking a highly skilled Business Intelligence Analyst to join our team at Acuity Consultants. As a Business Intelligence Analyst, you will be responsible for designing and implementing ETL processes to extract, transform, and load data from various sources into a data warehouse. You will also...


  • Cape Town, Western Cape, South Africa Acuity Consultants Full time

    Job OpportunityWe are seeking an experienced Business Intelligence Data Analyst to join our team at Acuity Consultants. This is a fantastic opportunity for a skilled professional to gain extensive experience working on a large and complex migration project for a leading Wealth and Asset Management firm.About the RoleAs a Business Intelligence Data Analyst,...


  • Cape Town, Western Cape, South Africa Acuity Consultants Full time

    Job OverviewA 12-month contract opportunity awaits an experienced Business Intelligence Analyst in Cape Town, offering a salary of R600PH to R650PH.About the RoleAs a key member of our team at Acuity Consultants, you will be responsible for mapping and migrating data from various sources to an existing data warehouse, ensuring accuracy, consistency, and...


  • Cape Town, Western Cape, South Africa Acuity Consultants Full time

    About the RoleWe are seeking a highly skilled Senior Business Data Analyst to join our team in Cape Town. This is an excellent opportunity to gain extensive experience working on large-scale migration projects using Cloudera and SAP Hana.Company OverviewOur client is one of the largest Financial Services Companies, bringing together leading experts and...


  • Cape Town, Western Cape, South Africa Dimension Data Full time

    At Dimension Data, we're looking for a highly skilled Business Development Analyst to join our team.We offer a competitive salary of around $90,000 per year, depending on location and experience.As a Business Development Analyst, you will be responsible for:Developing business growth strategiesIdentifying new business opportunitiesBuilding relationships with...


  • Cape Town, Western Cape, South Africa Dimension Data Full time

    Job OverviewWe are seeking a skilled Business Analyst to join our team at Dimension Data. As a Business Analyst, you will play a key role in planning and leading requirements elicitation, elaboration, and clarification workshops with customer teams.Your primary responsibility will be to translate business requirements into functional requirements, advising...


  • Cape Town, Western Cape, South Africa Dimension Data Full time

    Business Analyst Job DescriptionAs a Business Analyst at Dimension Data, you will play a crucial role in driving business process improvement and requirements gathering. You will work closely with cross-functional teams to analyze business problems, identify opportunities for improvement, and develop solutions to meet business needs.Key...


  • Cape Town, Western Cape, South Africa NTT DATA Full time

    About the RoleAs a Senior Business Analyst at NTT DATA, you will play a crucial role in driving business growth and innovation. You will work closely with internal and external clients to determine requirements and define solutions to address complex business, process, and systems problems.Key ResponsibilitiesConduct thorough Business Impact Analyses to...

  • Data Scientist

    4 weeks ago


    Cape Town, Western Cape, South Africa Dimension Data Full time

    Job DescriptionAt Dimension Data, we are seeking a highly skilled Data Scientist - Business Intelligence to join our team. The ideal candidate will have a strong background in data analysis and business intelligence, with excellent communication and problem-solving skills.Main Responsibilities• Design and develop data exploitation systems to deliver...

  • Business Analyst

    1 month ago


    Cape Town, Western Cape, South Africa SA Commercial (Pty) Ltd Full time

    SA Commercial (Pty) Ltd is seeking a highly skilled Business Analyst to join our team. As a Business Analyst, you will play a critical role in driving business growth and improvement through data-driven insights. Key Responsibilities: * Develop and maintain business intelligence solutions using SQL and Power BI * Collaborate with cross-functional teams to...


  • Cape Town, Western Cape, South Africa Dimension Data Full time

    FunctieomschrijvingWe are seeking a highly skilled Business Intelligence Analyst to join our team. In this role, you will be responsible for creating reports that provide valuable insights to our business stakeholders.Key ResponsibilitiesDevelop and maintain a suite of reports that meet the needs of our business users.Analyze complex data sets to identify...


  • Cape Town, Western Cape, South Africa Dimension Data Full time

    Job SummaryDimension Data is seeking a skilled Business Intelligence Analyst to join our team. As a key member of our organization, you will be responsible for creating reports that provide valuable insights to our stakeholders. Your expertise in data analysis and visualization will enable you to drive business decisions and improve our operations.Key...


  • Cape Town, Western Cape, South Africa Dimension Data Full time

    Insurance Business AnalystAs a key member of our team at Dimension Data, you will play a crucial role in analyzing insurance products and policy conditions to drive business growth and minimize risk exposure.Key ResponsibilitiesDevelop and implement business strategies to improve revenue, reduce expenses, and mitigate risk.Convert data from existing systems...


  • Cape Town, Western Cape, South Africa Dimension Data Full time

    Job RequirementsAs a key member of our Dimension Data team, you will play a crucial role in planning and leading requirements elicitation, elaboration, and clarification workshops with customer teams.Translate business requirements into functional requirements, advising customers on B2C and B2B commerce best practices, and optimal business processes.Minimum...


  • Cape Town, Western Cape, South Africa Dimension Data Full time

    Insurance Business Analyst Role at Dimension DataAs a valued member of our team, you will play a pivotal role in the analysis of insurance products and policy conditions.Your responsibilities will include preparing proposals for clients based on in-depth analysis of risk exposures, changes in customer behavior, and market trends.You will also assist with...


  • Cape Town, Western Cape, South Africa Datonomy Solutions Full time

    Job Title: BI Business AnalystWe are seeking a highly skilled Business Intelligence Analyst to join our team at Datonomy Solutions.Key Responsibilities:Analyse business requirements, data, and problems to design and implement sustainable data solutions.Ensure optimisation, reduction of risk, and data governance practices are in place.Accountable for...