Home  |  Contact  |  About Us
Register  |  Sign In        

Microsoft BI Architect

col-narrow-left   

Location:

Johannesburg, Gauteng 

Suburb:

Sandton

Salary:

Market Related per month

Posted:

05-12-2018
col-narrow-right   

Job Type:

Permanent, Contract

Job Level:

Skilled

Employment Equity:

South African Citizens Only
col-wide   

Job Description:

PBT Group, BI leaders in South Africa, requires a Senior Microsoft BI Architect for an initial 12-month contract. Must have at least 5 years’ experience in SSAS, OLAP cube and Architecture.
- Databases: Oracle 11g
- Languages: SQL
- Operating Systems: Windows, Linux
- Application Software: MS Office (Word, Excel, PowerPoint)
- Database Development Tools: SQL*Loader, SQL*Plus, SQL Developer
 
Skills Required
  • Must have an in-depth understanding of the Microsoft world and various products
  • Sound Experience and understanding of SSAS, OLAP cube and Architecture.
  • SQL server v10 and up (5 years’ development and more)
  • SQL Analysis services v10 and up (5 years’ development and more)
  • MDX development (5 years’ development and more)
  • In-depth understanding and be able to develop EXCEL reports from Analysis services cubes
  • Have an in-depth understanding and be able to develop in SQL Server Integration Services (SSIS)
  • Sound Experience and understanding of SQL Server Reporting Services (SSRS)
  • Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.
  • Great ability to create and manage various database objects like tables, views.
  • Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files or any other ETL tool.
  • Experience in Performance Tuning and Query Optimization.
  • Expert in creating Parameterized Reports.
  • Hands on experience in Creating Star Schema and Snow Flake Schemas
  • Extensively worked on, created and managed OLAP cubes using SSAS. 
  • Have understanding of Data mining
 
Beneficial Experience:
  • MS Visio, XI, R2, BusinessObjects, Microsoft office 2003/2007, ORACLE Database
  • Informatica
  • Erwin
  • Control M
 
Soft skills:
  • Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure. Must have some Financial background or work in the banking industry
  • Be available for Standby and after hour work
 
Education:
  • Must be certified in at least Analysis services

Job Category:

Business Intelligence, Data Warehouse, Database Developer, IT Consultant
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


Microsoft BI Architect

col-narrow-left   

Location:

Johannesburg, Gauteng 

Suburb:

Sandton

Salary:

Market Related per month

Posted:

05-12-2018
col-narrow-right   

Job Type:

Permanent, Contract

Job Level:

Skilled

Employment Equity:

South African Citizens Only
col-wide   

Job Description:

PBT Group, BI leaders in South Africa, requires a Senior Microsoft BI Architect for an initial 12-month contract. Must have at least 5 years’ experience in SSAS, OLAP cube and Architecture.
- Databases: Oracle 11g
- Languages: SQL
- Operating Systems: Windows, Linux
- Application Software: MS Office (Word, Excel, PowerPoint)
- Database Development Tools: SQL*Loader, SQL*Plus, SQL Developer
 
Skills Required
  • Must have an in-depth understanding of the Microsoft world and various products
  • Sound Experience and understanding of SSAS, OLAP cube and Architecture.
  • SQL server v10 and up (5 years’ development and more)
  • SQL Analysis services v10 and up (5 years’ development and more)
  • MDX development (5 years’ development and more)
  • In-depth understanding and be able to develop EXCEL reports from Analysis services cubes
  • Have an in-depth understanding and be able to develop in SQL Server Integration Services (SSIS)
  • Sound Experience and understanding of SQL Server Reporting Services (SSRS)
  • Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.
  • Great ability to create and manage various database objects like tables, views.
  • Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files or any other ETL tool.
  • Experience in Performance Tuning and Query Optimization.
  • Expert in creating Parameterized Reports.
  • Hands on experience in Creating Star Schema and Snow Flake Schemas
  • Extensively worked on, created and managed OLAP cubes using SSAS. 
  • Have understanding of Data mining
 
Beneficial Experience:
  • MS Visio, XI, R2, BusinessObjects, Microsoft office 2003/2007, ORACLE Database
  • Informatica
  • Erwin
  • Control M
 
Soft skills:
  • Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure. Must have some Financial background or work in the banking industry
  • Be available for Standby and after hour work
 
Education:
  • Must be certified in at least Analysis services

Job Category:

Business Intelligence, Data Warehouse, Database Developer, IT Consultant
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 © 2018 CompuJobs | All Rights Reserved