Sr Analyst Analytics


Bangalore, KA, IN

REQ ID:  43922

Kennametal Inc. (NYSE: KMT) brings together materials science, technical expertise, innovative thinking and superior customer service to help the world fly, drive, power and build. Our tools, materials and wear-resistant solutions enable customers to run longer, cut faster and machine with greater precision. Kennametal is built for performance, and every day approximately 8,700 employees are helping customers in more than 60 countries stay competitive. Kennametal generated $2.0 billion in revenues in fiscal 2022.

Learn more at Follow @Kennametal: Twitter, Instagram, Facebook, LinkedIn and YouTube.


Job Title: Sr Analyst Analytics

Job Location: Bangalore


Job Summary:

Senior Analyst – Analytics has a strong technical background in the Enterprise Reporting/Analytics area. Has strong fundamentals around the ETL, 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 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 responsibilities:

  • Take complete ownership of the Analytics System from technical perspective.
  • Create ETL flows for new reporting models. Maintain and Enhance the existing ones.
  • 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 bottle-necks in the report and resolve the same.
  • Provide good solutions/approaches for any complex requirements.
  • Provide expert advice to DW team members with issues needing technical expertise or complex systems and/or programming knowledge.
  • Understanding the data that will be available on Source Systems in business terms.
  • Proficient in customization and configuration of MSBI product suite
  • Proficient in all three components of MSBI (SSIS/SSRS/SSAS)
  • Ability to evaluate technical approaches and discuss pros and cons of each to arrive at a design.
  • Should have excellent understanding of MS SQL Server Architecture.
  • Good Functional Knowledge in the areas of Sales & Distribution, Material Management, Finance and Production Planning preferably on a SAP ECC system.
  • Strong Data warehousing and Data Modelling Concepts.
  • Strong data modelling experience on either SAP BW / SAP HANA.
  • Strong T-SQL knowledge is highly desired.
  • Hands-on any of the Self-Serve/Front-End Reporting tools like Tableau, Power BI etc.
  • Excellent Knowledge on ETL/ELT (Data extraction, data transformation and data load processes) on MSBI platform.
  • Aware of the standard Change management and Project management processes.
  • This role will focus on Support, Enhancements and new Projects.


Preferred Areas of Education, Certifications, and Skills:

  • Worked on core Datawarehouse/ Analytics / Enterprise Reporting related platform and projects > 6 years.
  • Strong hold on MSBI Analytics suite (SQL DB/SSMS/SSRS/SSAS) is highly desirable.
  • Strong T-SQL/ PL-SQL Programming skills are highly desirable.
  • Strong ETL and Data Modelling skills.
  • Worked on other data warehouse platforms like SAP BW, SAP BW on HANA with willingness to move to Microsoft platform.
  • Hand-On with any of the visualization tools like Tableau/Power BI etc.
  • Knowledge of any other programming languages like R , Python, Pyspark will a plus.


Years of Relevant Work Experience Required: 6 -10 Years.


Minimum Level of Education (for Job): Bachelor’s degree.



Equal Opportunity Employer

Job Segment: SAP, Analytics, Machinist, Materials Science, ERP, Technology, Management, Manufacturing, Science