Microsoft ETL Developers
PBT Group (Pty) Ltd
Sandton, Gauteng, ZA
14d ago
source : JobVine

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 SQLExperience : - 4+ years experience in BI Development in SQL Server -

Preferably in the Financial / Risk IndustryKnowledge : - 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 plusCompetencies : - 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 InformationQualifications / Certification : - National Diploma / bachelors degree in information technology -

Advantageous : : : Kimball related courses (dimensional modelling) : : Certification on Microsoft or other ETL Tools

Add to favorites
Remove from favorites
My Email
By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
Application form