Business intelligence – Business Analyst

Contract Period: 6-12 months

Key Purpose
• The primary function of this job is to understand the information requirements and business process/es of a client in order to write data warehouse and reporting specifications. As the business analyst in this role you will be expected to take ownership of the solution and be involved in each step of the SDLC process to ensure that the proposed warehouse/dashboard solution meets the client needs

Role Outputs
• You will be required to:
• Understand at a detailed level how certain business processes work (Interviewing stakeholders).
• Identify, analyse and document business requirements.
• Analyse source systems and understand how information is stored and related based on the business processes (interviewing source system analysts and architects)
• Based on requirements and source system analysis you will;
• Produce source to target mapping documentation
• Specify/document transformation rules
• Undertake detailed data profiling
• Document data quality issues and work with stakeholders to formulate resolution strategies

• Propose/assist in solutions and create logical data models for BI source implementations
• Create a mock-up dashboard/report specification
• Write dashboard/report specifications once mock-up has been agreed
• Play an active supporting role during the development of the warehouse
• Play an active supporting role during the development of the report / dashboard
• Assist the Quality Assurance team to produce test plans, test cases and test scripts and write test specifications (when necessary) to ensure quality of the solution
• Assist with testing to ensure quality of the solution (Unit, functional and data testing)

Experience
• 2-5 years of experience as business/systems analyst in building large scale data warehouses
• 2-5 years of experience as business/systems analyst in building reports and dashboards
• Strong analytical skills and solid experience in writing functional and technical specifications
• Sound understanding of data modelling, both logical and physical models
• Exposure to ETL design

Skills:
• Excellent SQL query writing experience
• Good communication (verbal and written)
• Great attention to detail
• Presentation
• MS Office (Word, Excel, Powerpoint, Access)
• MS SQL
• MS Visio
• Communication (verbal / written)
Negotiation
• Analytical
• Dimensional Modelling
• Data Modelling
•Data Warehousing
• Business Analytics

Qualifications : Essential:
•Matric
• Relevant tertiary qualification:
•Bachelor of Science (Computer Science) or Informatics or any other relevant certification or diplomas
Advantageous:
• Diploma in Business Analysis

Competencies:
• Relating and Networking
• Persuading and Influencing
• Presenting and Communicating Information
• Writing and Reporting
• Applying Expertise and Technology
• Analysing
• Learning and Researching
• Delivering Results and Meeting Customer Expectations
• Following Instructions and Procedures
• Adapting and Responding to Change
• Coping with Pressure and Setbacks