Operations Excellence Analyst

SGS Consulting; Austin (TX); On-site; USD 70,000 - 110,000; Full time

Job summary

SGS Consulting is seeking a data-driven KPI analyst to own end-to-end KPI reporting, from data extraction through dashboard visualization. You will build and maintain Excel-based KPI dashboards and standardized reporting templates to support operations leadership decisions.

The role requires advanced Excel skills, structured data analysis, and proactive variance investigations. You will translate complex production data into clear insights, identify trends and risks, and communicate actionable

Qualifications

• Advanced Excel proficiency required.
• Experience owning or maintaining KPI dashboards.
• Experience in production or operations environments.
• Knowledge of KPIs, variance analysis and performance measurement.
• Familiarity with PowerBI for analysis.

Responsibilities

• Own end-to-end KPI reporting from data extraction to dashboards.
• Build and maintain Excel KPI dashboards and reporting templates.
• Apply advanced Excel skills including pivot tables, formulas, structured tables, dynamic charts and validation.
• Perform variance analysis on production metrics to understand deviations and identify risks.
• Communicate performance trends, risks and opportunities to leadership and stakeholders using data.

Skills

Microsoft Excel

Pivot tables

Structured tables

Complex formulas

Dynamic charts

Data validation

Data analysis

KPI reporting

Power BI

Minitab

Tools

Microsoft Excel

Power BI

Minitab

Job description

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.