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

Experience:
- 4+ years’ experience in BI Development in SQL Server
- Preferably in the Financial / Risk Industry

Knowledge:
- 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