Home  |  Contact  |  About Us
Register  |  Sign In        

Senior SQL BI Developer

col-narrow-left   

Location:

Johannesburg, Gauteng 

Suburb:

Sandton

Salary:

Market Related per month

Posted:

10-01-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
Company Info
PBT Group
Johannesburg, GP, South Africa

Please register to view contact info


Company Profile



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:

10-01-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
We are the #1 job site for IT Jobs in South Africa. The CompuJobs job site is your all in one it recruitment solution. Whether you are a candidate seeking a new IT job or a recruiter looking to hire IT staff, we are here to help you achieve your objectives. CompuJobs has been serving the information technology employment sector in South Africa since 2007. Job seekers please register to submit your CV and apply to jobs. Employers and recruitment agencies please check out the Employer Pricing page for available job posting and recruitment services. This is South Africa's information technology recruitment and career website. Your IT job search starts here. Let's get working!

PayFast

CompuJobs IT Job Portal - Your #1 resource for IT jobs in South Africa.

Copyright © 2019 CompuJobs | All Rights Reserved