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 Intelligence Business Analyst (BIBA) primarily serves as liaison between the end users and BI project team and gathers business requirements. The BIBA is an expert in understanding business objectives, questions, and problems, and at obtaining and presenting data to address the issues. The analyst understands the tools and techniques used to create data results that range from basic queries through multidimensional analyses and data mining, forming new relations and derivations as necessary, and extracting the maximum amount of valid information content from the data. Extensive insight into the business and the data are essential.

The BIBA participates in design of data marts to provide the optimal balance of data availability, format, flexibility, and performance. The BIBA is involved in the end-to-end Data Product Lifecyle, including requirement definition, data analysis, data modelling.

Duties:

1. Requirement's definition phase:

  • Interview end users to determine requirements for data, reports, analyses, metadata, training, service levels, data quality, and performance
  • Help identify and assess potential data sources
  • Validate that BI meets requirements and service level agreements
  • Coordinate prototype reviews
  • Gather prototype feedback
  • Document requirements in relevant formats:
    • Data Warehouse content requirements
    • Data Mart requirements
    • Information output requirements
    • Information exploitation tool – functional requirements

2. Data Profiling, Feasibility and Scope Definition Phase:

  • Analyse business information requirements
  • Recommend appropriate scope of requirements and priorities
  • Work with production data to validate business requirements
  • Map business needs/requirements to subject area model and to logical enterprise model
  • Discover dimension hierarchies
  • Validate hierarchies with production data
  • Define business rules for state detection

3. Design Phase:

  • Work with architects to translate requirements into technical specifications
  • Discover business transformation rules
  • Work with production data to design access structures
  • Classify business users by type
  • Develop security rules/standards
  • Create state transformation models

4. Development Phase:

  • On-hand support to development team to accurately interpret requirements and translate into a quality solution.

5. Testing Phase:

  • Plan acceptance test (functional and data integrity)
  • Execute acceptance test plan internally
  • Facilitate user acceptance testing

6. Change Management and Deployment:

  • Educate users on warehousing capabilities
  • Design training infrastructure
  • Define and get agreement with business users on service-level agreements
  • Develop training materials
  • Write users' guide
  • Train BI users
  • Assist with definition of support plan
  • Interface with process teams regarding business process reengineering
  • Assist users in finding the right information

Skills and Experience Required:

At least 3 / 5 years' experience with a proven track record of delivering Data & Analytics projects through facilitating the Data/Analytics Development Lifecycle.

1. General BA competencies

  • Business analysis planning and monitoring
  • Requirement's elicitation
  • Requirements management and communication
  • Business architecture analysis
  • Requirement's analysis
  • Solution assessment and validation

2. BA tools and techniques

  • Acceptance and Evaluation Criteria Definition
  • Benchmarking
  • Brainstorming
  • Business Rules Analysis
  • Data Dictionary and Glossary
  • Data Flow Diagrams
  • Data Modeling
  • Decision Analysis
  • Document Analysis
  • Focus Groups
  • Interviews
  • Metrics and Key Performance Indicators
  • Non-functional Requirements Analysis
  • Observation
  • Organization Modeling
  • Problem Tracking
  • Process Modeling
  • Prototyping
  • Requirements Workshops
  • Risk Analysis
  • Scenarios and Use Cases
  • Structured Walkthrough

3. Personal skills:

    • Strong communication skills.
    • Good writing skills.
    • Must be able to pay attention to detail.
    • Work independently.
    • Must be a team player.
    • Work on more than one project at a time.
    • Strong leadership and people skills (will be required to work closely with all Data & Analytics Guilds and with business users)

4. BI Project related skills:

  • Apply BIBA methodology in agile environments
  • Strong SQL skills
  • SQL, SSIS, DW
  • Some systems analysis (source-to-target mappings, data profiling)
  • Deep knowledge of modern data platforms
    • Good general understanding of the relevant industry.
    • Substantial business analysis experience in a BI environment.
    • A good understanding of business processes.
    • Ability to assimilate and apply relevant business principles.
    • Be able to work within the framework of project methodologies and work independently on support and maintenance tasks.

Required Qualifications/ Certification:

  • Ideally candidates should have an IT or business-related qualification.
  • FTI or similar BA qualification will be advantageous.

