Manufacturing Compensation & HR Insights Analyst

AOI; Houston (TX); On-site; USD 85,000 - 120,000; Full time

Benefits offered by this job

Health benefits

401(k) matching

PTO with payout

Relocation packages within the United 

Job summary

Applied Optoelectronics, Inc. (AOI) in Sugar Land, TX, seeks a Compensation & HR Reporting Analyst to lead compensation analysis, benchmarking, and executive reporting. You will transform ADP Workforce Now data into meaningful dashboards and deliver workforce insights for salary strategy and growth.

The role requires advanced Excel skills, experience in manufacturing, and collaboration with HR, Finance, and Talent Acquisition to optimize compensation programs and internal equity.

Qualifications

• Bachelor's degree in HR, Finance, Business, Economics, Statistics, Data Analytics, or a related field.
• 5+ years of compensation analysis experience, including 3+ years in manufacturing or a similarly complex hourly payroll environment.
• Advanced Microsoft Excel proficiency, including PivotTables, XLOOKUP, Power Query, or similar tools.
• Experience with ADP Workforce Now or a comparable HRIS.
• Experience with market pricing, salary surveys, compensation benchmarking, and internal equity analysis.
• Knowledge of compensation principles, practices, and applicable regulations.
• Strong analytical, presentation, written, and verbal communication skills.
• Detail-oriented, highly organized, adaptable, and able to manage multiple priorities.

Responsibilities

• Lead compensation analysis for promotions, market adjustments, merit increases, transfers, and new hire offers.
• Review/edit internal job descriptions to ensure compensation alignment to market.
• Conduct manufacturing compensation benchmarking and salary surveys.
• Maintain salary structures, pay grades, and compensation guidelines.
• Perform internal equity, pay compression, and market competitiveness analyses.
• Develop executive dashboards and HR metrics using ADP Workforce Now data.
• Create recurring reports for headcount, turnover, compensation, overtime, hiring, retention, labor costs, and workforce trends.
• Build advanced Excel dashboards, forecasting models, and automated reports using Power Query, Pivot Tables, XLOOKUP, and Power Pivot.
• Present workforce analytics and compensation recommendations to HR and executive leadership.
• Partner with Finance, Payroll, Talent Acquisition, and Operations on strategic reports and working with large data sets to simply for workforce planning decisions.
• Recommend process improvements and reporting automation.
• Other duties as assigned.

Skills

Excel

Data analysis

Analytical thinking

Presentation skills

Strong communication

Education

Bachelor's degree in HR, Finance, Business, Economics, Statistics, Data Analytics, or related field

Tools

ADP Workforce Now

Power BI

SQL

Tableau

Job description

Applied Optoelectronics, Inc. (AOI) in Sugar Land, TX, seeks a Compensation & HR Reporting Analyst to lead compensation analysis, benchmarking, and executive reporting. You will transform ADP Workforce Now data into meaningful dashboards and deliver workforce insights for salary strategy and growth.

The role requires advanced Excel skills, experience in manufacturing, and collaboration with HR, Finance, and Talent Acquisition to optimize compensation programs and internal equity.