HR Data & Compensation Analyst (Contract)

Location: Houston, TX | Contract Duration: 3 – 6 months | Compensation: commensurate with experience

Position Summary

The HR Data & Compensation Analyst will provide analytical and technical support across annual compensation administration and broader HR reporting initiatives. A significant focus will be preparing and managing the organization's annual salary administration spreadsheet, including developing formulas and calculations necessary to support the process. The Analyst will also prepare total compensation statements, support equity administration and annual LTI statements, and develop HR dashboards and recurring people metrics for leadership. This is a hands-on role requiring exceptional Excel skills, data accuracy, attention to detail, and discretion when working with sensitive employee and compensation information.

Essential Responsibilities

• Prepare, build, and manage the annual salary administration spreadsheet used to support the organization's compensation cycle.
• Develop and maintain advanced Excel formulas, calculations, data validations, and supporting analyses required for salary administration.
• Organize, validate, reconcile, and analyze employee and compensation data to ensure accuracy throughout the annual compensation process.
• Prepare annual Total Compensation Statements for employees.
• Support equity administration activities and preparation of annual Long-Term Incentive statements.
• Build and maintain an HR dashboard that provides leadership with visibility into key workforce data.
• Develop recurring people metrics and workforce reports for use by leadership.
• Gather, organize, analyze, and translate HR data into clear and decision-useful reporting.
• Develop efficient reporting tools and processes that reduce manual effort and improve the consistency and accessibility of HR information.
• Perform data validation and quality checks to maintain confidence in workforce and compensation reporting.
• Support HR data management, reporting, and analytics projects as business needs arise.
• Consolidate information from multiple data sources to support HR analysis and reporting.
• Maintain organized and well-documented spreadsheets, databases, reports, and supporting files.
• Handle confidential employee, compensation, and equity information with a high degree of discretion and professionalism.

Qualifications

• Demonstrated experience working with HR, workforce, compensation, or employee data strongly preferred due to the confidential nature of the information.
• Advanced to expert-level Microsoft Excel skills, including the ability to independently build complex spreadsheets, formulas, calculations, reporting tools, and data models.
• Experience with HR analytics, HR reporting, compensation analysis, or workforce reporting.
• Experience preparing or supporting salary administration, annual compensation cycles, total compensation statements, equity administration, or LTI reporting preferred.
• Strong proficiency with database management, reporting, and data manipulation tools.
• Experience developing HR dashboards, people metrics, KPI reporting, or executive-level reporting.
• Strong analytical and problem-solving skills with exceptional attention to detail and data accuracy.
• Ability to independently manage detailed analytical work and deliver accurate outputs against defined deadlines.
• High degree of discretion, judgment, and integrity when handling confidential employee and compensation information.

What Success Looks Like

You are the person HR can trust with a complex compensation spreadsheet and sensitive workforce data. You can take large datasets, build the formulas and structure necessary to make them usable, validate the underlying information, and translate the results into accurate compensation outputs, dashboards, and executive-level people metrics. You combine the technical capabilities of a strong data analyst with enough HR and compensation knowledge to understand the information you are working with—and why getting it right matters. If you're an experienced HR Data, People Analytics, or Compensation professional with advanced Excel skills and are interested in a hands-on contract opportunity supporting a critical annual compensation cycle, contact us at recruiting@novasolutions.ai to learn more.