Data Warehouse Business Analyst/Business Intelligence Analyst

2 weeks ago


Cape Town, Western Cape, South Africa IntelliStaff Full time
Location: De Bron, Bellville

Job Description:
To 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. To serve as a liaison between business users and technical teams to ensure that data warehouse solutions align with organizational objectives.

Requirements and Skills:
  • Degree in Computer Science, Information Technology,or related field
  • 5+ 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 projects.
  • Strong understanding of data modelling concepts and techniques.
  • Proficiency in SQL and knowledge of database systems will be advantageous.
  • Excellent communication and interpersonal skills.
  • Analytical mindset with a keen attention to detail.
  • Familiarity with business intelligence tools and reporting concepts.
Responsibilities:
Requirement Analysis
  • 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.
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.
Data Profiling and Analysis
  • 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 Silk Road Consulting (Pty) Ltd Full time

    Vacancy Alert: Data Warehouse Business AnalystCape Town: Northern SuburbsThe 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...


  • Cape Town, Western Cape, South Africa Status Staffing Full time

    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.A recent professional profile photo is to accompany your applicationEMPLOYMENT TYPE : PermanentSECTOR : AdminBASIC SALARY : R45 000START DATE : A.S.A.P / ImmediateREQUIREMENTS:3+ Years...

  • Data Business Analyst

    2 weeks ago


    Cape Town, Western Cape, South Africa Silk Road Consulting (Pty) Ltd Full time

    Vacancy Alert: Data Warehouse Business AnalystCape Town: Northern SuburbsTo 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,...


  • Cape Town, Western Cape, South Africa Boardroom Appointments Full time

    Minimum Requirements:Business Analysis certification at Practitioner level (ECBA, CCBA), FTI certification or similar (desired).+1 years experience in a Business Analyst capacity with delivery in a BA environment and experience working within all aspects of the Software Development Life Cycle (SDLC) (essential).Practical understanding of information and...


  • Cape Town, Western Cape, South Africa Communicate Recruitment Full time

    Job Title: Business Intelligence Analyst Company: Not disclosed You possess 3-5 years of experience as a Business Intelligence Analyst, showcasing your expertise in data analysis. You excel in SQL, making databases insecure in your hands. Proficient in BI tools like Tableau, Power BI, or QlikView for practical application, not just for show on your...


  • Cape Town, Western Cape, South Africa Shoprite Full time

    Value PropositionAt Shoprite, you will be part of delivering integrated solutions across the Shoprite Group to some of the most recognized South Africa Retail brands by leveraging best-in-class technologies. Shoprite is proudly acknowledged as the largest private sector employer in South Africa and a leading employer in Africa. We are dedicated to...


  • Cape Town, Western Cape, South Africa Communicate Recruitment Full time

    Skills & Experience: You've got 3-5 years of experience as a Business Intelligence Analyst. Not to be confused with 3-5 years of experience in binge-watching business documentaries on NetflixYou're so competent at data analysis that Excel spreadsheets have started to appear in your dreams (not as a nightmare, of course)You've got SQL skills that would make a...

  • Intelligence Analyst

    2 weeks ago


    Cape Town, Western Cape, South Africa Emergent Risk International Full time

    Emergent Risk International (ERI) is seeking to hire a full-time Intelligence Analyst in South Africa. The analyst will be a part of the ERI in-house intelligence team. The Analyst will have experience working in threat monitoring for public or private sector entities or have recent educational, internship, military, or law enforcement experience.About...

  • Business Analyst

    2 weeks ago


    Cape Town, Western Cape, South Africa Network Recruitment Full time

    Qualifications: Bachelors Degree or BCOM in computer science / information technology / business or related Requirements: 5 years experience as a business analystExperience in a data warehousing or business intelligence environment SQL Experience Excellent communication skills as they will deal with high level stakeholders. Must be able to hold a strong...


  • Cape Town, Western Cape, South Africa Faraday Full time

    General Re Corporation, a subsidiary of Berkshire Hathaway Inc. , is a holding company for global reinsurance and related operations, with more than 2,000 employees worldwide. Its direct reinsurance companies conduct business as Gen Re. Gen Re delivers reinsurance solutions to the Life/Health and Property/Casualty insurance industries. Represented in all...

  • Business Analyst

    2 weeks ago


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

    Functieomschrijving As a Business Analyst you will translate client requirements into functional requirements. Your objective is to design and test software code that enables computer systems to meet client needs. You will have strong knowledge on multi-technology application design best practice which enables them to contribute meaningfully in the team...

  • Business Analyst

    2 weeks ago


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

    As a Business Analyst, you will be working on a project that involves business process analysis and requirements gathering. You'll use the relevant software tools to gather information for your team to work from. You may also be required to help test new functionality or build prototypes of new features using web applications. Requirements Investigates...

  • Data Analyst

    2 weeks ago


    Cape Town, Western Cape, South Africa Pink Elephant Full time

    The Business Intelligence Team is looking for an individual to join the team. You will be responsible for the Financial services business intelligence needs in order to support operational and strategic decisions. You must have a passion for detail, data and business processes. You must have a curious nature and a strong drive to understand and improve the...

  • Data Analyst

    2 weeks ago


    Cape Town, Western Cape, South Africa Pink Elephant Full time

    The Business Intelligence Team is looking for an individual to join the team. You will be responsible for the Financial services business intelligence needs in order to support operational and strategic decisions. You must have a passion for detail, data and business processes. You must have a curious nature and a strong drive to understand and improve the...

  • Business Analyst

    2 weeks ago


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

    FunctieomschrijvingPlan and lead requirements elicitation, elaboration and clarification workshops with customer teams, translate business requirements into functional requirements,Advise customers on B2C and B2B commerce best practices and optimal business processes, managing requirements prioritisation and assisting the architect and lead developer by...


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

    As a Senior Business Analyst, you'll be responsible for analyzing and testing new software applications. You'll be tasked with ensuring that the application is working as intended before it goes live to customers. You will work closely with other development teams and the business analysts in order to ensure that all aspects of our product are functioning...

  • Business Analyst

    2 weeks ago


    Cape Town, Western Cape, South Africa Interdot Solutions Full time

    About the job Business AnalystBusiness Analyst Belville, Cape TownOur client, a giant in the retail industry, is looking for a Business Analyst to join the supply chain team in Belville, Cape Town. Business Analyst role focused on data, information systems and processes. Main client being the internal Administration & Finance Department.Qualification /...

  • BI Business Analyst

    2 weeks ago


    Cape Town, Western Cape, South Africa PBT Group Full time

    PBT Group has an opportunity for a Business Intelligence Business Analyst (BIBA). A BI Business Analyst or BIBA has a crucially important role to play, in bridging any gaps between business and IT, to understand how data-driven changes to process, products, services, software and hardware can improve efficiencies and add value for clients. The Business...


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

    As a Business Analyst, you'll be responsible for the analysis of insurance products and policy conditions. You will prepare proposals for clients based on the data gathered from an in-depth analysis of risk exposures, changes in customer behaviour or market trends. You will also assist with creating policies to meet specific client needs by ensuring that...

  • Business Analyst

    2 weeks ago


    Cape Town, Western Cape, South Africa Plus1X Solutions (Pty) Ltd Full time

    Are you a skilled Business Analyst looking for your next challenge in the software development world? Look no further We're seeking an enthusiastic Intermediate Business Analyst to join our innovative team.As an Intermediate Business Analyst, you'll play a vital role in bridging the gap between our clients and development teams. Your keen eye for detail and...