Operations Excellence Analyst

Job Responsibilities:

• Own end-to-end KPI reporting includes data extraction validation calculations dashboards visualization and issue escalation processes.
• Build maintain and enhance Excel-based KPI dashboards and standardized reporting templates supporting operations leadership decisions.
• Ensure dashboards remain accurate scalable repeatable and resilient when data structures volumes or sources change.
• Apply advanced Excel skills including pivot tables complex formulas structured tables dynamic charts data validation.
• Perform variance analysis on production metrics to understand deviations identify risks and improvement opportunities proactively.
• Identify unstable or inefficient processes through KPI trends data analysis issue tracking and collaboration efforts.
• Communicate performance trends risks and opportunities clearly to operations leadership and customer stakeholders using data.  

Skills:

• Advanced Microsoft Excel expertise including pivot tables structured tables complex formulas dynamic charts and validation.
• Strong analytical ability interpreting KPI dashboards identifying trends anomalies performance gaps and operational improvement opportunities.
• Experience developing maintaining and enhancing Excel-based reporting dashboards supporting operational performance monitoring and decision-making processes.
• Ability translating complex production data into clear insights narratives and actionable recommendations for stakeholders effectively.
• Knowledge of KPI definitions calculation logic reporting standards and consistent operational performance measurement practices frameworks.
• Strong problem-solving mindset using data analysis variance investigation and KPI trends to identify issues early.

Education/Experience:

• Advanced proficiency in Microsoft Excel including pivot tables complex formulas structured tables dynamic charts required.
• Experience owning or maintaining Excel-based KPI dashboards and recurring operational reporting processes in organizations.
• Professional experience working within production or operations environments supporting performance monitoring analysis and reporting functions.
• Strong understanding of KPIs performance metrics variance analysis and operational data interpretation principles and practices.
• Demonstrated ability analyzing operational problems summarizing issues and recommending corrective actions supported by data analysis.
• Experience supporting root cause analysis corrective action initiatives or continuous improvement activities within operational environments.
• Familiarity with statistical analysis tools such as Minitab or visualization platforms like PowerBI for analysis.