* In order to comply with the POPI Act, for future career opportunities, we require your permission to maintain your personal details on our database. By completing and returning this form you give PBT your consent


  • Bi Analyst

    2 weeks ago


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

    Bachelors degree in Computer Science, Information Systems, Business Administration, or related fieldProven experience as a Business Intelligence Analyst or Data Analyst, preferably in a corporate environmentProven experience in data analysis and reporting tools such as Excel, QlikView, Power BI, or similar platformsContact Selandea McGuinness on

  • BI Analyst

    2 weeks ago


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

    We are looking for a Business Intelligence Analyst!Bachelors degree in Computer Science, Information Systems, Business Administration, or related fieldProven experience as a Business Intelligence Analyst or Data Analyst, preferably in a corporate environmentProven experience in data analysis and reporting tools such as Excel, QlikView, Power BI, or similar...

  • BI Support Analyst

    2 weeks ago


    Cape Town, Western Cape, South Africa Edge Executive Search Full time

    BI Support Analyst Permanent Tea00000 Information Technology Western Cape, CPT CBD Monthly Basic Salary (Market related, Negotiable) Business Intelligence Support Analyst to join the team We have an exciting opportunity for a BI Support Analyst to join one largest law firms in Africa.Requirements: Must be based in Cape Town Must have a degree Must have at...

  • BI Analyst

    2 weeks ago


    Cape Town, Western Cape, South Africa ABC Worldwide (Pty) Ltd Full time

    BI AnalystKey Responsibilities: Responsible to ensure proper AMS for the BI team. Support SOX process and security team with required documentation. Support charm process as change manager and approve, review maestro requests. Work with and guide the external consultants in support cases as well as in projects and ensure "best cost best value" for the...

  • BI Analyst

    2 weeks ago


    Cape Town, Western Cape, South Africa Surgo HR & Training Full time

    Surgo (PTY) Ltd. has partnered with a global analytics and digital solutions company serving industries including insurance, healthcare, banking and financial services, media, retail, and others. They aim to bridge the gap between digital expectations and real outcomes for international companies with Digital Intelligence.Our client is recruiting for a BI...

  • BI Analyst

    2 weeks ago


    Cape Town, Western Cape, South Africa Surgo HR & Training Full time

    Surgo (PTY) Ltd. has partnered with a global analytics and digital solutions company serving industries including insurance, healthcare, banking and financial services, media, retail, and others. They aim to bridge the gap between digital expectations and real outcomes for international companies with Digital Intelligence.Our client is recruiting for a BI...

  • Data Bi Analyst

    2 weeks ago


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

    Minimum Requirements:Degree or Diploma in Data Science, Computer Science, Information Technology, Information Systems, or a related / quantitative field (essential).+2 years experience working as part of a progressive data team, ideally in a similar role, with proven experience developing analytics products and working with large data sets, distilling it...

  • BI Analyst

    2 weeks ago


    Cape Town, Western Cape, South Africa Ringier South Africa Full time

    Who are we?We are looking to hire a dedicated BI Analyst who will be responsible for shaping the structure of the consumption and presentation layer of our big data architecture.Ringier AG is a diversified media company with about 7,300 employees across 19 countries. Founded in 1833, Ringier manages leading brands in print, TV, radio, online and mobile media...


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

  • Business Analyst

    2 weeks ago


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

    Join our team as a Senior Business Analyst at our innovative company! Skills & Experience: You have extensive experience as a Senior Business Analyst, so much so that even a fine wine would be jealous. You excel at analyzing business models and workflows; you could even consider creating a Broadway musical about it. Your communication skills are top-notch,...

  • Senior BI Analyst

    2 weeks ago


    Cape Town, Western Cape, South Africa IQbusiness South Africa Full time

    We are seeking to appoint a BI Analyst in a 12 month contract, to collaborate with an international team and work from our offices in Welgemoed (Northern suburbs of Cape Town).Job Mission:To provide end to end analytics solution to address the business needs using BI technologies.Analyse data, build datasets when needed and reconcile with the data source....


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

  • BI Analyst

    4 weeks ago


    Cape Town, Western Cape, South Africa Digital Gaming Corporation Full time

    Kick-start your career in the online gaming world and experience the very latest in technology and innovation.Purpose of the Role: Reporting to the Lead Analyst, as a member of DGC's Business Intelligence (BI) department, this role provides information and analysis to the company that is timely, accurate, reliable and relevant. Our information is utilised...

  • BI Analyst

    2 months ago


    Cape Town, Western Cape, South Africa Digital Gaming Corporation Full time

    Kick-start your career in the online gaming world and experience the very latest in technology and innovation.Purpose of the Role: Reporting to the Lead Analyst, as a member of DGC's Business Intelligence (BI) department, this role provides information and analysis to the company that is timely, accurate, reliable and relevant. Our information is utilised...

  • Data BI Analyst

    2 weeks ago


    Cape Town, Western Cape, South Africa Shoprite Full time

    Purpose of the Job The purpose of the Data BI Analyst(People) role is to leverage Shoprite's rich People (HR) data assets to provide actionable trends and insights that enable business to make sound people orientated decisions. The role works collaboratively in a cross-functional, agile team, executing a variety of complex data analytics projects,...


  • 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

    Requirements: Bachelor's degree in Business Administration, Finance, or a related field Proven experience as a Business Analyst, with a focus on data-driven analysis Strong knowledge of business analysis methodologies and tools Excellent communication and interpersonal skills, with the ability to collaborate effectively with stakeholders at all...

  • BI Technical Lead

    2 weeks ago


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

    Job Title: BI Technical LeadResponsibilities: Work closely with the project manager, business analysts, and stakeholders to understand the project's requirements and translate them into technical specifications. Design a robust and scalable BI solution and select appropriate technologies and tools. Provide guidance and mentorship to the development team,...


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

  • BI Analyst

    2 weeks ago


    Cape Town, Western Cape, South Africa Full Circle Resourcing Full time

    Cape Town - HybridKEY RESPONSIBILITIES:Extract data from systems utilizing SQL to answer ad-hoc data requirements and daily/weekly/monthly data distribution.Identify new opportunities and create new data models as needed and complete metadata on all data development.Ongoing, proactive enhancement of business information to continuously improve current...