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 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 ETL 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 into 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. 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 the 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 the performance of data on the BI Application Layer and optimization of the data preparation in conjunction with the reporting team/tool Supporting business users in system handling and optimizing Essential: 3-8years of 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 business intelligence, a good understanding of the 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 the client team and share ideas. Strong analytical, problem-solving, and decision-making skills, attitude to planning 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 Excellent communication skills (business and technical) Written and verbal English language Ability to respond quickly to issues and risks Ability to highlight possible issues proactive Orientated for process improvements Being a problem solver Team player, Works collaboratively with other team members to deliver tasks Strong ability to understand complex system landscape configuration considering the E2E view Key Skills: Teradata Developer (Bteq, MLoad, Fast Load, MiltiLoad &, etc.) SQL

Monster