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