Analyst Analytics-India (Data Analytics - Azure or MSBI Analytics)

With over 80 years as an industrial technology leader, Kennametal Inc. delivers productivity to customers through materials science, tooling and wear-resistant solutions. Customers across aerospace, earthworks, energy, general engineering and transportation turn to Kennametal to help them manufacture with precision and efficiency. Every day approximately 10,000 employees are helping customers in more than 60 countries stay competitive. Kennametal generated nearly $2.4 billion in revenues in fiscal 2019. Learn more at www.kennametal.com. Follow @Kennametal: Twitter, Instagram, Facebook, LinkedIn and YouTube.

Role: - Analyst, Data Analytics

Location: - Bangalore

Experience: - 3 – 5 Years

Job Summary

• Analyst – Analytics has a strong technical background in Data Engineering,  Enterprise Reporting, and Analytics area.
• Has strong fundamentals in ETL, Data pipelining, Datawarehouse Modelling and Report building skills.
• Has good understanding of the functional aspects of the business and can interact with the business.
• Has a natural flair towards learning new things in the technical space and stay aligned with the company’s Analytics roadmap. Has a customer-first attitude and passionately interacts with the Data Scientist team and other Business users, respond to their queries, and solve their day-to-day issues and reporting requirements.
• And most importantly Is a great Team Player. 

Key Job Responsibilities

• Take complete ownership of the Analytics System from technical perspective (MLOps).
• Knowledge of popular open-source libraries such as Scala, Spark, Pandas, Hadoop, and Kafka.
• Take ownership for the daily data refreshes from source to the Datawarehouse.
• Participate with business users for requirement gathering and convert that into a technical design document.
• Identify the performance bottlenecks in the report and resolve the same.
• Should have excellent understanding of MS SQL Server Architecture.
• Good Functional Knowledge in the areas of Material Management Production Planning, preferably on SAP ECC system.
• Strong Data Warehousing, Data Infrastructure, Data mining, Metadata management and Data Modelling Concepts.
• Strong Data Modelling experience on either SAP BW / SAP HANA.
• Strong T-SQL knowledge is highly desired.
• Provide expert advice to DW team members with issues needing technical expertise or complex systems and/or programming knowledge.
• Proficient in customization and configuration of MSBI product suite.
• Proficient in all three components of MSBI (SSIS/SSRS/SSAS).
• Excellent Knowledge on ETL/ELT (Data extraction, data transformation and data load processes) on Azure or MSBI platform.
• Aware of the standard Change management and Project management processes.
• This role will focus on Support, Enhancements, and New Projects.

Required Skillset:

1. Worked on core Data Warehouse, Analytics, Enterprise Reporting related platform and projects > 2 years.
2. Support Data Engineering efforts on Azure or MSBI Analytics suite (SQL DB/SSMS/SSRS/SSAS).
3. Working knowledge of Azure Data Warehouse, Azure Synapse, Azure Data Factory is highly desired.
4. Strong T-SQL/ PL-SQL Programming skills are highly desirable.
5. Strong ETL and Data Modelling skills.
6. Worked on other Data Warehouse platforms like SAP BW, SAP BW on HANA with willingness to move to Microsoft platform.
7. Hand-On with any of the visualization tools like Tableau/Power BI etc.
8. Knowledge of any other programming languages like Python, Scala, Pyspark will a plus.

Kennametal is an Equal Opportunity Employer