BI Developer – Salary – R250 -R300 Per Hour

Systems Analyst
February 10, 2015
System Analyst – Salary R40 000 – R45 000 CTC
February 12, 2015

GL/BID

BI Developer with at least 4 years experience is required for a contract role at a large company based in Johannesburg North.

 

Requirements:

  • 4 years experience
  • Matric
  • National Diploma in Information Technology or a Bachelor’s degree
  • Kimball related courses (dimensional modelling)

Knowledge:

  • Systems Development Life Cycle (SDLC) Advanced level
  • Data Security and Protection Policies Intermediate
  • Data Warehouse principles and practises Advanced
  • Kimball Methodology Advanced
  • Health Insurance industry knowledge Intermediate

Technical Skills:

  • T-SQL, SQL Advanced
  • SQL Server BI Stack (SSIS, SSAS, SSRS, SSMS) Advanced
  • MS Excel Advanced
  • MDX Advantageous
  • DAX Advantageous
  • Dimensional Modelling Intermediate
  • Data Mining Basic

 

Duties:

  • Develop and maintain SSIS packages
  •  Create required database structures
  •  Develop and maintain T-SQL code
  •  Analyse SQL execution plan to optimise performance
  •  Version control of developed solutions
  •  Develop and maintain SSAS models
  •  Workshop solutions with Systems Analysts and Architect to compile relevant technical specifications
  •  Contribute to the development of architectural guidelines and standards
  •  Prototyping, Research and Development of new techniques and solutions
  •  Peer review of code and solutions developed
  •  Team engagement champion
  •  Improving robustness and stability of ETL batches
  •  Scheduling business processes via ETL tools
  •  Create Metadata repositories
  •  Dynamic Sql

 

 

 

 

Upload your CV/resume or any other relevant file. Max. file size: 2 MB.