HR Data Analyst

Job Type: Officer of Administration

• Bargaining Unit:
• Regular/Temporary:
  Regular
• End Date if Temporary:
• Hours Per Week: 35
• Standard
  
  Work Schedule:
• Building:
• Salary Range: $80,000 - $95,000

The salary of the finalist selected for this role will be set based on a variety of factors, including but not limited to departmental budgets, qualifications, experience, education, licenses, specialty, and training. The above hiring range represents the University s good faith and reasonable estimate of the range of possible compensation at the time of posting.

Reporting to Associate Director of Compensation, the HR Data Analyst is a key contributor within the central Columbia University Human Resources (CUHR) group, primarily providing compensation analyses and support related to the department’s administrative processes. In addition, the role will be involved in data analytics and reporting for these and other HR functions. The ideal candidate possesses strong analytical skills, meticulous attention to detail, and a collaborative approach to enhancing operations and supporting informed decision-making.

• Prepare annual compensation survey submissions for Willis Towers Watson, Mercer, Western Management, and others, as needed.
• Support the review of daily requests regarding additional compensation payments.
• Support the annual merit increase process and the development of salary ranges. Prepare and test the system used to process compensation changes, maintain user tables, prepare data loads and audit reports.
• Evaluate and classify job descriptions using institutional job architecture and technology-enabled tools, applying consistent leveling across the university.
• Partner with HR Business Partners by providing precedent, comparative analysis, and trend insights to support consistent job description management across schools and departments.
• Work with HR Business Partners to provide data analysis related compensation in support of strategic client initiatives.
• Prepare CUHR financial and administrative reports.
• Work with the Recruitment team to provide data and analysis to support Talent Search Services recruitment and hiring program’.
• Develop and maintain dashboards and recurring reports on headcount, turnover, engagement, and other workforce metrics.
• Work with IT and HR to improve system processes, workflows, and reports.
• Contribute to the development, writing, editing and modification of operating policies, guidelines and procedures.
• Perform audits to verify adherence to governance, regulatory, and confidentiality standards, including audits related to FLSA and NYSDOL, external surveys and regulatory filings.
• Create ad hoc analyses and provide recommendations to support HR decision making and operational improvements.

• Bachelor s degree or its equivalent.
• A minimum of 3 years of related experience.

• Experience with process management/improvement preferred.
• Experience with running SQL queries in AQT and/or SQL Developer

• 3+ years of experience in HR analytics, Compensation, and/or HRIS.
• Proficiency with Excel and experience using HR systems (People Soft preferred).
• Strong analytical skills and attention to detail.
• Ability to effectively collaborate with colleagues across HR functions.
• Excellent organizational, verbal, and written communication skills.
• Maintains professionalism in handling sensitive HR information
• Ability to manage multiple priorities in a collaborative, fast-paced environment.
• Comfortable discussing complex data with both technical and non-technical audiences.
• Advanced Microsoft Excel Skills, including pivot tables, VLOOKUP/XLOOKUP, Power Query, macros, and data validation.
• Data visualization (e.g., Power BI, Tableau).
• Experience with compensation benchmarking tools (e.g., Market Pay, Comp Analyst).
• Ability to translate data into insights for non-technical audiences.
• Experience applying technology and emerging tools, including artificial intelligence (AI)

Equal Opportunity Employer / Disability / Veteran

Columbia University is committed to the hiring of qualified local residents.