Power BI & Data Analytics Specialist (SAP & Excel Expert)

Job Description

Position: Data Analyst

Department: Manufacturing Planning

Industry: Electronics Manufacturing Services (EMS)

Location: Mysore

Reports to: Plant Head.

Job Title: Power BI & Data Analytics Specialist (SAP & Excel Expert)

Job Summary:

We are looking for a highly skilled Power BI & Data Analytics Specialist with strong expertise in SAP systems, Advanced Excel, and data visualization. The ideal candidate will extract, transform, and analyze data from SAP and other sources to build insightful Power BI dashboards and reports that drive informed business decisions.

You will play a key role in turning complex SAP data and operational information into clear, actionable insights through interactive dashboards, advanced analytics, and automated reporting solutions.

Key Responsibilities:

• Design, develop, and maintain interactive Power BI dashboards and reports for business stakeholders.
  
• Extract, transform, and load (ETL) data from SAP modules (e.g., SAP ECC, S/4HANA, MM, PP, SD, FI/CO) into Power BI using Power Query and other connectors.
  
• Build robust data models using Star Schema, relationships, and optimization techniques in Power BI.
  
• Write complex DAX formulas for advanced calculations, KPIs, and measures.
  
• Leverage Advanced Excel skills (Power Pivot, Power Query, VBA Macros, Pivot Tables, VLOOKUP/XLOOKUP, dashboards) for data analysis and quick reporting.
  
• Perform data analysis to identify trends, patterns, and insights to support decision-making in production, supply chain, finance, or operations.
  
• Collaborate with business users and leadership to gather requirements and translate them into technical specifications.
  
• Ensure data accuracy, consistency, and integrity across SAP, Excel, and Power BI environments.
  
• Automate repetitive reporting processes using Power BI, Excel, and Power Automate where possible.
  
• Provide training and support to end users on Power BI reports and self-service analytics.
  
• Troubleshoot and optimize report performance and data refresh issues.
  

Required Skills & Qualifications

• Power BI Expertise: Strong hands-on experience in Power BI Desktop & Service, Dataflows, Row-Level Security (RLS), bookmarks, and publishing workspaces.
  
• Data Analytics: Proven experience in data analysis, visualization, and storytelling.
  
• SAP Expertise: Good functional knowledge of SAP (ECC or S/4HANA) with experience in data extraction using SAP tables, queries, or CDS views. Knowledge of multiple SAP modules is a big plus.
  
• Advanced Excel: Expert-level proficiency in Excel including Power Query, Power Pivot, complex formulas, macros (VBA), and dashboard creation.
  
• SQL: Strong SQL skills for data querying and analysis.
  
• Data Modeling: Experience with relational data modeling and DAX.
  

Education: Bachelor’s degree in Computer Science, Information Technology, Statistics, Engineering, or related field.

Experience: 4–8 years of relevant experience in data analytics with a focus on Power BI and SAP environments.

Preferred Skills:

• Experience with SAP S/4HANA Analytics or SAP Datasphere / SAC.
  
• Knowledge of Python or R for advanced analytics.
  
• Familiarity with Power Automate and Power Apps.
  
• Experience in Manufacturing, Supply Chain, or Production environments.
  
• Understanding of data governance and security best practices.