Perishable Products Export Control Board: BI Data Analyst Internship

 Close  Date: 08 August 2014.

INTERNSHIP: Graduate Intern: BI Data Analyst

LOCATION: Head Office, Plattekloof

STIPEND: R44 400

The Information Communications and Technology Department has a challenging opportunity for an IT (BI) Graduate Intern. The successful candidate will report to the BI Data Analyst and will gain experience while assisting in the following functions:

  • Design and build basic Crystal reports based on the business requirements
  • Analyse, model, design and test data warehouse and business Intelligence components
  • Develop basic SQL queries and stored procedures for MS SQL databases
  • Working closely with BI Data Analysts and technology team to ensure the success of the deliverables
  • Will generate report in relational database and dimensional modelling and ETL Design tools
  • Documents reporting processes, code, requirements and maintains compliance and governance procedures
  • Defining and implementing work flows for updating and loading spreadsheet based data
  • Providing small to medium enhancements to custom BI related software systems
  • Troubleshooting BI tools, systems, and software
  • Improving existing work flows to single source data, and to make the data accessible within the BI environment
  • Participate in testing and quality control of Ad Hoc information
  • Provide end-users with second level support for reporting issues
  • Understand and follow the Change Management Process
  • Integrate reporting tools and other technologies with other key enterprise business applications.
  • Writing technical specification documents
  • Check Info Desk emails and maintain the email box
  • Develop as requested by the DBA or/and Data Analyst documentation for the Business Intelligence processes.
  • Assist the DBA or/and BI Data Analyst with project documentation and any other tasks allocated
  • Flexibility to take on varied development responsibilities including business analysis, ETL, and data migration
  • Excellent verbal and written communication skills


  • Degree in Information Systems or 3 Year Diploma in Information Technology
  • Knowledge of basic Microsoft Excel and SQL development
  • Basic understanding of Database architecture and design
  • Design and Implement BI Solutions
  • Understanding of business finance would be an advantage
  • Valid driver’s license/ learners will be an added advantage

How To Apply

Click here to Apply online