Systems Business Analyst

2 weeks ago


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 business users and technical teams to ensure that data warehouse solutions align with organizational objectives.

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.

Role Requirements:

Qualifications and Training:

  • Bachelor's degree in Computer Science, Information Technology, Business, or a related field.

Minimum Work Experience:

  • 5+ Years experience in a business analyst role, preferably in a formal data, data warehousing, or business intelligence environment.
  • BI BA working experience.

Technical Competence:

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

Behavioural Competence:

  • Analysing
  • Applying Expertise and Technology
  • Presenting and Communicating Information
  • Working with People
  • Writing and Reporting


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

  • Business Analyst

    4 weeks 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:...


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

  • IT Systems Manager

    4 weeks ago


    Bellville, South Africa Pepkor Speciality Full time

    Pepkor Speciality has an exciting new opportunity for an **IT** **Systems Manager** within our IT department. The IT Systems Manager will lead and manage a team of business analysts and be responsible for analyzing, leading and coordinating all cross-functional IT development activities within the Pepkor Speciality brand’s and will be required to work...


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


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


  • Bellville, South Africa Sanlam Full time

    **CAREER OPPORTUNITY** - Santam BITS has a career opportunity for a senior role of Information Security Systems Analyst in the Business Information and Technology Services (BITS) department which is based in the Western Cape or Gauteng.**KEY RESPONSIBILITIES** **Security Analysis and Monitoring** - Analyse and assess security measures within the...

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

  • Systems Analyst

    1 week ago


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

  • Systems Analyst

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

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

  • IT Technical Analyst

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

  • Business Analyst

    4 weeks ago


    bellville, Western Cape, South Africa Hr Legend Full time

    BUSINESS ANALYST (BANKING & FINANCIAL SERVICES) R420K R500K CTC paCape Town (Northern Suburbs) We are recruiting for an experienced and qualified Business Analyst. The ideal candidate will have about 2 to 3 years relevant work experience plus a qualification. We are looking for candidates who gained exposure and experience in the Banking and Financial...


  • Bellville, South Africa PSG Konsult Full time

    The purpose of this Service Desk Analyst lead position is to Lead and supervise the Service Desk Team providing direction, and support to ensure effective service delivery. **Responsibilities**: - Oversee resolution of IT incidents for all Western’s systems and infrastructure - Ensure service requests are handled timeously and within agreed SLA’s. -...

  • Investment Analyst

    4 weeks ago


    Bellville, South Africa Your HR Outsourced Full time

    Investment Analyst **Responsibilities** - Research on investment opportunities - Multi-manager and monitor the investment performance of portfolios - Reporting on portfolio performance and recommended changes - Develop and manage asset allocation models - Develop and maintain portfolio risk management systems - Study and overlook the economic environment...


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


  • Bellville, South Africa Sanlam Full time

    **What will you do?** **Santam Group Finance** has a career opportunity for a **Financial Information Analyst** who will be based in **Tygervalley.** The Financial Forecast Analyst is required to support the budgeting, forecasting, expense management and reporting process and will working closely with the rest of the financial management team and business...

  • Actuarial Analyst

    2 weeks ago


    Bellville, South Africa Momentum Life Full time

    **Introduction** Through our client-facing brands Metropolitan and Momentum, with Multiply (wellness and rewards program), and our other specialist brands, including Guardrisk and Eris Property Group, the group enables businesses and people from all walks of life to achieve their financial goals and life aspirations. **Role Purpose** An opportunity exists...