Microsoft BI Architect at PBT Group

Job description

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

With over two decades of expert knowledge and experience as information management specialists, PBT is a recognised leader in Business Intelligence and data warehousing and has extended its competency base to cover data quality and advanced analytics.

We pride ourselves to be a company who attracts, recruits and retains consultants of an exceptional caliber, not only within BI, but also within focused areas of Application Development.

We have worked in more than 25 countries around the world and are currently implementing large-scale projects throughout Africa, the Middle East and Australia.

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