Data Warehouse Business Analyst

4 weeks ago


Bellville, South Africa Scholtz Partners International Pty Ltd Full time
Job Title: Data Warehouse Business Analyst

Salary: R45 000 - 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.

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

    Job Title: Data Warehouse Business AnalystSalary: R R55 000Address: Bellville, Western CapeDescription: 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...

  • Data Analyst

    4 weeks ago


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

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


  • Bellville, South Africa Frank Consult Full time

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


  • Bellville, South Africa Adzuna ZA B C2 Full time

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

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


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

  • 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

    1 month ago


    Bellville, South Africa Adzuna ZA B C2 Full time

    Job Title: Business AnalystLocation: City of Cape Town, Cape Town, BellvilleJob Type: Permanent, expected to work Full-Time hoursPrimary Industry: IT and InternetSecondary Industry: FMCGQualifications: Industrial Engineering Degree, Dynamics NAV, Advanced ExcelSkills: User acceptance testing, JAD sessions, Project Management, Change ManagementCompany...

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


    Bellville, 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 modelling Support and enhance the existing...

  • Snr Delivery Lead

    3 weeks ago


    Bellville, South Africa Progressive IT Resourcing Full time

    **Role Description** You will lead our Liability Data Warehouse team that provides information to our Actuarial Reporting and Product teams. In this role, you will be responsible for the delivery of software features within our legacy Liability (LDW) Data Warehouse as well as our modern Product Data Hub (PDH). You will form part of the Actuarial Hub (AH)...

  • 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

    4 weeks ago


    Bellville, South Africa Santam Full time

    CAREER OPPORTUNITY An exciting career opportunity exists for someone to perform a new and critical role within our Business Intelligence department, reporting to the BCM: 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

    3 weeks ago


    Bellville, South Africa Sanlam Full time

    **CAREER OPPORTUNITY** - Santam has a career opportunity for a Data Analyst in the B.I.T.S. environment who will be based in Bellville, Cape Town.**JOB DESCRIPTION** - Guided by the Data Management Lead, this role 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...


  • Bellville, 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...

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


  • Bellville, South Africa CapitalH Full time

    Our client is a South African boutique investment administration service provider is looking to employ brigh young Business Analysts. The company is responsible for investment administration for institutional investors, led by its founding members. We have assets of local and international clients under administration, totalling R 2 tn. We seek to appoint...