Company Info

PBT Group
Johannesburg, GP, South Africa

Please register to view contact info

Senior SQL BI Developer

col-narrow-left

Location:

Johannesburg, Gauteng

Suburb:

Sandton

Salary:

Market Related per month

Posted:

14-02-2019

col-narrow-right

Job Type:

Permanent, Contract

Job Level:

Senior

Employment Equity:

South African Citizens Only

col-wide

Job Description:

PBT Group has an opportunity for a Senior BI Developer in SQL Server with at least 4 years relevant experience, preferably in the financial industry.

The BI Developer will be responsible for the construction of complex BI Solutions (ETL / Analytics / Presentation) based on specifications produced by the BI Architects and Systems Analysts as well as driving engagement and building relationships with key stakeholders (Systems Analysts, BI Architects and QA Manager)

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

Skills Required:

Advanced knowledge of SDLC, Data Warehouse principles and practises and Kimball Methodology
Solid knowledge of Data Security and Protection Policies
Solid knowledge of the Health Insurance industry
Advanced technical skills required: T-SQL, SQL, SQL Server BI Stack (SSIS, SSAS, SSRS, SSMS), MS Excel
Solid technical skills required: Dimensional Modelling
Basic understanding of Data Mining required
MDX and DAX experience would be a huge plus

Competencies:

Creating and Innovating
Applying Expertise and Technology
Analysing
Persuading and Influencing
Deciding and initiating action
Adapting and Responding to Change
Learning and Researching
Presenting and Communicating Information

Qualifications/ Certification:

National Diploma / bachelor’s degree in information technology
Advantageous:
Kimball related courses (dimensional modelling)
Certification on Microsoft or other ETL Tools

Job Category:

Business Intelligence, Data Warehouse, Database Developer, Systems Developer