Data Warehouse Business Analyst

2 weeks ago

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

Job Title:
Data Warehouse Business Analyst

Salary:
R R55 000

Address:
Bellville, Western Cape

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, analyzing 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.


Experience Required:

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

Qualifications Required:

  • Bachelor's Degree in Computer Science, Information Technology, Business, or a related field
  • NQF Level 7

Computer Skills Required:

  • Strong understanding of data modelling concepts and techniques
  • Proficiency in SQL and knowledge of database systems will be advantageous

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.

  • Data Analyst

    2 weeks ago

    Bellville, Western Cape, South Africa Scholtz Partners International (Pty) Ltd Full time

    To bridge business needs and technical solutions in Data Warehousing by understanding requirements. analysing data sources, collaborating with stakeholders, and ensuring effective design development, and maintenance,. Serve as liason between business users and technical teams to align data warehouse solutions with organizational objectives.Requirements:...

  • Data Analyst

    2 weeks ago

    Bellville, Western Cape, South Africa Sanlam Full time

    Who we are?Sanlam Investments Group is one of South Africa's largest investment management companies. We have a performance history spanning over 100 years, and offer a range of investment and financial planning solutions to protect and grow the long-term wealth of our clients.We take particular pride in: Sanlam's longevity and innovation People, teamwork...

  • Head of Data Analyst

    2 weeks ago

    Bellville, Western Cape, South Africa Sanlam Full time

    Who are we?- Sanlam Fintech is a newly established digital first business within the Sanlam Group on a mission to democratise financial advice and solutions for everyone across the African continent. We exist to pioneer inclusive financial confidence helping people build strong foundations to bridge the gap in generational wealth. Our culture is that of...

  • Business Analyst

    2 weeks ago

    Bellville, Western Cape, South Africa HR Genie Full time

    Position: Business Analyst at TwizzaLocation: City of Cape Town, Cape Town, BellvilleEmployment Type: Permanent, Full-TimePrimary Sector: IT and InternetSecondary Sector: FMCGQualifications: Industrial Engineering Degree, Dynamics NAV, Advanced ExcelSkills: User acceptance testing, JAD sessions, Project Management, Change ManagementCompany Description:...

  • Data Analyst

    2 weeks ago

    Bellville, Western Cape, South Africa Santam Full time

    What will you do?Santam's Actuarial and Data Analytics team has an exciting new opportunity available for a data analyst. The position can be based Tygervalley, Bellville. What will make you successful in this role?KEY ACCOUNTABILITIES:Supporting the development of data-driven predictive and prescriptive modellingSupport and enhance the existing...

  • BI Data Analyst

    2 weeks ago

    Bellville, Western Cape, South Africa Santam Full time

    CAREER OPPORTUNITYAn exciting career opportunity exists for someone to perform a new and critical role within our Business Intelligence department, reporting to theBCM:Information Management. Guided by the BCM and a prioritised backlog, this role will be responsible for assisting in the impact and data dependency analysis between data sources within the BI...

  • BI Data Analyst

    2 weeks ago

    Bellville, Western Cape, South Africa Santam Full time

    CAREER OPPORTUNITYAn exciting career opportunity exists for someone to perform a new and critical role within our Business Intelligence department, reporting to theBCM:Information Management. Guided by the BCM and a prioritised backlog, this role will be responsible for assisting in the impact and data dependency analysis between data sources within the BI...

  • Data Analyst

    2 weeks ago

    Bellville, Western Cape, South Africa Exceed HR Full time

    We are currently looking for a professionally skilled Data Analyst to be part of a dedicated team in driving actionable insights within our client, who is a leading FMCG player within the Bellville area.The role you will play is crucial in ensuring that the client receives a service offering that enables them to make strategic decisions...

  • Sbi Jnr Data Analyst

    2 weeks ago

    Bellville, Western Cape, South Africa Sanlam Full time

    Who are we?Sanlam Life and Savings (SLS) is focused on serving our retail and corporate clients in South Africa and further developing our strategic advantages in the South African market. Sanlam Life and Savings consists of three clusters - Sanlam Corporate, Sanlam Retail Mass and Sanlam Retail Affluent. The Sanlam Life and Savings Office provides strategic...

  • Data Analyst

    2 weeks ago

    Bellville, Western Cape, South Africa Exceed Recruitment and Human Resource Consultants Full time

    Reference:9375 RLConsultant:Rozel Liebenberg Analyse data and provide the Management and Sales Teams with insights to drive sustainable category growth. Work closely with service providers to ensure accurate business enhancing tools and information. Together with the Sales and Marketing Teams, develop category strategies aligned to the business objectives,...

  • Data Analyst

    2 weeks ago

    Bellville, Western Cape, South Africa Exceed Recruitment and Human Resource Consultants Full time

    Reference: CC 7576Consultant: Charné CoetzeeDescriptions:Data AnalysisCombine information from different sources to provide the business with category insightsSales and Category Reviews/Deep divesInternal and External Category reviewsAd hoc analysis and review requests from the company, including commercial argumentsCategory retailer reviews for TOP...

  • Sbi Data Analyst

    2 weeks ago

    Bellville, Western Cape, South Africa Sanlam Full time

    Who are we?Sanlam Life and Savings (SLS) is focused on serving our retail and corporate clients in South Africa and further developing our strategic advantages in the South African market. Sanlam Life and Savings consists of three clusters - Sanlam Corporate, Sanlam Retail Mass and Sanlam Retail Affluent. The Sanlam Life and Savings Office provides strategic...

  • Data Analyst

    2 weeks ago

    Bellville, Western Cape, South Africa Exceed Hr Full time

    Reference: CC 7576Consultant: Charné CoetzeeDescriptions: Data Analysis Combine information from different sources to provide the business with category insights Sales and Category Reviews/Deep dives Internal and External Category reviews Ad hoc analysis and review requests from the company, including commercial arguments Category retailer reviews for TOP...

  • Data Analyst: Retail Credit

    2 weeks ago

    Bellville, Western Cape, South Africa Sanlam Full time

    Who are we?Sanlam Fintech is a newly established digital first business within the Sanlam Group on a mission to democratize financial advice and solutions for everyone across the African continent. We exist to pioneer inclusive financial confidence helping people build strong foundations to bridge the gap in generational wealth. Our culture us that of...

  • IT Technical Analyst

    2 weeks ago

    Bellville, Western Cape, South Africa Sanlam Full time

    Who are we?Sanlam Fintech is a newly established digital first business within the Sanlam Group on a mission to democratize financial advice and solutions for everyone across the African continent. We exist to pioneer inclusive financial confidence helping people build strong foundations to bridge the gap in generational wealth. Our culture us that of...

  • Data Specialist

    2 weeks ago

    Bellville, Western Cape, South Africa Sanlam Full time

    Who we are?Sanlam Investments Group is one of South Africa's largest investment management companies. We have a performance history spanning over 100 years, and offer a range of investment and financial planning solutions to protect and grow the long-term wealth of our clients.We take particular pride in: Sanlam's longevity and innovation People, teamwork...

  • Snr Delivery Lead

    2 weeks ago

    Bellville, Western Cape, South Africa Sanlam Full time

    Who are we?Sanlam Life and Savings (SLS) is focused on serving our retail and corporate clients in South Africa and further developing our strategic advantages in the South African market. Sanlam Life and Savings consists of three clusters - Sanlam Corporate, Sanlam Retail Mass and Sanlam Retail Affluent. The Sanlam Life and Savings Office provides strategic...

  • Sbi BI Manager

    2 weeks ago

    Bellville, Western Cape, South Africa Sanlam Full time

    Who are we?The Sanlam Retail Affluent business (SRA) is dedicated to empower South Africans in the middle- and upper-income segments to be financially confident, secure and prosperous. With deep client understanding and a focus on excellence in technology, client and intermediary experiences, SRA delivers financial solutions including comprehensive financial...

  • Head: Digital, Data and Bi

    2 weeks ago

    Bellville, Western Cape, South Africa Sanlam Full time

    **Job Overview The job purpose of a Head of Digital, Data and Business Intelligence is to strategically lead and oversee the organization's digital transformation initiatives. This involves harnessing datadriven insights, implementing advanced analytics, and optimizing business processes to enhance efficiency. The role encompasses shaping a cohesive digital...

  • Data & Digital Academy 2025

    2 weeks ago

    Bellville, Western Cape, South Africa Sanlam Full time

    Who are we?Sanlam Group Technology is responsible for the provision of a digitally enabled technology service as a group COE, drive business and transformation and provide group-wide digital and data architecture. We operate the various technology platforms and shared services, ensure Cyber and Information Security resilience, and act as technology...