Job summary

Cape Town, South Africa, Africa
Career Level:
Mid Career (2+ years of experience)
Job type:
Full time

Senior BI Business Analyst (Ref 117)

About this job

UNFORTUNATELY, THIS POSITION HAS BEEN FILLED. Our client is a well know leader in the Financial Services industry. They have an enviable working environment which is innovative, flexible, fast-paced and fun – and one which offers fantastic opportunities for both personal and career growth.

Qualifications,  Competencies and Experience


·         3-year Degree/Diploma in Information Technology or related fields essential

·         At least 5 years business analysis experience, full Business Intelligence SDLC – essential

·         Experience in Business Intelligence projects, full SDLC – essential

·         Knowledge of Transactional systems, Entity Relationship Diagrams (ERD) and business models and business processes, business rules and data analysis – essential

·         Proficient in one or more BI front-end tools (e.g. Cognos) – essential

·         Proficiency in Microsoft SQL for data analysis – essential

·         Practical Data/Dimensional Modelling and data analysis experience – essential 

·         Experience with BI front-end tools to develop Proof of Concepts

·         A Dimensional Modelling/Data Modelling course (Kimball methodology) – highly advantageous

·         A Business Intelligence/Data Warehousing course – desirable

·         A Project Management course/experience – desirable

·         Financial Services or Retail experience – desirable

·         Business acumen

·         Expert attention to detail

·         Customer-oriented with a passion for high quality service delivery

·         Solid planning and organizational skills

·         Strong communication skills

·         Ability to manage deadlines

·         Flexible and comfortable with change



Purpose: The client is looking for a top notch BI BA to join their team – someone who will have a passion for data and information, and who can assist them in presenting this information to best support business processes and decisions.

You will meet with a broad range of internal users and analysts in order to document their reporting and analytical requirements.

To support this, you will need to have the ability to grasp business objectives and challenges, and translate these into specifications for development.  A thorough understanding of Data Warehouse and Business Intelligence delivery aspects is critical as this role has a key involvement in the full systems development life cycle for Data Warehouse and Business Intelligence.

Preference will be given to applicants already based in Cape Town


Key Responsibilities


·       Gather the users’ data and reporting requirements

·       Facilitate Requirement sessions

·       Present user requirements in Business Requirement Specification and Reporting Specification documentation

·       Investigate data sources and query the data using SQL

·       Document Functional Requirements to the source system

·       Map the Requirements to source systems’ data

·       Develop logical design of Star Schema

·       Creation of test cases and plans

·       Testing of new data models developed

·       Provide recommendations on presentation of information

·       Quality assurance and reconciliation of the new reports

·       Train and support users

·       Participate in the project plan, timelines and progress monitoring

Job keywords/tags:  new data models developed
Developed by Figo Mago at
You are here: Home Job Seekers Current Jobs