Principal Analyst - Global BI Database (3-7 Yrs) Bangalore (Systems/Product Software)

1. PURPOSE OF ROLE : - This role is accountable for the health of the Global BI applications, its expected to keep the applications up and running for business continuity.
-Guarantee the issue resolution and bug fixes within the SLA.
-Develop a high-level expertise in the business areas supported by Global BI in order to assist all stakeholders once any question arrives.
-Implement enhancements/efficiencies in the technologies that are part of the BI scope in accordance with the business demands.
-Implement enhancements/efficiencies in the technologies that are part of the BI scope.
-Work and resolve the compliance/security issues raised on the applications and also work on vulnerabilities raised on the applications with different vendors as needed and track to resolution.
-Work with different functions/towers based on demand basis to save costs from outsourcing to third parties - Your critical KPIs are Resolution on Time, Unavailability, Changes delivered on time, Automation. 2. KEY TASKS AND ACCOUNTABILITIES : - Incident/SR resolution: Review the issue raised and provide the appropriate solution fast and right at the first time.
-Change Requests/Enhancements: Work with different functions or stakeholder as per demand basis and provide the technology expertise to build sustainable solutions.
-Efficiencies: Build automations/BOTs wherever possible.
-Crisis Management: To be able to handle crisis situations such as application unavailability and assist technically to recover as soon as possible.
-Communication: Work with different vendors across the globe to receive transition on the Global BI applications. 3. BUSINESS ENVIRONMENT : - Main Characteristics: Challenges - Be a subject matter expert to the business teams on the technologies resource work upon - Maintain effective relationship with stakeholders and address their concerns throughout the monthly processes.
-Be closely connected with partners and vendors in order to resolve any production issues or change deployments - Evaluation Criteria (Targets): - KPI1: Resolution on Time (SLA) - KPI2: 99.6% Unavailability - KPI3: Change delivered on time Key Dimensions and Contact : - Global Director Solutions Operations and Delivery - Global Security Compliance - Zonal Expert Users - 3rd party vendors (developers and support) - All users community (employees in all levels on the organization) - Geographical Scope: - Global 4. QUALIFICATIONS, EXPERIENCE, SKILLS : Level of educational attainment required : - Bachelors or Masters - Computer Science or Engineering - Professional qualifications and accreditations/memberships required: - Expert knowledge on database technologies like SAP HANA, MySQL, SQL server, - Expert knowledge on Hadoop - Additional knowledge on tools such as Cloudberry, Shell scripts, Hive - Excellent Communication and Problem Solving skills Previous work experience required : - Expert knowledge on database technologies like SAP HANA, MySQL, SQL server, - Expert knowledge on Hadoop - Experience in unit testing and validating the code written - Strong knowledge on debugging skills - Advanced level of expertise in Big data or DB tools with the ability to design complex queries or ingestion processes - Basic understanding of self-service reporting - Experience in CPG company strongly preferred - Strong Analytical analysis using Advanced Excel.
-Some scripting knowledge (like python, shell) is preferable (not mandatory).
-Admin knowledge on tools strongly preferred.
-Language skills required - English (Fluent) IT skills required : - SAP HANA, Hadoop, Hive, MySQL, SQL Server - Cloudberry, Shell scripts strongly preferred - Microsoft Office (mandatory) - Strong knowledge on Databases, data management, SQL - Knowledge on any cloud platforms(Azure, AWS etc.,) - Advanced Excel - Macro creation

Required Skills : English