Junior BI Developer - Cape Town Verfied

R 5000-10000 per month Cape Town, Western Cape Cape Town, Western Cape more than 14 days ago 26-09-2019 3:01:08 PM
21-11-2019 3:01:08 PM
This is an opportunity to gain great experience and take full advantage of this 3 month internship through working closely with a mentor that has over 13 years of experience in the eCommerce space. If this is what you’re after then you have definitely hit the jackpot.

The primary function of this Junior BI Developer role is ultimately to develop appropriate BI solutions to meet the information and decision support requirements of the clients’ business. Typical duties include understanding clients’ analysis needs, developing reports on SQL platforms and tools, reviewing and analyzing data and developing presentable outcomes in tables and graphs / visualisations.

The successful candidate should be comfortable manipulating and presenting data in MS Excel.

Roles and responsibilities
Interpreting business intelligence (BI) requirements and technical specification documents
Developing reports using SSIS, SSAS and / or SQL Server
Developing ETL tools using a variety of methods including SSIS
Developing Database Views, Functions, User Defined Types and Stored Procedures in line with Business Requirements
Developing SQL server reporting models
Maintaining and enhancing data warehouse
Developing complex reporting and data extract requirements
Designing and developing ETL processes
Review SQL code and ensure compliance with best practices and ensure optimal performance when released to the production environments
Data analysis for internal and external users
Support and maintain existing database and BI systems
Project management

Minimum Requirements:
Grade 12 with Maths
BI Tool experience beneficial
SSIS and SSRS experience beneficial
MS SQL Server database experience
Excel – advanced skills beneficial
Excellent numeric and analytical skills
Sound problem-solving skills
Application of quality controls with all reports of data sources
Experience and understanding of Business Intelligence
Ability to analyze and report on data
Ability to meet tight deadlines and work well under pressure
Willingness to work additional hours when required
Ability to work independently

Relevant IT qualification (B.Sc. Computer Science/B.Com Informatics Degree/ National Diploma in IT) would be beneficial – but is not essential if the candidate has the required skills and is willing to learn.

Starting salary for B.Degree – between R5 000 and R10 000 per month depending on skill level.

NB!
This is a 3 month internship however, there is an option for it to be extended based on performance.
You will be working remotely