Compensation & HR Reporting Analyst

Applied-Optoelectronics-Inc; Sugar Land (TX); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Health benefits

401(k) match

PTO with payout

Relocation assistance

Job summary

Applied Optoelectronics, Inc. (AOI) in Sugar Land, TX, seeks a Compensation & HR Reporting Analyst to develop competitive pay programs and executive dashboards. You will transform ADP data into clear workforce metrics for leadership, supporting salary administration, planning, and growth.

Ideal candidates have 5+ years of compensation analysis, manufacturing experience, and strong Excel skills. This onsite role partners with Finance, Payroll, and HR to inform decisions and drive equity across

Qualifications

• Bachelor's degree or higher in HR, Finance, Business, Economics, Statistics, Data Analytics, or 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

Advanced Excel

Analytical skills

Strong communication

Detail-oriented

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

Build a Brighter Future with AOI: Join Our Team of Visionaries

Share with friends or Subscribe!

Current job opportunities are posted here as they become available.

Applied Optoelectronics, Inc. (AOI) is a leading developer and manufacturer of advanced optical, semiconductor, and HFC networking products that support AI datacenters, cable broadband, telecom, FTTH, and fiber access networks around the world. Headquartered in Sugar Land, Texas, AOI is a vertically integrated company that designs and manufactures products ranging from semiconductor laser chips and optical components to high-speed optical transceivers and HFC networking equipment. AOI's operations include semiconductor chip R&D in Sugar Land, dedicated cable and fiber product R&D in Atlanta, and manufacturing operations across Texas, Taiwan, and mainland China. Publicly traded on the Nasdaq (AAOI), AOI is actively expanding its U.S.-based manufacturing operations in Sugar Land to meet accelerating demand in the AI datacenter market.

Summary

The Compensation & HR Reporting Analyst serves as AOI's subject matter expert in compensation analysis, workforce analytics, executive reporting, and HR data strategy. This role partners with HR, Finance, Payroll, IT and executive leadership to develop competitive compensation programs, maintain internal equity, and provide meaningful workforce insights that support strategic business decisions.

The successful candidate will possess advanced experience supporting compensation within a manufacturing environment and advanced Microsoft Excel skills. This position transforms complex ADP Workforce Now data into executive dashboards and reporting that simplify workforce metrics for leadership while supporting compensation strategy, salary administration, workforce planning, and organizational growth.

Job 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.

Qualifications

Candidates must be authorized to work in the United States. Visa sponsorship is not available for this position.

Required

• Bachelor's degree in Human Resources, 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.

Preferred

• Experience with Power BI, SQL, Tableau, or other business intelligence tools.
• Experience supporting a publicly traded organization.
• Knowledge of the Fair Labor Standards Act and Equal Pay Act.
• Bilingual proficiency in Chinese, Spanish, or Vietnamese

This is a full-time onsite position based at AOI's Sugar Land, Texas campus, a combined office, warehouse, and manufacturing environment. The role is primarily office-based and works closely with the Talent Acquisition team, hiring managers, and HR partners across the business.

Typical business hours are Monday through Friday, 9:00 a.m. to 6:00 p.m. CT, with flexibility required during peak hiring periods and other business-critical windows.

Why AOI?

In addition to competitive salary, AOI offers:

• Flexible and competitive health benefits, including medical, dental, and vision plans designed to meet individual and family needs
• Employer matching on 401(k) deferrals
• Generous PTO policy, with unused PTO payout at end of the year
• Relocation packages available within the United States.

Applied Optoelectronics, Inc. (AOI) is committed to providing equal opportunity in all of our employment practices, including hiring, placement, promotion, training, transfer and compensation, to all qualified applicants and employees without regard to race, color, national origin, citizenship, religion, sex, veteran status, age, disability, marital status, or any other category protected by State or Federal law. Moreover, we endeavor to treat our employees fairly.

We do not accept unsolicited proposals from third-party recruiters or agencies. Contacting hiring managers directly may result in disqualification of submissions.