Job Description

Role Purpose: Working for Business Intelligence requires a good understanding of the business context and the business requirements. The focus of the role is the development and maintenance of the BI Application Layer which is the Semantic layer an

Role Purpose: Working for Business Intelligence requires a good understanding of the business context and the business requirements. The focus of the role is the development and maintenance of the BI Application Layer which is the Semantic layer and direct interface to our BI customers in close collaboration with a multidisciplinary team in other BICC and IT departments. A major focus is backend development for this layer, which means, responsible for the development of required data structures, data marts, massaging of the data, and their transfer into regular service operation. Within the BI Laboratory Approach role could be responsible for the development of ETLs from source systems into the Data Warehouse, as well as for creating a consistent database. BI-LAB means a system, an application, a database for trials, experiments, tests investigations, etc. in BICC responsibilities. BI Lab environments might be delivering data and information for a regular business workflow but their own technical basis is still in a pre-operational phase. It helps to stabilize, and specify unclear and fast-changing business requirements in an agile and encapsulated environment. Our BI major tasks and activities are organized in the 3 processes - . Demand Fulfilment Process (DeFuP) . BI Service Operation Process (BISOP) . Service Support Process (SeSuP) The assistance of DeFuP by participating in different projects, larger programs, or small requests will be the emphasis of regular work. Support of BISOP and SeSuP in particular in case of critical issues and problem analysis are required as well. Should be able to handle the team and the requirements of the customer. Key Accountabilities : Data Preparation for Data Marts and BI Applications. Develop & maintain (3rd level support) SQL/Bteq scripts to prepare and provide data for BI Application Layer. Fixing problems in cooperation with internal and external partners (e.g. Service owner, Tech. Support Team, IT-Ops) Designing and implementing changes to the existing data model Develop & maintain relational staging areas of BI Application Layer Supporting operations team on data quality, data consistency issues and essential business critical processes Conducting preventative maintenance of the systems Drive system optimization and simplification Responsible for performance of data on BI Application Layer and optimisation of the data preparation in conjunction with the reporting team/tool Supporting business users in system handling and optimizing Essential : 7-11 years strong BI and Data Warehouse development experience Strong SQL experience - Advanced level of SQL (Teradata) scripting and/or Oracle ODI programming Excellent data interpretation skills Good knowledge of data warehouse and a business intelligence, good understanding of range of data manipulation and analysis techniques Working knowledge of large information technology development projects using methodologies and standards Excellent verbal, written and interpersonal communication skills, demonstrating the ability to communicate information technology concepts to non-technology personnel, should be able to interact with client team and share ideas. Strong analytical, problem solving and decision-making skills, attitude to plan and organize work to deliver as agreed Ability to work under pressure to tight deadlines. Hands on experience working with large datasets Desired : Good skills in Microsoft Excel incl. VBA/Macro Good knowledge of Unix/Linux command line Basic understanding of Unix shell scripting Basic understanding of SAS scripting Telecommunication experience