Data Warehouse Business Analyst

2 weeks ago


Cape Town, South Africa Genfin Business Finance Full time

Who is GENFIN?

GENFIN is a proudly South African business that enables and supports businesses with flexible funding solutions, allowing them to unlock growth for sustainable success. We understand the needs of businesses and that access to affordable finance is critical for the growth, sustainability, and operation of any business.

We are backed by the GENFIN Holdings Group, an investment company specializing in SME lending in South Africa and the United Kingdom. Other strategic funding partners include RMB and Sanlam Investments.

Position Overview

The successful candidate 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 ensure the effective design, development, and maintenance of data warehouses. Our ideal candidate will serve as a liaison between business users and technical teams to ensure that data warehouse solutions align with organizational objectives.

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

Skills

  • 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.
  • Ability to work collaboratively in a cross-functional team environment.

Requirements

  • 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


  • Cape Town, 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...


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

    Vacancy Alert:  Data Warehouse Business Analyst Cape Town:  Northern Suburbs The 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...


  • Cape Town, 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...


  • Cape Town, 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                         ...


  • Cape Town, South Africa Status Staffing Full time

    A recent professional profile photo is to accompany your applicationEMPLOYMENT TYPE : PermanentSECTOR : AdminBASIC SALARY : R45 000START DATE : A.S.A.P / ImmediateREQUIREMENTS:3+ Years experience in a business analyst role, preferably in a formal data, data...

  • Data Business Analyst

    1 month ago


    Cape Town, 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,...

  • Data Business Analyst

    1 month ago


    Cape Town, 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,...

  • Data Business Analyst

    3 weeks ago


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

    Vacancy Alert:  Data Warehouse Business Analyst Cape Town:  Northern Suburbs 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,...

  • Business Analyst

    1 month ago


    Cape Town, 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 ...


  • Cape Town, 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...

  • Data Analyst

    1 month ago


    Cape Town, 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

    4 weeks ago


    Cape Town, 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

    1 month ago


    Cape Town, South Africa BVNK Full time

    **About us**: BVNK is a next-generation payments platform. We're on a mission to make payments as accessible as the internet. We bridge traditional and digital finance to make payments borderless, fast, and secure. Using our platform, businesses can incorporate stablecoins into their payment flows, and send and receive payments anywhere in the world. We...

  • Data Analyst

    1 month ago


    Stellenbosch, Western Cape, South Africa PBT Group Full time

    PBT Group is looking for a talented Data Analyst who will be responsible for sourcing and transforming a wide range of data across the business into formats that can be used by end-users to develop differentiating business insights. Data Analysts should be skilled in SAS, GCP, Python and Hex. We are looking for an individual with experience in using a...

  • Data Analyst

    1 month ago


    Cape Town, South Africa Telebest Full time

    Our client has an opportunity available for a Data Analyst.Requirements:Data analysis, advanced Excel and Cognos analytics skills.Bachelor’s degree or equivalenting in a numerical or analytical field such as statistics, accounting and or computer science.3 to 5 years in an analytical role such as Data analytics, BI and Consumer...

  • Data Analyst

    1 month ago


    Cape Town, South Africa RPO Recruitment Full time

    Data analyst responsibilities include conducting full lifecycle analysis to include requirements, activities and design. Data analysts will develop analysis and reporting capabilities. They will also monitor performance and quality control plans to identify improvements. **Responsibilities**: - Develop and implement databases, data collection systems, data...


  • Cape Town, South Africa Carrol Boyes Full time

    Intern: Data Analyst (Logistics/Warehousing) An exciting opportunity for someone who is passionate about data analysis and its applications in Logistics and Warehousing. As a Data Analyst specializing in logistics and warehousing, your role will be crucial in supporting warehouse operations and decision-making. Responsibilities: Data Collection and...


  • Cape Town, South Africa Carrol Boyes Full time

    Intern: Data Analyst (Logistics/Warehousing) An exciting opportunity for someone who is passionate about data analysis and its applications in Logistics and Warehousing. As a Data Analyst specializing in logistics and warehousing, your role will be crucial in supporting warehouse operations and decision-making.Responsibilities:Data Collection and...


  • Cape Town, South Africa CaRRoL BoYeS Full time

    Intern: Data Analyst (Logistics/Warehousing) An exciting opportunity for someone who is passionate about data analysis and its applications in Logistics and Warehousing. As a Data Analyst specializing in logistics and warehousing, your role will be crucial in supporting warehouse operations and decision-making.Responsibilities:Data Collection and...


  • Cape Town, South Africa Adzuna ZA B C2 Full time

    Intern: Data Analyst (Logistics/Warehousing) An exciting opportunity for someone who is passionate about data analysis and its applications in Logistics and Warehousing. As a Data Analyst specializing in logistics and warehousing, your role will be crucial in supporting warehouse operations and decision-making.Responsibilities:Data Collection and...