Deputy Manager_Information Architect

Location

Pune | India

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 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.

#_VOIS

Key accountabilities (Role Description)

• 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 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 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, 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 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

Job tags

Salary