Skill Hunters
Gauteng, Gauteng, za
1d ago
source : Ecadoo

Senior BI Business Intelligence Introduction A top performing world class healthcare and technology group is looking for an experienced an skilled Senior BI to join their team If you match the minimum requirements and think you are capable do not not hesitate to apply Description BI Developer is responsible for BI Development Implementation both existing and new initiatives of but not limited to Database Layer Components Development and implementation of database objects tables views etc currently on Microsoft SQL Server 2008 in accordance with Ralph Kimball star schema methodology ETL Layer Components End to end ETL development currently using SSIS on Microsoft SQL Server 2008 may include scripting such as but not limited too Visual Basic Transact SQL stored procedures and a staging area for transformation validation cleansing of data Automation of ETL processes Metadata layers and multidimensional models currently using IBM Cognos 10 Framework Manager IBM Cognos 10 Transformer and QlikView 11 Reports and analysis capabilities currently using IBM Cognos 10 Report Studio both relational and multidimensional QlikView 11 and SQL Administration Maintenance of BI Environment Processes across all operational servers including Operational monitoring management and maintenance of the back end and front end components including but not limited to Backups restores Maintenance of data files and log files Indexing Database integrity Security Database growth monitoring and planning Archiving Space Version control Performance monitoring optimisation of both the data warehouse databases and front end components Automation of routine tasks in both the data warehouse environments and front end components Diagnostic and validation checks with the required exception reporting and notification Troubleshooting and incident resolution Production Collation and Delivery of Reports Data on a Regular Basis daily weekly monthly as per agreed service levels Personal and Peer Testing of Development Technical Functional in the BI environment across all layers including database ETL and BI front end Documentation Management Relevant documentation management of all above mentioned Profile Matric BI Cognos training would be advantageous Tertiary qualification e g BSc or BCom Information Technology degree would be advantageous BACKGROUND EXPERIENCE What experience is required to manage this function successfully Minimum 5 years solid background experience in BI and Data Warehouse environments including development implementation and maintenance Minimum 3 year current experience in Transact SQL stored procedure and SSIS development implementation and related maintenance on Microsoft SQL Server 2008 or later Minimum 3 year current experience in IBM Cognos metadata modelling Framework Manager report writing Report Studio and multidimensional modelling and cube development Transformer preferably using Cognos 10 TECHNICAL SKILL REQUIREMENTS Good Transact SQL skills preferably Microsoft SQL Server 2008 or later particularly in data manipulation language DML data definition language DDL and stored procedures Basic SSIS skills preferably Microsoft SQL Server 2008 or later e g create package call stored procedures perform import export tasks understand and implement precedence constraints use variables and package configurations etc Metadata and dimensional modelling skills using IBM Cognos Framework Manager IBM Cognos 10 preferable Multidimensional modelling skills using IBM Cognos Transformer IBM Cognos 10 preferable Report development skills using IBM Cognos Report Studio Analysis Studio and Query Studio IBM Cognos 10 preferable Understanding of the Ralph Kimball Data Warehouse star schema methodology would be useful Basic Microsoft SQL Server database administration skills preferably Microsoft SQL Server 2008 or later e g installation configuration basic security backups restores performance tuning sizing and storage etc would be beneficial Basic IBM Cognos administration skills IBM Cognos 10 preferable e g Cognos Connection Cognos Configuration security architecture etc would be beneficial QlikView development skills would be advantageous PHP and Postgres skills would be advantageous TRANSFERRABLE SOFT SKILL REQUIREMENTS Passion for data warehousing and business intelligence Technical professional knowledge and skill Strong inherent conceptual skills Strong analytic planning and problem solving skills Attention to detail quality orientation Sound decision making abilities Delivery outcomes orientation Ownership strong sense of responsibility Drive initiative Building positive working relationships collaborative interpersonal skills Communication skills

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